Re: 20110408pg_upgrade_fix and 'FATAL: could not access status of transaction...'

From: "Henry C(dot)" <henka(at)cityweb(dot)co(dot)za>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: 20110408pg_upgrade_fix and 'FATAL: could not access status of transaction...'
Date: 2011-04-23 11:22:23
Message-ID: dd4d2ffeef34fc6cae8323bb895d74e6.squirrel@zenmail.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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).

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jorge Arévalo 2011-04-23 11:36:20 Re: Should I free this memory?
Previous Message Henry C. 2011-04-23 07:56:57 20110408pg_upgrade_fix and "FATAL: could not access status of transaction..."