I installed PostgreSQL 7.1-1 from RPM on RH7.0 (I used GNOrpm).
Then I opened a terminal and ran
/etc/rc.d/init.d/postgresql start
chkconfig --add postgresql
as per README_rpm-dist (Lamar Owen)
psql works OK, pgaccess displays an error message
(PQConnectPoll() --connect() failed... check if postmaster is running and is
listening on port 5432)
I checked postgresql.conf: it is all #'ed lines.
I uncommented and made changes so that now the uncommented lines look like:
tcpip_socket = true
ssl = false
max_connections = 32 # 1-1024
port = 5432
shared_buffers = 2*max_connections # min 16
I tried to restart postmaster:
/etc/rc.d/init.d/postgresql restart
Shutsdown OK, then
Checking postgresql installation [OK]
Starting postgresql service [FAILED]
Where do I need to make changes?
Thanks in advance,
Mihai