Service doesnt UP!!!!

[Edwin Quijada]

Hi!!!
I had a break electrical service and my system go down. Now when I try to up
the postgres service I get this error:

psql: 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"?
createdb: database creation failed

I went to directory data and delete postmaster.pid and postmaster.opts but
nothing happens.
I have the same error.
PLease I need urgent help!!!

I lost my data??
What can I do to back service up with my data??




*-------------------------------------------------------*
*-Edwin Quijada
*-Developer DataBase
*-JQ Microsistemas
*-809-747-2787
* " Si deseas lograr cosas excepcionales debes de hacer cosas fuera de lo
comun"
*-------------------------------------------------------*

_________________________________________________________________



---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Rajesh Kumar Mallah]

Post by Edwin Quijada
Hi!!!
I had a break electrical service and my system go down. Now when I try
psql: 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"?
createdb: database creation failed
I went to directory data and delete postmaster.pid and postmaster.opts
but nothing happens.
I have the same error.

You have to start the postmaster also.

try
become root by issuing the command below and entering root
password.

$ su -

now start the postgresql service using command below

# /etc/rc.d/init.d/pgsql start


Hope it solves ur problem , best of luck.


regds
mallah

Post by Edwin Quijada
PLease I need urgent help!!!
I lost my data??
What can I do to back service up with my data??
*-------------------------------------------------------*
*-Edwin Quijada
*-Developer DataBase
*-JQ Microsistemas
*-809-747-2787
* " Si deseas lograr cosas excepcionales debes de hacer cosas fuera de
lo comun"
*-------------------------------------------------------*
_________________________________________________________________
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Richard Huxton]

Post by Edwin Quijada
Hi!!!
I had a break electrical service and my system go down. Now when I try to
psql: 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"?
createdb: database creation failed

This is showing psql not connecting - you want to see what happens when you
start the backend.

Post by Edwin Quijada
I went to directory data and delete postmaster.pid and postmaster.opts but
nothing happens.
I have the same error.
PLease I need urgent help!!!

Where are your logs? There should be something there. If not, start postgres
in the manner described in the installation instructions - that should show
you where the problem is.

[Edwin Quijada]

using pg_ctl?
If yes !! I do it but doesnt happens!!



*-------------------------------------------------------*
*-Edwin Quijada
*-Developer DataBase
*-JQ Microsistemas
*-809-747-2787
* " Si deseas lograr cosas excepcionales debes de hacer cosas fuera de lo
comun"
*-------------------------------------------------------*

To: "Edwin Quijada"
Subject: Re: [GENERAL] Service doesnt UP!!!!
Date: Fri, 7 Nov 2003 17:05:48 +0000

Post by Edwin Quijada
Hi!!!
I had a break electrical service and my system go down. Now when I try

to

Post by Edwin Quijada
psql: 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"?
createdb: database creation failed

This is showing psql not connecting - you want to see what happens when you
start the backend.

Post by Edwin Quijada
I went to directory data and delete postmaster.pid and postmaster.opts

but

Post by Edwin Quijada
nothing happens.
I have the same error.
PLease I need urgent help!!!

Where are your logs? There should be something there. If not, start
postgres
in the manner described in the installation instructions - that should show
you where the problem is.
--
Richard Huxton
Archonet Ltd

_________________________________________________________________
Charla con tus amigos en línea mediante MSN Messenger:
http://messenger.yupimsn.com/


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[Edwin Quijada]

Hi!!!
This is my log after break down::
There is a app to fix the database.

The server must be started under an unprivileged user id to prevent
a possible system security compromise. See the documentation for
more information on how to properly start the server.

LOG: database system was interrupted at 2003-11-07 10:54:32 CET
LOG: checkpoint record is at 1/34600318
LOG: redo record is at 1/34600318; undo record is at 0/0; shutdown FALSE
LOG: next transaction id: 6326695; next oid: 5776573
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: redo starts at 1/34600358
PANIC: Invalid page header in block 8805 of 17097
LOG: startup process (pid 1327) was terminated by signal 6
LOG: aborting startup due to startup process failure
LOG: database system was interrupted being in recovery at 2003-11-07
23:33:19 CET
This probably means that some data blocks are corrupted
and you will have to use the last backup for recovery.
LOG: checkpoint record is at 1/34600318
LOG: redo record is at 1/34600318; undo record is at 0/0; shutdown FALSE
LOG: next transaction id: 6326695; next oid: 5776573
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: redo starts at 1/34600358
PANIC: Invalid page header in block 8805 of 17097
LOG: startup process (pid 1354) was terminated by signal 6
LOG: aborting startup due to startup process failure
LOG: database system was interrupted being in recovery at 2003-11-07
23:35:34 CET
This probably means that some data blocks are corrupted
and you will have to use the last backup for recovery.
LOG: checkpoint record is at 1/34600318
LOG: redo record is at 1/34600318; undo record is at 0/0; shutdown FALSE
LOG: next transaction id: 6326695; next oid: 5776573
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: redo starts at 1/34600358
PANIC: Invalid page header in block 8805 of 17097
LOG: startup process (pid 1090) was terminated by signal 6
LOG: aborting startup due to startup process failure
LOG: database system was interrupted being in recovery at 2003-11-07
23:40:47 CET
This probably means that some data blocks are corrupted
and you will have to use the last backup for recovery.
LOG: checkpoint record is at 1/34600318
LOG: redo record is at 1/34600318; undo record is at 0/0; shutdown FALSE
LOG: next transaction id: 6326695; next oid: 5776573
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: redo starts at 1/34600358
PANIC: Invalid page header in block 8805 of 17097
LOG: startup process (pid 1196) was terminated by signal 6
LOG: aborting startup due to startup process failure
LOG: database system was interrupted being in recovery at 2003-11-07
23:46:13 CET
This probably means that some data blocks are corrupted
and you will have to use the last backup for recovery.
LOG: checkpoint record is at 1/34600318
LOG: redo record is at 1/34600318; undo record is at 0/0; shutdown FALSE
LOG: next transaction id: 6326695; next oid: 5776573
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: redo starts at 1/34600358
PANIC: Invalid page header in block 8805 of 17097
LOG: startup process (pid 1531) was terminated by signal 6
LOG: aborting startup due to startup process failure




*-------------------------------------------------------*
*-Edwin Quijada
*-Developer DataBase
*-JQ Microsistemas
*-809-747-2787
* " Si deseas lograr cosas excepcionales debes de hacer cosas fuera de lo
comun"
*-------------------------------------------------------*

To: "Edwin Quijada"
Subject: Re: [GENERAL] Service doesnt UP!!!!
Date: Fri, 7 Nov 2003 17:05:48 +0000

Post by Edwin Quijada
Hi!!!
I had a break electrical service and my system go down. Now when I try

to

Post by Edwin Quijada
psql: 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"?
createdb: database creation failed

This is showing psql not connecting - you want to see what happens when you
start the backend.

Post by Edwin Quijada
I went to directory data and delete postmaster.pid and postmaster.opts

but

Post by Edwin Quijada
nothing happens.
I have the same error.
PLease I need urgent help!!!

Where are your logs? There should be something there. If not, start
postgres
in the manner described in the installation instructions - that should show
you where the problem is.
--
Richard Huxton
Archonet Ltd

_________________________________________________________________
MSN Messenger with backgrounds, emoticons and more.
http://www.msnmessenger-download.com/tracking/cdp_customize


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[Alvaro Herrera]

Post by Edwin Quijada
LOG: database system was interrupted at 2003-11-07 10:54:32 CET
LOG: checkpoint record is at 1/34600318
LOG: redo record is at 1/34600318; undo record is at 0/0; shutdown FALSE
LOG: next transaction id: 6326695; next oid: 5776573
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: redo starts at 1/34600358
PANIC: Invalid page header in block 8805 of 17097

Edwin has said elsewhere that he is using 7.3.4 and the filesystem is
ReiserFS. (Edwin, you should really include _all relevant_ information
when posting these things. I don't ask just to amuse myself, you know.)

I _think_ you should make a copy of PGDATA somewhere safe; then activate
zero_damaged_pages in postgresql.conf and restart the server. After
that, check all your data on the table with OID 17097, deactivate
zero_damaged_pages, make a backup copy of the table using pg_dump, and
try to restore whatever was lost on block 8805 of that table. (Maybe
you could get at the data using pg_filedump or pgfsck, to be found at
http://sources.redhat.com/rhdb and http://svana.org/kleptog
respectively).

Then please if you value your data that much, do frequent backups _or_
stop using IDE disks, and maybe activate fsync if you deactivated it.

Hmm ... oops ... I'm seeing there's no zero_damaged_pages in 7.3
documentation. So much for this solution :-( Maybe a hacked postmaster
could do the trick? I'm attaching a patch that seems to do the trick
(just out of CVS -- I didn't try compiling it).


PS: I'm Cc'ing pgsql-ayuda, just for the record ...

[Tom Lane]

Post by Alvaro Herrera
Hmm ... oops ... I'm seeing there's no zero_damaged_pages in 7.3
documentation.

It does exist in 7.3.4. That is what I'd recommend trying as well.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ***@postgresql.org)