error inesperado arrancando psql?

From: "Cesar A(dot)" <carbonarac(at)cantv(dot)net>
To: pgsql-es-ayuda(at)postgresql(dot)org
Subject: error inesperado arrancando psql?
Date: 2004-06-12 23:06:47
Message-ID: 49791-22004661223647602@cantv.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

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...

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Leonel Nunez 2004-06-12 23:31:21 Re: error inesperado arrancando psql?
Previous Message Alex Sanchez 2004-06-12 20:30:00 consulta sql