Re: [GENERAL] PostgreSQL 9.1, replica and unlogged tables

2011-09-14 Thread Marc Mamin
> Writing to any table on the standby is strictly forbidden so you can > forget having your own volatile copy. Hello, It should be possible to declare a -non postgres- SQL/MED table pointing e.g. to a csv on localhost, souldn't it ? best regards, Marc Mamin

Re: [GENERAL] PostgreSQL 9.1, replica and unlogged tables

2011-09-13 Thread Merlin Moncure
On Tue, Sep 13, 2011 at 9:11 AM, Ferruccio Zamuner wrote: > I'm starting to play with PostgreSQL 9.1, thank you all for this nice and > sweet piece of software. > > I've two hosts in my cluster: > > a) postgresql master > b) postgresql standby > > I've created two tables on master: > > create tabl

[GENERAL] PostgreSQL 9.1, replica and unlogged tables

2011-09-13 Thread Ferruccio Zamuner
I'm starting to play with PostgreSQL 9.1, thank you all for this nice and sweet piece of software. I've two hosts in my cluster: a) postgresql master b) postgresql standby I've created two tables on master: create table test_logged (id serial, nome text); create unlogged table test_unlogged (