Discussion:
postmaster -i option...
(too old to reply)
Taber, Mark
2004-10-18 21:07:16 UTC
Permalink
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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org
Tom Lane
2004-10-18 22:10:16 UTC
Permalink
Post by Taber, Mark
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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Loading...