From: | Amitabh Kant <amitabhkant(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, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>, PGSQL Mailing List <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: initdb error |
Date: | 2012-12-13 17:42:10 |
Message-ID: | CAPTAQBL0MgpbbY5iSQOw4tZwm_akaUTS9N=wzuw=2a022NX3uw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, Dec 13, 2012 at 10:05 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 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
>
> 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
>
>
Tom
rc.d script doesn't seem to be using --xlogdir anywhere. I have uploaded
the script here:
http://pastebin.com/ahAyZ2tP .
Amitabh
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Kellerer | 2012-12-13 17:43:01 | Re: JDBC to load UTF8@psql to latin1@mysql |
Previous Message | Heikki Linnakangas | 2012-12-13 17:19:36 | pgsql: Allow a streaming replication standby to follow a timeline switc |