From: | "Wang, Mary Y" <mary(dot)y(dot)wang(at)boeing(dot)com> |
---|---|
To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Startup proc 30595 exited with status 512 - abort and FATAL 2: XLogFlush |
Date: | 2010-02-03 01:34:01 |
Message-ID: | FA20D4C4FEBFD148B1C0CB09913825FC01EBD52EC0@XCH-SW-06V.sw.nos.boeing.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Ok. A little relief . It looks like only one table has no data. I guess I need to know what cause that table has no data....Going back to the drawing board.
Mary
-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Wang, Mary Y
Sent: Tuesday, February 02, 2010 4:32 PM
To: Scott Marlowe
Cc: Tom Lane; pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Startup proc 30595 exited with status 512 - abort and FATAL 2: XLogFlush
Thanks Scott.
We used a command like this '/usr/bin/pg_dumpall -cC' postgres to do the pg_dumpall.
I started my postmaster with this command "/usr/bin/postmaster -D /var/lib/pgsql/data -i"
I got my tables back in the database, but I don't see any data.
What could have went wrong when I did the "psql -f /usr/pgsql/backups/31.bak template1"?
Did I miss a step or something?
Now, I'm really worried.
Maybe I should have capture the log file when I did the restore?
Please advise.
Mary
------------------------------------------------
Mary Y Wang
-----Original Message-----
From: Scott Marlowe [mailto:scott(dot)marlowe(at)gmail(dot)com]
Sent: Tuesday, February 02, 2010 3:17 PM
To: Wang, Mary Y
Cc: Tom Lane; pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Startup proc 30595 exited with status 512 - abort and FATAL 2: XLogFlush
On Tue, Feb 2, 2010 at 3:29 PM, Wang, Mary Y <mary(dot)y(dot)wang(at)boeing(dot)com> wrote:
> Thanks Tom.
>
> After talking to my co-worker, we decided to go to the last backup (we used the pg_dumpall -c command).
> However, when I did enter "psql -f /usr/pgsql/backups/31.bak template1" to restore the database, I got "
> psql: connectDBStart() -- connect() failed: No such file or directory
> Is the postmaster running locally
> and accepting connections on Unix socket '/tmp/.s.PGSQL.5432'?
> ".
> I can't start my postmaster. So how would I restore my last good backup?
The normal way is to drop the old cluster and create a new one. I'm not entirely sure how to do that on something as old as RHEL 2.1. The normal way would be to mv or rm -rf the /var/lib/pgsql/data dir and run initdb again. something like:
sudo /etc/init.d/pgsql stop
sudo rm -rf /var/lib/pgsql/data/*
sudo -u postgres initdb -D /var/lib/pgsql/data sudo /etc/init.d/pgsql start
or something like that.
--
Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
From | Date | Subject | |
---|---|---|---|
Next Message | Achilleas Mantzios | 2010-02-03 09:01:52 | Re: Issues with LC_COLLATE, across 8.3/8.4 on various platforms |
Previous Message | Wang, Mary Y | 2010-02-03 00:32:17 | Re: Startup proc 30595 exited with status 512 - abort and FATAL 2: XLogFlush |