Thanks Chetan,
The problem is solved by the below command :-
:-)
[postgres@ws-test 8.4SS]$ bin/pg_resetxlog -f
/hdd-1/PostgresPlus/8.4SS/data
Best Regards,
Adarsh Sharma
Chetan Suttraway wrote:
On Mon, Apr 18, 2011 at 11:00 AM, Adarsh
Sharma <adarsh.sharma@xxxxxxxxxx>
wrote:
Dear
all,
Today I by mistake deleted all the contents of pg_log & pg_xlog
directory and my Postgresql refuses to start due to the below error :-
2011-04-18 10:51:39 ISTLOG: database system was interrupted; last
known up at 2011-04-18 10:06:42 IST
2011-04-18 10:51:39 ISTLOG: could not open file
"pg_xlog/000000010000000600000007" (log file 6, segment 7): No such
file or directory
2011-04-18 10:51:39 ISTLOG: invalid primary checkpoint record
2011-04-18 10:51:39 ISTLOG: could not open file
"pg_xlog/0000000100000005000000C9" (log file 5, segment 201): No such
file or directory
2011-04-18 10:51:39 ISTLOG: invalid secondary checkpoint record
2011-04-18 10:51:39 ISTPANIC: could not locate a valid checkpoint
record
2011-04-18 10:51:39 ISTLOG: startup process (PID 11021) was terminated
by signal 6: Aborted
2011-04-18 10:51:39 ISTLOG: aborting startup due to startup process
failure
I try to reinstall with the same previous data directory, but it fails
again.
Any suggestions to solve it without losing the previous data.
Thanks & best Regards,
Adarsh Sharma
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
A quick search on message archives pointed to below link:
http://archives.postgresql.org/pgsql-admin/2000-10/msg00000.php
http://archives.postgresql.org/pgsql-admin/2002-04/msg00013.php
http://archives.postgresql.org/pgsql-bugs/2009-03/msg00118.php
Maybe someone here can point the exact steps to be followed.
--
Regards,
Chetan Suttraway
EnterpriseDB, The Enterprise
PostgreSQL company.
|
