Re: [HACKERS] postmaster.pid disappeared

2005-05-26 Thread Junaili Lie
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 t

Re: [HACKERS] postmaster.pid disappeared

2005-05-24 Thread Junaili Lie
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:

Re: [HACKERS] postmaster.pid disappeared

2005-05-24 Thread Junaili Lie
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 start

Re: [HACKERS] postmaster.pid disappeared

2005-05-24 Thread Josh Berkus
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()). y

Re: [HACKERS] postmaster.pid disappeared

2005-05-24 Thread Tom Lane
Josh Berkus 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 process disappear

Re: [HACKERS] postmaster.pid disappeared

2005-05-24 Thread Josh Berkus
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

Re: [HACKERS] postmaster.pid disappeared

2005-05-24 Thread Tom Lane
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

Re: [HACKERS] postmaster.pid disappeared

2005-05-24 Thread Josh Berkus
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 i

[HACKERS] postmaster.pid disappeared

2005-05-24 Thread Junaili Lie
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 postmaster.pi