Re: [HACKERS] [GENERAL] Restart after power outage: createdb

2006-09-27 Thread Tom Lane
Jon Lapham [EMAIL PROTECTED] writes in pgsql-general: If I run... sleep 3; echo starting; createdb bar ...and power off the VM while the createdb bar is running. Upon restart, about 50% of the time I can reproduce the following error message: [EMAIL PROTECTED] ~]$ psql bar psql: FATAL:

Re: [HACKERS] [GENERAL] Restart after power outage: createdb

2006-09-27 Thread Jim C. Nasby
On Wed, Sep 27, 2006 at 04:13:34PM -0400, Tom Lane wrote: Jon Lapham [EMAIL PROTECTED] writes in pgsql-general: If I run... sleep 3; echo starting; createdb bar ...and power off the VM while the createdb bar is running. Upon restart, about 50% of the time I can reproduce the following

Re: [HACKERS] [GENERAL] Restart after power outage: createdb

2006-09-27 Thread Tom Lane
Jim C. Nasby [EMAIL PROTECTED] writes: Then again, if we're doing that, we could probably just nuke 'em... This has been considered and rejected before, on the grounds that removing files you don't know the source of is a good way to lose data. Come to think of it, that argument bears on the

Re: [HACKERS] [GENERAL] Restart after power outage: createdb

2006-09-27 Thread Jim C. Nasby
On Wed, Sep 27, 2006 at 04:52:51PM -0400, Tom Lane wrote: Jim C. Nasby [EMAIL PROTECTED] writes: Then again, if we're doing that, we could probably just nuke 'em... This has been considered and rejected before, on the grounds that removing files you don't know the source of is a good way to