Re: Newbie: problem Connecting to Server

So others might learn from this. The following solution was offered and
helped considerably in my case:

With an RPM install of PostgreSQL (which RedHat Database is), please consult

README.rpm-dist (find it with 'rpm -ql postgresql |grep rpm').

The short of it:

The RPM install scripts handle the user creation. All one must do is (as

root): '/sbin/service postgresql start' to get an initdb done and postmaster

started. Then edit /var/lib/pgsql/data/pg_hba.conf to allow access to the

client IP address, and edit postgresql.conf (in the same directory) for

tcpip_socket to be true (if you are doing TCP/IP connections, that is).

To get postgresql started automatically at boot, do (assuming you want

postgresql to run in runlevels 3, 4, and 5): '/sbin/chkconfig --level 345

postgresql on'

List the currently valid runlevels with '/sbin/chkconfig --list postgresql'

If it complains about postgresql not be a known service, execute

'/sbin/chkconfig --add postgresql' -- if that doesn't work, check to see if

the postgresql-server RPM is installed ('rpm -qa|grep postgresql').

-No Longer Frustrated

"Frustrated Beginner" <nowweare(at)access4cheap(dot)com> wrote in message
news:3e8b9c82_1(at)newsfeed(dot)(dot)(dot)
> I am having this exact same problem. Any help would be greatly
appreciated.
> Thank you.
>
>
>
> "Ferindo Middleton Jr" <ferindo(dot)middleton(at)verizon(dot)net> wrote in message
> news:pan(dot)2003(dot)03(dot)31(dot)01(dot)23(dot)34(dot)434512(at)verizon(dot)net(dot)(dot)(dot)
> > I'm running Redhat Linux 8. I have registration to the Redhat Network so
> > I'm probably running the latest version of postgre sql available. I also
> > have Redhat Databse v2.1 installed, but whenever I try to start a
session,
> > I get the following error message:
> >
> > psql: 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"?
> >
> > Please help me configure my system so that I can connect and begin to
use
> > postgresql.
>
>