Hi,
I reinstall postgresql 7.4.6 instead of 7.4.8 (still on Solaris 10)
and didn't include postgresql as services that is managed by SMF, and
it works fine so far. Also, I should mentioned that I configured
postgresql 7.4.6 with --enable-thread-safety option, don't know if
this will have anything
Hi,
I was redirected to this maillist when i asked questions on irc. I
hope this is the right mailing list.
I am running postgresql 7.4.8 on solaris 10 (and I compile and
installed slony). Everytime I am trying to reload the configuration
using pg_ctl reload -D $PGDATA, it deleted the
Junaili,
I am running postgresql 7.4.8 on solaris 10 (and I compile and
installed slony). Everytime I am trying to reload the configuration
using pg_ctl reload -D $PGDATA, it deleted the postmaster.pid and
didn't create a new one. So, after reload, the only way I can restart
the server is by
Junaili Lie [EMAIL PROTECTED] writes:
I am running postgresql 7.4.8 on solaris 10 (and I compile and
installed slony). Everytime I am trying to reload the configuration
using pg_ctl reload -D $PGDATA, it deleted the postmaster.pid and
didn't create a new one.
That's very strange. The pg_ctl
Folks,
I am running postgresql 7.4.8 on solaris 10 (and I compile and
installed slony). Everytime I am trying to reload the configuration
using pg_ctl reload -D $PGDATA, it deleted the postmaster.pid and
didn't create a new one. So, after reload, the only way I can restart
the
Josh Berkus josh@agliodbs.com writes:
Looking at his report, what's happening is that the postmaster is shutting
down, but the other backends are not ... they're hanging around as
zombies.
The zombies couldn't be dead backends if the postmaster has gone away:
in every Unix I know, a zombie
Tom,
The zombies couldn't be dead backends if the postmaster has gone away:
in every Unix I know, a zombie process disappears instantly if its
parent dies (since the only reason for a zombie in the first place
is to hold the process' exit status until the parent reads it with
wait()).
yeah,
Hi,
Thank you all for the respond.
I should probably mentioned that postgres is maintained by smf, which
is a service management tool in solaris 10.
I asked our sys admin to remove postgres from being managed by smf.
he did that. But right now he is having problem because the system
could not
Tom,
I am not too sure how to determine the unlink call.
Can you provide more information/instructions?
In my case the pg_ctl reload -D /usr/local/pgsql deleted the
postmaster.pid without creating a new one. I am not too sure if this
is normal.
J
On 5/24/05, Tom Lane [EMAIL PROTECTED] wrote: