Re: [ADMIN] Could the unlogged table of postgresql be used as session?

2012-06-05 Thread shuaixf
which friend knows? -- View this message in context: http://postgresql.1045698.n5.nabble.com/Could-the-unlogged-table-of-postgresql-be-used-as-session-tp5710923p5711376.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com. -- Sent via pgsql-admin mailing list (pgsql-admin@po

Re: [ADMIN] Can schemas be ordered regarding their creation time ?

2012-06-05 Thread Amador Alvarez
Thanks Tom, I will figure out then how to add a newly created schema to the schema-list to be backed up (dumped) but not directly as i expected. Cheers, A.A. On 06/05/2012 05:43 PM, Tom Lane wrote: Amador Alvarez writes: I would like to know if it is possible to get the date when the diffe

Re: [ADMIN] Can schemas be ordered regarding their creation time ?

2012-06-05 Thread Tom Lane
Amador Alvarez writes: > I would like to know if it is possible to get the date when the > different schemas were created, as I want to write an script to dump > only the latest schemas, the latest month created schemas for instance. No, sorry, Postgres does not track creation time of database

[ADMIN] Can schemas be ordered regarding their creation time ?

2012-06-05 Thread Amador Alvarez
Hi there, I would like to know if it is possible to get the date when the different schemas were created, as I want to write an script to dump only the latest schemas, the latest month created schemas for instance. Thanks in advance, A.A. -- Sent via pgsql-admin mailing list (pgsql-admin@post

Re: [ADMIN] Data split -- Creating a copy of database without outage

2012-06-05 Thread Igor Shmain
Hi Jan, Thank you so much for your input and sorry about the delay. I understand most of the limitations, compromises, and sacrifices that come with distributed databases (sharding). But definitely not all of them. After working with databases for about 25 years, I have some basic knowledge