Re: initdb error

On 12/13/2012 08:18 AM, David Noel wrote:
> 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

You are doing the above as the database user ex:postgres?

The database user has permissions on /zdb/pgsql/data?

>
> -David
>
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com