Re: Help installing PGSQL 7.1 on Linux

From: "Nick Fankhauser" <nickf(at)ontko(dot)com>
To: "Mayan" <escalante(at)canada(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Help installing PGSQL 7.1 on Linux
Date: 2001-11-09 14:39:22
Message-ID: NEBBLAAHGLEEPCGOBHDGOEGPDOAA.nickf@ontko.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

A couple of thoughts:

1) Take a look at the permissions on /usr/local/pgsql/data and make sure
that it exists and it is either owned by postgres or postgres has rw access.
It looks like the initdb process is trying to create it without having the
right permissions on the parent directories. If I were doing this, I think
I'd create it in advance using root & then use chown to make postgres the
owner.

2) When you su to postgres, do an "su - postgres" (the dash makes sure the
you get a shell environment so the .profile gets read.)

hope this helps!

-Nick

--------------------------------------------------------------------------
Nick Fankhauser nickf(at)ontko(dot)com Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko & Co. Software Consulting Services http://www.ontko.com/

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Mayan
> Sent: Thursday, November 08, 2001 8:20 PM
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] Help installing PGSQL 7.1 on Linux
>
>
> Following the instruction at the top of the 'INSTALL' file, I have
> installed PostgreSQL. However, after creating the 'postgres' user
> and su[ing] to the postgres user account, according to the
> 'INSTALL' file, I have to initialized the data base, using the
> following command
>
> '/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data'
>
> After doing so, I get a message that reads:
> "This database will be initialized with user name "postgres".
> This user will own all the data files and must also own the server
> process.
> mkdir: cannot create directory /usr/local/pgsql/data: Permission
> denied.
> initdb failed
> Removing temp file /tmp/initdb.224."
>
> Using the root account to do the installation, I have tried
> about three times to get the installation completed, but I have had
> the same problem all three.
>
> Does anyone know what could be happening?
>
> Thanks in advance
>
> =======================================
> PostgreSQL Installation Instructions
>
> Short Version
>
> ./configure
> gmake
> gmake install
> adduser postgres
> su - postgres
> /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data <<== PROBLEM IS
> HERE
> /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1 &
>
> /usr/local/pgsql/bin/createdb test
> /usr/local/pgsql/bin/psql test
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gurudutt 2001-11-09 15:07:35 Re: problem connecting client to a postgresSQL server
Previous Message Tielman J de Villiers 2001-11-09 14:39:19 Re: problem connecting client to a postgresSQL server