Re: Postgresql installation problem

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