Re: initdb doesn not create template1 database

Started by Tom Laneabout 25 years ago5 messagesgeneral
Jump to latest
#1Tom Lane
tgl@sss.pgh.pa.us

"mike" <matrix@quadrent.net> writes:

Tom thanks for the heads up on the bug earlier, thngs worked much better ui=
ng the currnet snapshot, though fomr some reason initdb seems to do its job=
though its not creating database template1.

That's an interesting definition of "doing its job" :-(.

How about you show us the exact output you're getting, not an
interpretation?

regards, tom lane

#2Tony Grant
tg001@dial.oleane.com
In reply to: Tom Lane (#1)

On 2001.01.19 03:14:32 +0100 Tom Lane wrote:

That's an interesting definition of "doing its job" :-(.

How about you show us the exact output you're getting, not an
interpretation?

7.0.3 on RedHat 6.2 with kernel 2.4.0

postgres]$ initdb -D /home/postgres
This database system will be initialized with username "postgres".
This user will own all the data files and must also own the server process.

Fixing permissions on pre-existing data directory /home/postgres
Creating database system directory /home/postgres/base
Creating database XLOG directory /home/postgres/pg_xlog
Creating template database in /home/postgres/base/template1
Creating global relations in /home/postgres/base
Adding template1 database to pg_database
/usr/bin/initdb: /tmp/initdb.29795: Permission denied
/usr/bin/initdb: /tmp/initdb.29795: Permission denied
/usr/bin/initdb: /tmp/initdb.29795: Permission denied
/usr/bin/initdb: /tmp/initdb.29795: No such file or directory

initdb failed.
Removing /home/postgres.
rm: cannot remove directory `/home/postgres': Permission denied
Failed.
Removing temp file /tmp/initdb.29795.

Cheers

Tony Grant

--
It's just some computers connected together...

#3Tom Lane
tgl@sss.pgh.pa.us
In reply to: Tony Grant (#2)

Tony Grant <tg001@dial.oleane.com> writes:

/usr/bin/initdb: /tmp/initdb.29795: Permission denied

Pretty odd. Uh, you're sure /tmp is world-writable?

regards, tom lane

#4Tony Grant
tg001@dial.oleane.com
In reply to: Tom Lane (#3)

On 2001.01.19 16:10:33 +0100 Tom Lane wrote:

Tony Grant <tg001@dial.oleane.com> writes:

/usr/bin/initdb: /tmp/initdb.29795: Permission denied

Pretty odd. Uh, you're sure /tmp is world-writable?

Ummmm...

I had a mail server problem that nuked my /tmp directory last week. The new
temp directory on the spare partition didn't have the correct permissions.

I'm quite happy that I knew that it was a permissions problem! But that was
about the only folder I hadn't checked (I had my head stuck in /var/lib...)

Thank you very much kind sir - have a virtual beer on me.

Cheers

Tony Grant

--
It's just some computers connected together...

#5Jan Wieck
JanWieck@Yahoo.com
In reply to: Tom Lane (#3)
Re: Re: initdb doesn not create template1 database

Tom Lane wrote:

Tony Grant <tg001@dial.oleane.com> writes:

/usr/bin/initdb: /tmp/initdb.29795: Permission denied

Pretty odd. Uh, you're sure /tmp is world-writable?

What about umask?

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com