Skip site navigation (1) Skip section navigation (2)

Re: error inesperado arrancando psql?

From: Leonel Nunez <postgres(at)enelserver(dot)com>
To: carbonarac(at)cantv(dot)net
Cc: pgsql-es-ayuda(at)postgresql(dot)org
Subject: Re: error inesperado arrancando psql?
Date: 2004-06-12 23:31:21
Message-ID: 1087083081.1292.1.camel@debian.enelserver.com (view raw or flat)
Thread:
Lists: pgsql-es-ayuda
On Sat, 2004-06-12 at 17:06, Cesar A. wrote:
> Saludos...
> 
> Ando en Debian 3.0 Woody con Postgresql 7.2.1 (creo)
> 
> He tenido un fallon inesperado y en pesimo momento...
> 
> Estaba trabajando bien, pare unas 2 o 3 horas y al tratar de conectar mi
> psql habitantes, me arrojo:
> cesar(at)montecristo:~$ psql habitantes
> psql: could not connect to server: No such file or directory
>         Is the server running locally and accepting
>         connections on Unix domain socket
> "/var/run/postgresql/.s.PGSQL.5432"?
> 
> Le di, reiniciar postgresql desde consola:
> montecristo:/home/cesar# /etc/init.d/postgresql restart
> Restarting PostgreSQL database: postmaster
> No /usr/lib/postgresql/bin/postmaster found running; none killed.
> Starting PostgreSQL postmaster.
> pg_ctl: Another postmaster may be running.  Trying to start postmaster
> anyway.
> pg_ctl: cannot start postmaster
> Examine the log output.
> 
> Reviso el log que esta en /var/log/postgres.log:
> Lock file "/var/lib/postgres/data/postmaster.pid" already exists.
> Is another postmaster (pid 256) running in "/var/lib/postgres/data"?
> Lock file "/var/lib/postgres/data/postmaster.pid" already exists.
> Is another postmaster (pid 261) running in "/var/lib/postgres/data"?
> Lock file "/var/lib/postgres/data/postmaster.pid" already exists.
> Is another postmaster (pid 261) running in "/var/lib/postgres/data"?
> Lock file "/var/lib/postgres/data/postmaster.pid" already exists.
> Is another postmaster (pid 261) running in "/var/lib/postgres/data"?
> Found a pre-existing shared memory block (ID 0) still in use.
> If you're sure there are no old backends still running,
> remove the shared memory block with ipcrm(1), or just
> delete "/var/lib/postgres/data/postmaster.pid".
> Found a pre-existing shared memory block (ID 0) still in use.
> If you're sure there are no old backends still running,
> remove the shared memory block with ipcrm(1), or just
> delete "/var/lib/postgres/data/postmaster.pid".
> 
> Como soy bien novato aun, pido la ayuda de la lista...
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: ┬┐Has buscado en los archivos de las listas de correo?
> 
>                http://archives.postgresql.org
> 


Deten el postgresql  por si las dudas

/etc/init.d/postgresql stop

borra 
/var/lib/postgres/data/postmaster.pid

/etc/init.d/postgresql start


al parecer se detubo mal el postgresql y dejo el archivo con el numero
de proceso grabado
por consecuencia no se puede levantar porque asume que ya esta arriba


-- 
 ,''`.  Leonel Nunez
: :' :  http://enelserver.com
`. `'   DEBIAN GNU/LINUX
  `-    A REAL FREE OS



In response to

pgsql-es-ayuda by date

Next:From: Cesar A.Date: 2004-06-13 02:38:37
Subject: Re: error inesperado arrancando psql?
Previous:From: Cesar A.Date: 2004-06-12 23:06:47
Subject: error inesperado arrancando psql?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group