Postgres Pro
Downloads
Home   >   mailing lists

Re: 20110408pg_upgrade_fix and 'FATAL: could not access status of transaction...' - Mailing list pgsql-general

From Henry C.
Subject Re: 20110408pg_upgrade_fix and 'FATAL: could not access status of transaction...'
Date
Msg-id dd4d2ffeef34fc6cae8323bb895d74e6.squirrel@zenmail.co.za
Whole thread Raw
In response to 20110408pg_upgrade_fix and "FATAL: could not access status of transaction..."  ("Henry C." <henka@cityweb.co.za>)
List pgsql-general
Tree view 
On Sat, April 23, 2011 09:56, Henry C. wrote:
> 1.  how to proceed with getting db1 back up so I can run the script?
> 2.  how to proceed with replicated database (db2)? (switch to standalone
> (since it's in readonly replication mode) and run upgrade fix script as per
> wiki, or leave as-is...)

Ran the pg_upgrade_fix script on db2 successfully after triggering failover.

Still wondering what to about db1 (other than trashing it and restoring from
backup or from db2 via rsync/replication).

pgsql-general by date:

Previous
From: "Henry C."
Date:
Subject: 20110408pg_upgrade_fix and "FATAL: could not access status of transaction..."
Next
From: Jorge Arévalo
Date:
Subject: Re: Should I free this memory?