Hi Shoaib, I have the file with postgres permission on it, but , surprisingly its 0k .
[postg...@dbarhel564 ~]# cd /usr/local/pgsql/mypg/pg_clog/ [postg...@dbarhel564 pg_clog]# ll -lh total 0 -rw-rw-r-- 1 postgres postgres 0 Apr 12 12:54 0000 [postg...@dbarhel564 pg_clog]# any step to change this. regards raghavendra On Wed, Apr 14, 2010 at 12:39 PM, Shoaib Mir <shoaib...@gmail.com> wrote: > On Wed, Apr 14, 2010 at 5:00 PM, raghavendra t > <raagavendra....@gmail.com>wrote: > >> Hi Shoaib, >> >> Tried with pg_resetxlog >> >> >> [postg...@dbarhel564 bin]$ pg_resetxlog /usr/local/pgsql/mypg/ >> The database server was not shut down cleanly. >> Resetting the transaction log might cause data to be lost. >> If you want to proceed anyway, use -f to force reset. >> [postg...@dbarhel564 bin]$ pg_resetxlog -f /usr/local/pgsql/mypg/ >> Transaction log reset >> [postg...@dbarhel564 bin]$ pg_ctl start >> server starting >> [postg...@dbarhel564 bin]$ LOG: database system was shut down at >> 2010-04-12 12:26:15 IST >> FATAL: could not access status of transaction 889 >> DETAIL: Could not read from file "pg_clog/0000" at offset 0: Success. >> LOG: startup process (PID 1335) exited with exit code 1 >> LOG: aborting startup due to startup process failure >> >> > In that case, I would go and see if there is a clog file DB server is > complaining for there or not i.e. "pg_clog/0000" and if it is check for > permissions with PG user. Do you by any chance deleted stuff from pg_clog > folder? > > If they are not there then create 256k files for each of them filled with > zeros that server complaints for like the we just saw "pg_clog/0000", > remember this way you might be able to start the server but you will lose > the data from the time after your last checkpoint. > > -- > Shoaib Mir > http://shoaibmir.wordpress.com/ >