While trying to reproduce power outage restart problem I reported
earlier, I have found something odd when pulling the plug on a VM during
a createdb operation.
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: database "bar" does not exist
[EMAIL PROTECTED] ~]$ createdb bar
createdb: database creation failed: ERROR: could not create directory
"base/65536": File exists
[EMAIL PROTECTED] ~]$ createdb bar
CREATE DATABASE
So, running "createdb bar" a second time works. This is probably not a
bug, but I thought I'd mention it anyway as it could potentially cause
problems for people running scripts.
--
-**-*-*---*-*---*-*---*-----*-*-----*---*-*---*-----*-----*-*-----*---
Jon Lapham <[EMAIL PROTECTED]> Rio de Janeiro, Brasil
Personal: http://www.jandr.org/
***-*--*----*-------*------------*--------------------*---------------
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
