Hi, I just installed postgresql and when I try to test it, there's an error

postgres@nimrod3:~$ /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1 &
[1] 29303
postgres@nimrod3:~$ /usr/local/pgsql/bin/createdb test
createdb: could not connect to database postgres: could not connect to server: Connection refused
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
[1]+ Exit 1 /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1

Any ideas? Any help is appreciated

Thanks in advance.

Me = Sorry for the trouble.

Did you run initdb?

Brian

postgres@nimrod:/usr/local/pgsql/data$ /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1 &
[1] 29337
postgres@nimrod:/usr/local/pgsql/data$ /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data
FATAL: could not open lock file "/tmp/.s.PGSQL.5432.lock": Permission denied
[1]+ Exit 1 /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1


I did run initd already.
postgres@nimrod:/usr/local/pgsql/data$ /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locales
COLLATE: C
CTYPE: en_US
MESSAGES: en_US
MONETARY: en_US
NUMERIC: en_US
TIME: en_US
The default database encoding has accordingly been set to LATIN1.

initdb: directory "/usr/local/pgsql/data" exists but is not empty
If you want to create a new database system, either remove or empty
the directory "/usr/local/pgsql/data" or run initdb
with an argument other than "/usr/local/pgsql/data".


help~ Thanks in advance

I am stuck at http://www.postgresql.org/docs/8.1/i...tallation.html

Section 14.1. Short Version

I did up to
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1 &

But
/usr/local/pgsql/bin/createdb test
/usr/local/pgsql/bin/psql test

doesnt work.

Ideas/suggestion? Thanks in advance

I think that /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1 & is what is failing. After you do this command do you see the postmaster process running (ps -A)? What does logfile show if there is one?

Check the ownership of /usr/local/pgsql/data (ls -l).

The problem might actually be the logfile. If you are issuing the command from your own home directory it will try to create the logfile there. The postgres user does not have permissions to write to your home directory. Maybe try "... >/usr/local/pgsql/logfile..." instead.

Brian