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.