Re: problems with access into system catalogs - Mailing list pgsql-admin

From Tom Lane
Subject Re: problems with access into system catalogs
Date
Msg-id 20495.1343313951@sss.pgh.pa.us
Whole thread Raw
In response to Re: problems with access into system catalogs  (Thomas Markus <t.markus@proventis.net>)
List pgsql-admin
Thomas Markus <t.markus@proventis.net> writes:
> a rollback prepared on these does the job

If you aren't intentionally using prepared transactions, it's a good
idea to disable them by setting max_prepared_transactions to zero
(DB restart required).  That prevents you from accidentally shooting
yourself in the foot like this.

            regards, tom lane

pgsql-admin by date:

Previous
From: Jerry Sievers
Date:
Subject: Re: standby with a fixed lag behind the master
Next
From: Steve Crawford
Date:
Subject: Re: standby with a fixed lag behind the master