On 12/13/12, Adrian Klaver <adrian.klaver@xxxxxxxxx> 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.klaver@xxxxxxxxx > 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
