Re: Error_startup postgresql server

On 07/12/2009 13:54, Joana Camacho wrote:
> Hi,
>
> I'm using Postgresql 8.7.3 on Debian. I was trying to launch the postgresql
> server to create a simple user and a database, but I've got this output:
>
> --------------------------------------------------------------------------------------------------------------
> jc:/usr/local/pgsql/data1# su - postgres
> postgres@jc:~$ /usr/local/pgsql/bin/pg_ctl start -l logfile -D
> /usr/local/pgsql/data1/data/
> server starting
> postgres@jc:~$ /usr/local/pgsql/bin/createuser radius --no-superuser
> --no-createdb --no-createrole -P
> Enter password for new role:
> Enter it again:
> createuser: could not connect to database postgres: 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"?
> --------------------------------------------------------------------------------------------------------------
>
> I've search the web and seen some people saying to uncomment a line in the
> postgresql.conf file ("tcpip_socket = true") but I don't have this line! I'm
> not understanding what's wrong, why can't I create an user, supposedly the
> server is running..

I think that should be

    listen_addresses = *

By default the server listens only on local Unix sockets - you have to
uncomment the above line to have it listen on a TCP/IP address/port.
Setting the option to "*" has it listen on port 5432 (the default port)
on all available addresses; you can restrict it to a specific address or
addresses by specifying them on this line.


Ray.


--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie