Re: Please HELP - URGENT - transaction wraparound error - Mailing list pgsql-general

From Tom Lane
Subject Re: Please HELP - URGENT - transaction wraparound error
Date
Msg-id 823.1130688328@sss.pgh.pa.us
Whole thread Raw
In response to Re: Please HELP - URGENT - transaction wraparound error  (John Sidney-Woollett <johnsw@wardbrook.com>)
Responses Re: Please HELP - URGENT - transaction wraparound error  (John Sidney-Woollett <johnsw@wardbrook.com>)
List pgsql-general
John Sidney-Woollett <johnsw@wardbrook.com> writes:
> I decided to switch over to the slave which is now our live database.
> the old master with the problem has already been re-inited (although I
> have a cold backup of the data dir), plus dump files that I can restore
> from.

You panicked much too quickly and destroyed the evidence ... unless by
"cold backup" you mean a filesystem backup, in which case what you
should do is restore that and take a look at what's in its pg_database.
I think there's no question that there is some omission in your vacuuming
procedures, and you need to find out what it is.

            regards, tom lane

pgsql-general by date:

Previous
From: Lincoln Yeoh
Date:
Subject: Re: mysql replace in postgreSQL?
Next
From: Nico Grubert
Date:
Subject: Sorting problems with SELECT * FROM table WHERE name LIKE 'Ö%'