pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedCannot initdb for 8.2.1 - "..../postgres.bki" does not exist
4+ messages / 3 participants
[nested] [flat]
* Cannot initdb for 8.2.1 - "..../postgres.bki" does not exist
@ 2007-01-31 01:27 Simon Kinsella <simon@bluefiresystems.co.uk>
2007-01-31 02:23 ` Re: Cannot initdb for 8.2.1 - "..../postgres.bki" does not exist Scott Marlowe <smarlowe@g2switchworks.com>
2007-01-31 04:01 ` Re: Cannot initdb for 8.2.1 - "..../postgres.bki" does not exist Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 2 replies; 4+ messages in thread
From: Simon Kinsella @ 2007-01-31 01:27 UTC (permalink / raw)
To: pgsql-admin
Hello,
I'm trying to install and init 8.2.1 on a FreeBSD 6.2 server. It used to run
8.1.4 no problem. I uninstalled 8.1, renamed /usr/local/pgsql in case I
ever need it (I'm not really bothered about preserving the data) and built
8.2.1 - all fine.
But when I try to initdb:
---
root@cheddar> su -l pgsql
\u@cheddar> /usr/local/bin/initdb -D /usr/local/pgsql/data -E UNICODE
initdb: file "/usr/local/share/postgresql/postgres.bki" does not exist
This means you have a corrupted installation or identified
the wrong directory with the invocation option -L.
---
Tried adding " -L /usr/local/share/postgresql/" (and removing -E) but no
joy.
The .../share/postgresql/ files do exist. Not sure why this is happening
now, it's never happened before. I've got a horrible feeling it's something
embarrassingly simple but I'm stumped. And clues?
Many thanks
---
Simon Kinsella
This message has been scanned for viruses.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Cannot initdb for 8.2.1 - "..../postgres.bki" does not exist
2007-01-31 01:27 Cannot initdb for 8.2.1 - "..../postgres.bki" does not exist Simon Kinsella <simon@bluefiresystems.co.uk>
@ 2007-01-31 02:23 ` Scott Marlowe <smarlowe@g2switchworks.com>
1 sibling, 0 replies; 4+ messages in thread
From: Scott Marlowe @ 2007-01-31 02:23 UTC (permalink / raw)
To: Simon Kinsella <simon@bluefiresystems.co.uk>; +Cc: pgsql-admin
On Wed, 2007-01-31 at 01:27 +0000, Simon Kinsella wrote:
> Hello,
>
> I'm trying to install and init 8.2.1 on a FreeBSD 6.2 server. It used to run
> 8.1.4 no problem. I uninstalled 8.1, renamed /usr/local/pgsql in case I
> ever need it (I'm not really bothered about preserving the data) and built
> 8.2.1 - all fine.
>
> But when I try to initdb:
>
> ---
> root@cheddar> su -l pgsql
> \u@cheddar> /usr/local/bin/initdb -D /usr/local/pgsql/data -E UNICODE
> initdb: file "/usr/local/share/postgresql/postgres.bki" does not exist
> This means you have a corrupted installation or identified
> the wrong directory with the invocation option -L.
I'm go gonna out on a limb here and guess that the files postgresql is
trying to initdb with are 8.1 and not 8.2 version files.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Cannot initdb for 8.2.1 - "..../postgres.bki" does not exist
2007-01-31 01:27 Cannot initdb for 8.2.1 - "..../postgres.bki" does not exist Simon Kinsella <simon@bluefiresystems.co.uk>
@ 2007-01-31 04:01 ` Tom Lane <tgl@sss.pgh.pa.us>
2007-02-05 00:52 ` Re: Cannot initdb for 8.2.1 - "..../postgres.bki" does not exist Simon Kinsella <simon@bluefiresystems.co.uk>
1 sibling, 1 reply; 4+ messages in thread
From: Tom Lane @ 2007-01-31 04:01 UTC (permalink / raw)
To: Simon Kinsella <simon@bluefiresystems.co.uk>; +Cc: pgsql-admin
"Simon Kinsella" <simon@bluefiresystems.co.uk> writes:
> \u@cheddar> /usr/local/bin/initdb -D /usr/local/pgsql/data -E UNICODE
> initdb: file "/usr/local/share/postgresql/postgres.bki" does not exist
> This means you have a corrupted installation or identified
> the wrong directory with the invocation option -L.
> The .../share/postgresql/ files do exist.
Looking at the code, this message is emitted if attempting to stat() the
file fails, regardless of what the actual errno is. So I'm wondering
about permissions problems, specifically inability to search one of the
directories on the path.
We should adjust initdb to report the actual kernel errno value, instead
of presuming that it's "file not found".
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Cannot initdb for 8.2.1 - "..../postgres.bki" does not exist
2007-01-31 01:27 Cannot initdb for 8.2.1 - "..../postgres.bki" does not exist Simon Kinsella <simon@bluefiresystems.co.uk>
2007-01-31 04:01 ` Re: Cannot initdb for 8.2.1 - "..../postgres.bki" does not exist Tom Lane <tgl@sss.pgh.pa.us>
@ 2007-02-05 00:52 ` Simon Kinsella <simon@bluefiresystems.co.uk>
0 siblings, 0 replies; 4+ messages in thread
From: Simon Kinsella @ 2007-02-05 00:52 UTC (permalink / raw)
To: pgsql-admin
Thanks for your input guys - I had to put this problem on hold for a few
days.
In case it helps anyone in a similar boat, this problem seems to have been
due to a umask of 0027. Changing to 022 seems to have fixed it.
Cheers,
Simon Kinsella
-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Tom Lane
Sent: Wednesday, January 31, 2007 4:01 AM
To: Simon Kinsella
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Cannot initdb for 8.2.1 - "..../postgres.bki" does not
exist
"Simon Kinsella" <simon@bluefiresystems.co.uk> writes:
> \u@cheddar> /usr/local/bin/initdb -D /usr/local/pgsql/data -E UNICODE
> initdb: file "/usr/local/share/postgresql/postgres.bki" does not exist
> This means you have a corrupted installation or identified the wrong
> directory with the invocation option -L.
> The .../share/postgresql/ files do exist.
Looking at the code, this message is emitted if attempting to stat() the
file fails, regardless of what the actual errno is. So I'm wondering about
permissions problems, specifically inability to search one of the
directories on the path.
We should adjust initdb to report the actual kernel errno value, instead of
presuming that it's "file not found".
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2007-02-05 00:52 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-01-31 01:27 Cannot initdb for 8.2.1 - "..../postgres.bki" does not exist Simon Kinsella <simon@bluefiresystems.co.uk>
2007-01-31 02:23 ` Scott Marlowe <smarlowe@g2switchworks.com>
2007-01-31 04:01 ` Tom Lane <tgl@sss.pgh.pa.us>
2007-02-05 00:52 ` Simon Kinsella <simon@bluefiresystems.co.uk>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox