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