pg_ctl bug or feature?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

your data directory points to /usr/local/pgsql/data2 and you've
started it with -D /usr/local/pgsql/etc

might be something to look at

regards,

- -----
Jonel Rienton
http://homepage.mac.com/jrienton
Software Developer, *nix Advocate

On May 6, 2005, at 3:12 PM, Joshua D. Drake wrote:

PostgreSQL 8.0.2 - Fedora 3

data_directory = '/usr/local/pgsql/data2' # use data in
hba_file = '/usr/local/pgsql/etc/pg_hba.conf' # the host-based #
ident_file = 'ConfigDir/pg_ident.conf' # the IDENT configuration file
external_pid_file = '/tmp/foo.pid' # write an extra pid

as postgres:

-bash-3.00$ bin/pg_ctl -D /usr/local/pgsql/etc start
postmaster starting
-bash-3.00$ LOG: could not open Ident usermap file "/usr/local/
pgsql/etc/pg_ident.conf": No such file or directory
LOG: database system was shut down at 2005-05-06 13:11:18 PDT
LOG: checkpoint record is at 0/A32B20
LOG: redo record is at 0/A32B20; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 544; next OID: 17230
LOG: database system is ready

-bash-3.00$ bin/pg_ctl -D /usr/local/pgsql/etc stop
pg_ctl: PID file "/usr/local/pgsql/etc/postmaster.pid" does not exist
Is postmaster running?
-bash-3.00$

Seems inconsistent? If I can start from etc... I should be able to
stop from it as well.

Sincerely,

Joshua D. Drake
Command Prompt, Inc.

--
Your PostgreSQL solutions company - Command Prompt, Inc.
1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedication Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/

---------------------------(end of
broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

-----BEGIN PGP SIGNATURE-----
Version: PGP Desktop 9.0.0 (Build 2001)

iQA/AwUBQnvUvuAwOVAnbsGCEQKVdgCfdbMaua/yiVNWPorQYx/f1XoKSqwAniuh
V3JsHJvl+QsqT/h+yAsBK+pb
=Ms3D
-----END PGP SIGNATURE-----

Jonel Rienton wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

your data directory points to /usr/local/pgsql/data2 and you've
started it with -D /usr/local/pgsql/etc

might be something to look at

In version 8 you can specify the location of the data_directory with the
data_directory option in the postgresql.conf file. The postgresql.conf
is located in /usr/local/pgsql/etc.

Sincerely,

Jsohua D. Drake
--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedication Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/

"Joshua D. Drake" <jd@commandprompt.com> writes:

data_directory = '/usr/local/pgsql/data2' # use data in

-bash-3.00$ bin/pg_ctl -D /usr/local/pgsql/etc stop

Fixing this would seem to require teaching pg_ctl how to parse the
postgresql.conf file, which might be worth doing but it's a bit of
a large pain in the neck compared to the benefit ...

(For the record, I never did like the file-location-configuration
patch, and one of the reasons is the havoc it plays with the apparently
simple meaning of the -D switch.)

regards, tom lane

I just tried the same setup as yours, and it worked fine, i was able
to start and stop the instance.

could it be that the process didn't start at all when you started it?

regards,

-----
Jonel Rienton
http://homepage.mac.com/jrienton
Software Developer, *nix Advocate

On May 6, 2005, at 3:36 PM, Joshua D. Drake wrote:

you know what does work, if you issue the pg_ctl stop with /usr/local/
pgsql/data2 as the argument for -D

pg_ctl -D /usr/local/pgsql/data2 stop

odd tho.

On May 6, 2005, at 3:36 PM, Joshua D. Drake wrote:

Jonel Rienton wrote:

you know what does work, if you issue the pg_ctl stop with /usr/local/
pgsql/data2 as the argument for -D

pg_ctl -D /usr/local/pgsql/data2 stop

Yes that does work as it should. However as Tom Lane pointed out the
problem is that pg_ctl can't parse the postgresql.conf so if you use the
/usr/local/pgsql/etc it doesn't work for stop.

I have no idea why it works for start though.

Sincerely,

Joshua D. Drake

odd tho.

On May 6, 2005, at 3:36 PM, Joshua D. Drake wrote:

Jonel Rienton wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
your data directory points to /usr/local/pgsql/data2 and you've
started it with -D /usr/local/pgsql/etc
might be something to look at

In version 8 you can specify the location of the data_directory with
the data_directory option in the postgresql.conf file. The
postgresql.conf is located in /usr/local/pgsql/etc.

Sincerely,

Jsohua D. Drake
--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedication Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedication Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/