Skip site navigation (1) Skip section navigation (2)

Re: Urgent!

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: codeWarrior <gpatnude(at)hotmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Urgent!
Date: 2005-10-13 16:21:24
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
On Thu, 2005-10-13 at 10:56, Bruce Momjian wrote:
> codeWarrior wrote:
> > Lookas as if you've managed to turn off your computer mid-transaction 
> > thereby corrupting the postgreSQL commit logs (pg_clog)...
> > 
> > You should never just turn off a database server... always shut it down 
> > normally... Turning it off was a major mistake. I dont know if you can 
> > recover or not as the system (postgreSQL) now thinks it is in the middle of 
> > a transaction...
> PostgreSQL should never get corrupted by turning off the server.  It
> isn't ideal to do that, but it should not get corrupted.

Unless it is installed on hardware that lies about fsync.

Which almost all ATA drives, parallel and serial, do, sadly.

In response to

  • Re: Urgent! at 2005-10-13 15:56:48 from Bruce Momjian


  • Re: Urgent! at 2005-10-13 16:23:44 from Bruce Momjian

pgsql-admin by date

Next:From: Bruce MomjianDate: 2005-10-13 16:23:44
Subject: Re: Urgent!
Previous:From: Alvaro HerreraDate: 2005-10-13 16:12:50
Subject: Re: Urgent!

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group