Re: initdb error

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: David(dot)I(dot)Noel(at)gmail(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: initdb error
Date: 2012-12-13 16:56:21
Message-ID: 50CA08B5.4050101@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 12/13/2012 08:35 AM, Tom Lane wrote:
> David Noel <david(dot)i(dot)noel(at)gmail(dot)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(dot)klaver(at)gmail(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Paul Jungwirth 2012-12-13 17:18:21 Re: JDBC to load UTF8@psql to latin1@mysql
Previous Message Kevin Grittner 2012-12-13 16:47:23 Re: How to keep the last row of a data set?