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-23 Thread Luca Ferrari
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 to differentiate transaction logs for two > databases or schema. I would need such c

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

2013-07-22 Thread Igor Neyman
> -Original Message- > From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- > ow...@postgresql.org] On Behalf Of John R Pierce > Sent: Monday, July 22, 2013 2:32 PM > To: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Different transaction log for datab

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

2013-07-22 Thread John R Pierce
On 7/22/2013 9:33 AM, Ondrej Chaloupka wrote: 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

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

2013-07-22 Thread Ondrej Chaloupka
sing different files based on user/schema/ database. Is there such possibility? Thank you Ondra -- Původní zpráva -- Od: sachin kotwal Datum: 22. 7. 2013 Předmět: Re: [GENERAL] Different transaction log for database/schema ">where I need to run simultaneously different t

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

2013-07-22 Thread Pavel Stehule
ostgreSQL clusters on one computer. Regards Pavel > > Thank you > Ondra > > > ------ Původní zpráva ------ > Od: sachin kotwal > Datum: 22. 7. 2013 > Předmět: Re: [GENERAL] Different transaction log for database/schema > > >>where I need to run simultaneously dif

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

2013-07-22 Thread sachin kotwal
>where I need to run simultaneously different tests using transactions Are you running tests simultaneously on different databases? i.e. access to different databases within one transaction. If not -- after each transaction you can do pg_switch_xlog() then new transaction log will be created and