[GENERAL] Revoking permission on view pg_prepared_xacts

2014-05-20 Thread Ondrej Chaloupka
Hi, I would like know whether there is some way how to revoke permission for doing recovery (showing prepared transactions and working with them) for a user? I've tried someting like revoke all on pg_catalog.pg_prepared_xacts from public; and revoke all on function pg_prepared_xacts from publi

[GENERAL] Incorrect response code after XA recovery

2013-07-29 Thread Ondrej Chaloupka
Hi, I would like to consult with you a problematic response put by PostgreSQL after transaction recovery run by Narayana (JBossTS). I work on tests for Narayana and I hit a issue with PostgreSQL. The db returns incorrect code XAException.XA_HEURHAZ when the TM does recovery after crash of the

Re: [GENERAL] Different transaction log for database/schema

2013-07-23 Thread Ondrej Chaloupka
t: Re: [GENERAL] Different transaction log for database/schema "On Mon, Jul 22, 2013 at 10:09 AM, Ondrej Chaloupka wrote: > Hello, > > I would like kindly ask for an advice whether and how the transaction log > behavior could be configured. > > I would like to have possibility

Re: [GENERAL] Different transaction log for database/schema

2013-07-22 Thread Ondrej Chaloupka
Hi Sachin, thank you for the idea. I didn't know about the function. Just this probably won't work for my use case. I do not access to different databases in one transaction. I access different databases simultaneously each with it's own xa transaction. What I understand the switch_xlog servers

[GENERAL] Different transaction log for database/schema

2013-07-22 Thread Ondrej Chaloupka
for a current session? Thank you for any hint or explanation how the things work in PostgreSQL Regards Ondrej Chaloupka