Search Postgresql Archives

Re: Postgres Start up Error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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.





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux