| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
| Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Alex Satrapa <alex(at)lintelsys(dot)com(dot)au>, "Randolf Richardson, DevNet SysOp 29" <rr(at)8x(dot)ca>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Humor me: Postgresql vs. MySql (esp. licensing) |
| Date: | 2003-11-21 23:11:17 |
| Message-ID: | 16183.1069456277@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Joshua D. Drake" <jd(at)commandprompt(dot)com> writes:
>> I believe 20 seconds is the standard number --- that's plenty for
>> Postgres.
>>
> Not always. More than once I have had a postgresql connection hung up
> that will stop the main postmaster from dying on TERM. However the
> machine will eventually kill it hard and thus could produce during restart.
Seems fine to me. Otherwise such a hangup could prevent system shutdown
indefinitely, which is a Bad Thing when your UPS batteries have thirty
seconds left in 'em ...
You will get a WAL replay at restart in that scenario, but your data
should be perfectly safe.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2003-11-21 23:20:38 | Re: PGSQL on shared hosting |
| Previous Message | Joshua D. Drake | 2003-11-21 23:07:01 | Re: Humor me: Postgresql vs. MySql (esp. licensing) |