pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
postmaster -i option...
2+ messages / 2 participants
[nested] [flat]

* postmaster -i option...
@ 2004-10-18 21:07 Taber, Mark <Mark.Taber@dof.ca.gov>
  2004-10-18 22:10 ` Re: postmaster -i option... Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: Taber, Mark @ 2004-10-18 21:07 UTC (permalink / raw)
  To: pgsql-admin

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'

Thanks,

Mark Taber



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: postmaster -i option...
  2004-10-18 21:07 postmaster -i option... Taber, Mark <Mark.Taber@dof.ca.gov>
@ 2004-10-18 22:10 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2004-10-18 22:10 UTC (permalink / raw)
  To: Taber, Mark <Mark.Taber@dof.ca.gov>; +Cc: pgsql-admin

"Taber, Mark" <Mark.Taber@dof.ca.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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-10-18 22:10 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-10-18 21:07 postmaster -i option... Taber, Mark <Mark.Taber@dof.ca.gov>
2004-10-18 22:10 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox