Re: initdb error

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