Starting postmaster

[MalcolmBrown]

First things first - I know very little about Linux and VERY little about PostgrSQL. I do know a bit about databases.

On typing:

# psql

I receive this message:

psql: connectDBstart() __connect() failed: no such file or directory
Is the postmaster running locally
and expecting connections on Unix socket '/tmp/.s.PGSQL.5432'?

I have read the docs but don't understand them well enough to do the right thing.

I am using Mandrake 8.1 and the data directory appears to be:

/var/lib/pgsql/data

Postmaster doesn't seem to want me to connect as root but other uses do not have access permission - what do I do please?

Thank you in advance

 

[Guest_imported]

1) You will need to create a database:
createdb test

2) You will need to create new users:
createuser XXX

3) To use psql to access this database:
psql test -U postgres

Remember that you will create new tables with user that you logged.

best regards