Search Postgresql Archives

Re: PostgreSQL 9.01 error database help

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

 



tuanhoanganh <hatuan05@xxxxxxxxx> writes:
> I am running PostgreSQL 9.01 on windows 2008, RAID 10 with 4 disk.
> Yesterday, one of 4 disks RAID 10 error and I copy data directory to
> USB.

> Today, When I start postgresql i have error log

> 2011-05-24 17:20:01 ICT LOG:  database system was shut down at
> 2011-05-24 02:40:49 ICT
> 2011-05-24 17:20:01 ICT LOG:  unexpected pageaddr 1/A1F8E000 in log
> file 1, segment 177, offset 16310272
> 2011-05-24 17:20:01 ICT LOG:  invalid primary checkpoint record
> 2011-05-24 17:20:01 ICT LOG:  invalid secondary checkpoint record
> 2011-05-24 17:20:01 ICT PANIC:  could not locate a valid checkpoint record

It looks like the contents of pg_control are out of sync with what's in
pg_xlog/ ... are you sure you copied the *whole* data directory?

If this is all you have to work with, you can probably use pg_resetxlog
to wipe out the broken WAL data and then you'll be able to start the
database, but expect to find some amount of data corruption if you go
that way.  A dump and reload would probably be wise at that point.

			regards, tom lane

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[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