-----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----- ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings