Postgres Pro
Downloads
Home   >   mailing lists

Error on standby: Cannot assign TransactionIDs during recovery. - Mailing list pgadmin-hackers

From p g
Subject Error on standby: Cannot assign TransactionIDs during recovery.
Date
Msg-id CAHaVKmCopK=vtcz_kxORWHUCdF0VbGU5=hPVpvqXt00oq5ZUTA@mail.gmail.com
Whole thread Raw
List pgadmin-hackers
Tree view
I get this error on the standby node when using check_postgres.pl for the following actions:

Autovacuum_freeze

Txn_wraparound.

I tried running the following query on the standby:

SELECT datname, age(datfrozenxid) AS age FROM pg_database WHERE datallowconn ORDER BY 1, 2;

The resulting error is as follows:
ERROR:  cannot assign TransactionIds during recovery

Posgres version: 9.0.7


Thanks!
Anit

pgadmin-hackers by date:

Previous
From: Dinesh Kumar
Date:
Subject: Re: pgAdmin bug - SQL creation for foreign keys
Next
From: Dave Page
Date:
Subject: Re: Updated options-query_tool.rst file