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

Re: Restart after power outage: createdb

From: Jim Nasby <jim(at)nasby(dot)net>
To: lapham(at)jandr(dot)org
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Restart after power outage: createdb
Date: 2006-09-27 14:18:58
Message-ID: 27C72FDE-D289-475B-BA77-3C4A73D3A4F4@nasby.net (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
On Sep 27, 2006, at 6:24 AM, Jon Lapham wrote:
> Jim Nasby wrote:
>>> [lapham(at)localhost ~]$ psql bar
>>> psql: FATAL:  database "bar" does not exist
>>> [lapham(at)localhost ~]$ createdb bar
>>> createdb: database creation failed: ERROR: could not create  
>>> directory "base/65536": File exists
>>> [lapham(at)localhost ~]$ createdb bar
>> Could this be a timing issue? IE: are you just issuing the first  
>> createdb bar too soon after the database has started?
>> I suspect this is a bug...
>
> Probably not too soon, since postgresql is started by init.d during  
> boot and it is probably a minute or so after that before I can get  
> logged in, open a shell, issue the commands, etc.

My brain is foggy on exactly what rules are used to clean $PGDATA up  
after a crash, but I'm pretty sure it's not supposed to work like  
that. If you can re-test with 8.2RC1 and still reproduce it (please  
watch the logs to make sure crash recovery is complete before you try  
the createdb), I'd ask on pgsql-bugs.
--
Jim Nasby                                            jim(at)nasby(dot)net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)



In response to

pgsql-hackers by date

Next:From: Andrew DunstanDate: 2006-09-27 14:23:13
Subject: psql service parameter
Previous:From: Tom LaneDate: 2006-09-27 14:10:09
Subject: Re: Block B-Tree concept

pgsql-general by date

Next:From: Jim NasbyDate: 2006-09-27 14:28:25
Subject: Re: pl/pgsql NEW variable substitution
Previous:From: Jim NasbyDate: 2006-09-27 14:14:20
Subject: Re: Documenting stored procedures and functions

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