Re: initdb error - Mailing list pgsql-general

From Adrian Klaver
Subject Re: initdb error
Date
Msg-id 50CA08B5.4050101@gmail.com
Whole thread Raw
In response to Re: initdb error  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On 12/13/2012 08:35 AM, Tom Lane wrote:
> David Noel <david.i.noel@gmail.com> writes:
>> I've tried initdb directly:
>> initdb -D /zdb/pgsql/data
>> ...and still seem to wind up with the error:
>> creating template1 database in /zdb/pgsql/data/base/1 ... FATAL:
>> could not open file "pg_xlog/000000010000000000000001" (log file 0,
>> segment 1): No such file or directory
>

>
> You could get more information by using the --noclean switch to prevent
> removal of the datadir after failure, and then having a look at the
> debris.  Is there a pg_xlog subdirectory inside /zdb/pgsql/data, and if
> so what permissions has it got?  Perhaps it is not a directory, but a
> symlink to somewhere else?

Always learning, did not know --noclean existed. That is handy. Thanks.

>
>             regards, tom lane
>
>


--
Adrian Klaver
adrian.klaver@gmail.com


pgsql-general by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: How to keep the last row of a data set?
Next
From: Paul Jungwirth
Date:
Subject: Re: JDBC to load UTF8@psql to latin1@mysql