Re: initdb error

On 12/13/12, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> wrote:
> On 12/13/2012 07:38 AM, David Noel wrote:
>> I'm running into the following error message when running initdb (FreeBSD
>> host):
>>
>> ygg# /usr/local/etc/rc.d/postgresql initdb -D /zdb/pgsql/data --debug
>> The files belonging to this database system will be owned by user
>> "pgsql".
>> This user must also own the server process.
>>
>> The database cluster will be initialized with locales
>> COLLATE: C
>> CTYPE: en_US.UTF-8
>> MESSAGES: en_US.UTF-8
>> MONETARY: en_US.UTF-8
>> NUMERIC: en_US.UTF-8
>> TIME: en_US.UTF-8
>> The default text search configuration will be set to "english".
>>
>> creating directory /zdb/pgsql/data ... ok
>> creating subdirectories ... ok
>> selecting default max_connections ... 100
>> selecting default shared_buffers ... 32MB
>> creating configuration files ... ok
>> 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
>> child process exited with exit code 1
>> initdb: removing data directory "/zdb/pgsql/data"
>>
>> My best guess is that it has something to do with permissions, but I
>> really have no idea. Has anyone seen this before and found a way
>> around it?
>
>
> Not quite what is in the the init script in rc.d, have you tried running
> the initdb command directly? As you say I believe there are permissions
> problems. So following the instructions found below may solve your problem:
>
> http://www.postgresql.org/docs/9.2/interactive/app-initdb.html
>
>
>
>>
>> -David
>>
>>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)gmail(dot)com
>

I've tried initdb directly:

initdb -D /zdb/pgsql/data

...and also through pg_ctl:

pg_ctl 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

-David