Re: pg_ctl bug or feature?

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-----

In response to

Responses

Browse pgsql-general by date

  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