From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
---|---|
To: | Joana Camacho <joanacmch(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Error_startup postgresql server |
Date: | 2009-12-07 14:09:19 |
Message-ID: | 4B1D0C8F.5050007@iol.ie |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)jc:~$ /usr/local/pgsql/bin/pg_ctl start -l logfile -D
> /usr/local/pgsql/data1/data/
> server starting
> postgres(at)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(at)iol(dot)ie
From | Date | Subject | |
---|---|---|---|
Next Message | Roberto Mello | 2009-12-07 14:58:32 | Re: New PostgreSQL Committers |
Previous Message | Joana Camacho | 2009-12-07 13:54:25 | Error_startup postgresql server |