From: | Jonel Rienton <jonel(at)road14(dot)com> |
---|---|
To: | Joshua D(dot)Drake <jd(at)commandprompt(dot)com> |
Cc: | "Psql_General (E-mail)" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pg_ctl bug or feature? |
Date: | 2005-05-06 20:34:06 |
Message-ID: | 54D4F5D7-2B65-45A7-8E09-2DF27E60BD68@road14.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
-----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-----
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2005-05-06 20:36:10 | Re: pg_ctl bug or feature? |
Previous Message | Fmiser | 2005-05-06 20:32:48 | Re: Howto prevent write based on date |