Installing PostgreSQL DBMS
 

Hi! i have RedHat Linux 8,
i want to be able to use PostgresSQL on my pc.
i added the packages for database servers from my RedHat CDs.
now when i write: rpm -qa | grep postgres i get
postgresql-libs-7.2.2-1
postgresql-devel-7.2.2-1
....
postgresql-7.2.2-1


when i want to create a database, i get a message like:

createdb: could not connect to database template1: could not connect to server:
No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

how can i make postgresql correctly installed in order to use psql?

thank you for your time and help!!

Hady

you must create the template databases. for creating databases, the postgres client first need to connect to a template. you can create those with the "initdb" program in the postgres bin dir, by default /usr/local/pgsql/bin, but maybe redhat installes it elsewhere. more details on setting up postgres are in the INSTALL file, I recommend to read that one first! should be in /usr/local/pgsql/.

greetz,
.-=~ iluvatar ~=-.