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/
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
