Skip site navigation (1) Skip section navigation (2)

Re: postmaster -i option...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Taber, Mark" <Mark(dot)Taber(at)dof(dot)ca(dot)gov>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: postmaster -i option...
Date: 2004-10-18 22:10:16
Message-ID: 8788.1098137416@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
"Taber, Mark" <Mark(dot)Taber(at)dof(dot)ca(dot)gov> writes:
> I restarted our dev postgres instance today with the -i option, and now,
> using 'ps,', I am not able to see connections to the database any longer.
> The production instance (running only with the -D option) shows the
> connections.  Am I going crazy, missing something obvious?  I'm using the
> command 'ps -ax | grep postgres'

Is this Solaris by any chance?

Solaris' ps has some weird interaction that causes it to not show the
replacement command line unless same is longer than the original.  So
you generally want to keep the postmaster invocation to just
"postmaster"; use a PGDATA environment variable instead of -D, and
specify everything else in postgresql.conf.

			regards, tom lane

In response to

pgsql-admin by date

Next:From: Ashley MaherDate: 2004-10-19 03:14:10
Subject: Re: postmaster stopps
Previous:From: David BeechumDate: 2004-10-18 21:55:04
Subject: PGDATA problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group