Re: Postgresql installation problem - Mailing list pgsql-general

From William N. Zanatta
Subject Re: Postgresql installation problem
Date
Msg-id 3CBADC71.8040506@veritel.com.br
Whole thread Raw
In response to Postgresql installation problem  ("Pierre-Alexis Paquin" <papaquin@i2m.fr>)
List pgsql-general
I'm also a newbie on postgresql. The first time I installed it was last
friday. But I'll give a shot! Any mistakes, please correct me guys!

> 1. Did you initialized your database with initdb ?

This step creates the base files needed to run PSQL.
I'll assume you're running postgresql as postgres user.
Firstly, create a directory like data in your psql home directory. Then,
if the owner is not the postgres user, give him the ownershio of it.
Something like:

    # cd /usr/local/psql
    # mkdir data
    # chown postgres:users data
    # chmod 755 data

the '#' means I'm root!

now, initdb...

    # su postgres
    $ pwd
  /usr/local/psql
    $ cd bin
    $ ./initdb -D /usr/local/psql/data

the '$' means I'm a normal user like 'postgres' in this case

> 2. Have you started Postgres with postmaster -i   or pg_ctl start ?

Now you must start your postgresql daemon as postgres user. YOU CANNOT
START POSTGRESQL AS ROOT.

    $ pwd
  /usr/local/psql/bin
    $ ./postmaster -i -D /usr/local/psql/data &

ok now your daemon should be started...

> 3. Have you modified parameters in $PGDATA/postgresql.conf file ?
> Follow your answers, you have solved your problem

you can do it later. for now, check if it is working as you wish.


See ya,

William Zanatta


pgsql-general by date:

Previous
From: noy
Date:
Subject: Date precision problem
Next
From: Markus Wagner
Date:
Subject: How to get more detailed error messages?