Re: error inesperado arrancando psql?

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