Thread: Service doesnt UP!!!!
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"
*-------------------------------------------------------*
_________________________________________________________________
Edwin Quijada wrote: > 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. 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 > > 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
On Friday 07 November 2003 16:19, Edwin Quijada wrote: > 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 This is showing psql not connecting - you want to see what happens when you start the backend. > 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. -- Richard Huxton Archonet Ltd
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" *-------------------------------------------------------* >From: Richard Huxton <dev@archonet.com> >To: "Edwin Quijada" ><listas_quijada@hotmail.com>,pgsql-general@postgresql.org >Subject: Re: [GENERAL] Service doesnt UP!!!! >Date: Fri, 7 Nov 2003 17:05:48 +0000 > >On Friday 07 November 2003 16:19, Edwin Quijada wrote: > > 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 > >This is showing psql not connecting - you want to see what happens when you >start the backend. > > > 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. > >-- > Richard Huxton > Archonet Ltd _________________________________________________________________ Charla con tus amigos en línea mediante MSN Messenger: http://messenger.yupimsn.com/
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"
*-------------------------------------------------------*
>From: Richard Huxton <dev@archonet.com>
>To: "Edwin Quijada"
><listas_quijada@hotmail.com>,pgsql-general@postgresql.org
>Subject: Re: [GENERAL] Service doesnt UP!!!!
>Date: Fri, 7 Nov 2003 17:05:48 +0000
>
>On Friday 07 November 2003 16:19, Edwin Quijada wrote:
> > 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
>
>This is showing psql not connecting - you want to see what happens when you
>start the backend.
>
> > 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.
>
>--
> Richard Huxton
> Archonet Ltd
_________________________________________________________________
MSN Messenger with backgrounds, emoticons and more.
http://www.msnmessenger-download.com/tracking/cdp_customize
On Fri, Nov 07, 2003 at 05:40:31PM +0000, Edwin Quijada wrote: > 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 ... -- Alvaro Herrera (<alvherre[a]dcc.uchile.cl>) "I call it GNU/Linux. Except the GNU/ is silent." (Ben Reiter)
Attachment
Alvaro Herrera <alvherre@dcc.uchile.cl> writes:
> 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