On 12/13/12, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > David Noel <david.i.noel@xxxxxxxxx> 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 > > Hm, that eliminates my first theory that the rc.d script is using > initdb's --xlogdir switch to try to put pg_xlog someplace that doesn't > exist on your system. But it seems like this must be some variant of > that. A simple permissions problem is not very credible, because at > this point initdb has successfully made the data directory and a bunch > of files within it already. > > 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? > > regards, tom lane > ygg:/usr/home/ygg> initdb -D /zdb/pgsql/data --noclean ... 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: data directory "/zdb/pgsql/data" not removed at user's request ygg:/usr/home/ygg> ll /zdb/pgsql/ total 2 drwx------ 14 pgsql wheel 18 Dec 13 12:42 data ygg:/usr/home/ygg> ll /zdb/pgsql/data/ total 53 -rw------- 1 pgsql wheel 4 Dec 13 12:42 PG_VERSION drwx------ 3 pgsql wheel 3 Dec 13 12:42 base drwx------ 2 pgsql wheel 2 Dec 13 12:42 global drwx------ 2 pgsql wheel 2 Dec 13 12:42 pg_clog -rw------- 1 pgsql wheel 4467 Dec 13 12:42 pg_hba.conf -rw------- 1 pgsql wheel 1636 Dec 13 12:42 pg_ident.conf drwx------ 4 pgsql wheel 4 Dec 13 12:42 pg_multixact drwx------ 2 pgsql wheel 3 Dec 13 12:42 pg_notify drwx------ 2 pgsql wheel 2 Dec 13 12:42 pg_serial drwx------ 2 pgsql wheel 2 Dec 13 12:42 pg_snapshots drwx------ 2 pgsql wheel 2 Dec 13 12:42 pg_stat_tmp drwx------ 2 pgsql wheel 2 Dec 13 12:42 pg_subtrans drwx------ 2 pgsql wheel 2 Dec 13 12:42 pg_tblspc drwx------ 2 pgsql wheel 2 Dec 13 12:42 pg_twophase drwx------ 3 pgsql wheel 3 Dec 13 12:42 pg_xlog -rw------- 1 pgsql wheel 19713 Dec 13 12:42 postgresql.conf ygg:/usr/home/ygg> ll /zdb/pgsql/data/pg_xlog/ total 2 drwx------ 2 pgsql wheel 2 Dec 13 12:42 archive_status -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
