Search Postgresql Archives

Re: Different transaction log for database/schema

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello

2013/7/22 Ondrej Chaloupka <chalda@xxxxxxxxx>:
> 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
> for using new file for transaction log. What I would understand is supposed
> to be used e.g. for cleaning.
>
> In my case it's normal that the two tests uses database (their own databases
> but under one PostgreSQL server) and each one creates an record in the log.
> E.g. when first test would call the switch_xlog and continue with work then
> the second test would start and call the switch_xlog then the both tests
> will still use the same transaction log despite the fact that it would be
> some new one. In case that I understand the function right.
>
> I would need to force of using different files based on
> user/schema/database. Is there such possibility?

No, it is not possible in one PostgreSQL database cluster.

You can create more than one PostgreSQL clusters on one computer.

Regards

Pavel

>
> Thank you
> Ondra
>
>
> ---------- Původní zpráva ----------
> Od: sachin kotwal <kotsachin@xxxxxxxxx>
> Datum: 22. 7. 2013
> Předmět: Re:  Different transaction log for database/schema
>
>
>>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 next transaction details will store in new log file.
>
> make sure that you set proper configuration parameter to keep maximum
> transactions logs.
>
>
>
>
>
>
>
> --
> View this message in context:
> http://postgresql.1045698.n5.nabble.com/Different-transaction-log-for-database-schema-tp5764604p5764622.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux