Error on standby: Cannot assign TransactionIDs during recovery.

From: p g <wgpgvp(at)gmail(dot)com>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: Error on standby: Cannot assign TransactionIDs during recovery.
Date: 2013-07-15 20:05:40
Message-ID: CAHaVKmCopK=vtcz_kxORWHUCdF0VbGU5=hPVpvqXt00oq5ZUTA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

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

Browse pgadmin-hackers by date

  From Date Subject
Next Message Dave Page 2013-07-16 07:20:24 Re: Updated options-query_tool.rst file
Previous Message Dinesh Kumar 2013-07-15 17:55:25 Re: pgAdmin bug - SQL creation for foreign keys