Re: Problem starting a session - Mailing list pgsql-general

Erwin Moller,

I made the configuration settings you mentioned in the thread below, but I'm
still getting the same error message below. It seems that I've now setup the
server to accept TCP/IP connections ans except connections/requests from all
local users on my system, but I'm still getting the same error message.....
I don't understand what's wrong because when I go into the 'services'  on my
redhat linux 8 machine and restart the service postgresql, it restarts the
server acceptionally - without any problems reported.... is their anything
I'm missing that needs to be done to setup a user account and define the
area where their database info and all is.... I've bought this book on
postgre sql, but the book assumes you already have ther server setup to
accept users.

"Erwin Moller" <erwin@_removespam_dexus.nl> wrote in message
news:3E3A7750.40000@_removespam_dexus.nl...
> 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, another newbie answering :-)
>
>
> You get this error because you cannot connect to the server.
> two reasons:
> 1) server is not running
> test: type into console:
>
> pg_ctl status
>
>
> You will get a response that will make clear if the postmaster is running
>
> 2) Your postgresql server isn't accepting TCP/IP connections.
>
> You need (possibly) to do two things to repair this.
> 2a) Did you start postgres with TCP/IP support on?
> to check this you can check the file postgresql.conf in your data
directory:
> in my case: /usr/local/pgsql/data/postgresql.conf
>
> It should contain:
>
> #
> # Connection Parameters
> #
> tcpip_socket = true
> #ssl = false
> <blabla>
> port = 5432
>
>
> 2b) Postgres has a file that defines WHO and HOW can connect.
> It is called pg_hba.conf
> Read the file!
> at the end you define who can connect.
> To make your postgres accept TCP/IP connections from the same machine
> add a line like:
> host all all 127.0.0.1 255.255.255.255 trust
>
> This is NOT SAFE, but will make sure you can connect. Don't use this on
> a productionserver or something serious..
>
> Hope this helps you out,
>
> Regards and good luck,
> Erwin
>