Re: Problem starting a session

news.verizon.net wrote:
>
> [root@localhost root]# psql test
> 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"?
>
> anybody know why I'm getting this error message..... I'm a newbie... please
> point me in the right direction.

Hi Ferindo,

Any idea if PostgreSQL was started with the option to tell it that it
needs to communicate over the network?  By default it uses a system
called Unix Domain Sockets, and doesn't listen to the network.

If you're not sure, then in the PostgreSQL "data" directory there is a
file called "postgresql.conf".  You'll need to change the option there
called "tcpip_socket" to be "true", then restart PostgreSQL.  It should
work after that.

Hope that helps.

:-)

Regards and best wishes,

Justin Clift


--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi