Re: [ADMIN] Automatically starting postmaster after system crash

2001-10-18 Thread Tom Lane
Allan Engelhardt <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> That's kinda hard to believe; how would a shared memory segment survive >> a system crash? > I don't think they can. Some options: > (1) PostgreSQL keeps a reference to it somewhere and can get confused... Indeed, there is a ref

Re: [ADMIN] Automatically starting postmaster after system crash

2001-10-17 Thread Allan Engelhardt
Tom Lane wrote: > Allan Engelhardt <[EMAIL PROTECTED]> writes: > >>If my (RH 7.1) system crashes PostgreSQL does not restart automatically >>because the shared memory segment identifier and the .pid file remains, >> > > That's kinda hard to believe; how would a shared memory segment survive >

Re: [ADMIN] Automatically starting postmaster after system crash

2001-10-17 Thread Tom Lane
Allan Engelhardt <[EMAIL PROTECTED]> writes: > If my (RH 7.1) system crashes PostgreSQL does not restart automatically > because the shared memory segment identifier and the .pid file remains, That's kinda hard to believe; how would a shared memory segment survive a system crash? > % pg_ctl

[ADMIN] Automatically starting postmaster after system crash

2001-10-17 Thread Allan Engelhardt
Sorry if this is a FAQ, but I couldn't find it. If my (RH 7.1) system crashes PostgreSQL does not restart automatically because the shared memory segment identifier and the .pid file remains, as a manual start explains: % pg_ctl start pg_ctl: Another postmaster may be running. Trying to s