| From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
|---|---|
| To: | Vivek Khera <khera(at)kcilink(dot)com> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Humor me: Postgresql vs. MySql (esp. licensing) |
| Date: | 2003-10-10 15:37:52 |
| Message-ID: | Pine.LNX.4.33.0310100937140.19056-100000@css120.ihs.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 9 Oct 2003, Vivek Khera wrote:
> >>>>> "SD" == Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in> writes:
>
> SD> Do a shutdown -h on a live database machine with pg. It will
> SD> gracefully shut itself down.
>
>
> I think it is a timing issue. The PG has no way to notify the OS that
> it has finished exiting, so if it takes a long time to exit, the OS
> will ungracefully kill the DB process(es). Doesn't matter what DB (or
> any other application) you're running, you *can* lose data this way.
While it is possible to lose a non-committed transaction, WAL prevents the
database from becoming corrupted. Assuming proper fsyncing of your hard
drives (i.e. SCSI, or IDE with write cache disabled)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas LeBlanc | 2003-10-10 15:52:16 | Execute Function from VB/ADO |
| Previous Message | scott.marlowe | 2003-10-10 15:37:04 | Re: Humor me: Postgresql vs. MySql (esp. licensing) |