Re: HELP please.. - Mailing list pgsql-admin

From A.Bhuvaneswaran
Subject Re: HELP please..
Date
Msg-id Pine.LNX.4.44.0304101523000.1046-100000@Bhuvan.bksys.co.in
Whole thread Raw
In response to HELP please..  (jp_santosa@yahoo.com (Santosa Budi))
List pgsql-admin
> Dear friends,
>
> I installed v7.2.3 on Redhat 8.0 and now getting some problem. I used
> the installation steps provided in v7.2.3. After installation, I found
> an installation steps online, as below:
>
> 1. Download source file in tgz and unpack
> 2. Create user account to serve the DBA's account
> 3. do ./configure with selected options
> 4. use gmake to build binaries
> 5. gmake install to install the binaries into location selected
> 6. Set the proper PATH for libraries and binaries
> 7. Create directory to hold the databases, change the owner, like the
> following:
>
>    # mkdir /usr/local/pgsl/data
>    # chown user /usr/local/pgsl/data
>    # su - user
>    % /usr/local/pgsql/bin/initdb -D /usr/local/pgsl/data
>
> 8. Start postmaster
> 9. As the DBS, create the users using 'createuser' command
> 10. Switch to the user you created and create the databases 'createdb'
>

Infact step 2 is not required at that stage. You can create that user
(postgres) at step 7. Run initdb as that user. Now he is the database
super user. Start postmaster with log enabled. The postmaster process must
be owned by this user. Now you must be able to create users. If not, get
back with the log output.

regards,
bhuvaneswaran


pgsql-admin by date:

Previous
From: "Chris White"
Date:
Subject: Re: [JDBC] Problems with Large Objects using Postgres 7.2.1
Next
From: Pedro Salazar
Date:
Subject: problems restoring a dump : CREATE CAST? (postgis)