Re: [GENERAL] [9.0] hot standby plus streaming replication

2010-10-01 Thread Michele Petrazzo - Unipex
Fujii Masao ha scritto: On Fri, Oct 1, 2010 at 4:02 PM, Michele Petrazzo - Unipex wrote: - why in my tests, _whitout_ common direcotory, master and slave keep in sync also if I shutdown slave, add (in my last tests) something about 100k record (although little ones) on the master and then afte

Re: [GENERAL] [9.0] hot standby plus streaming replication

2010-10-01 Thread Fujii Masao
On Fri, Oct 1, 2010 at 4:02 PM, Michele Petrazzo - Unipex wrote: > - why in my tests, _whitout_ common direcotory, master and slave keep in > sync also if I shutdown slave, add (in my last tests) something about > 100k record (although little ones) on the master and then after woke up > the slave

Re: [GENERAL] [9.0] hot standby plus streaming replication

2010-10-01 Thread Jayadevan M
> > P.s. Glad to see that also in Italy there are PostgreSQL guru ;) > Glad to see that more people are using Indian words (Guru) :) http://en.wikipedia.org/wiki/Guru Regards, Jayadevan DISCLAIMER: "The information in this e-mail and any attachment is intended only for the person to whom

Re: [GENERAL] [9.0] hot standby plus streaming replication

2010-10-01 Thread Michele Petrazzo - Unipex
Gabriele Bartolini ha scritto: Ciao Michele, Ciao ;) both server (master and standby) need a common directory where read and write the wal files? Not necessarily. You can use for instance scp to ship the WAL file from the master to the standby using the network. Thanks for the explain

Re: [GENERAL] [9.0] hot standby plus streaming replication

2010-09-30 Thread Gabriele Bartolini
Ciao Michele, > both server (master and standby) need a common directory where read and write the wal files? Not necessarily. You can use for instance scp to ship the WAL file from the master to the standby using the network. > Just another question about replication: there is the possibil

[GENERAL] [9.0] hot standby plus streaming replication questions

2010-09-30 Thread Michele Petrazzo - Unipex
Hi list, I'm trying the new features into a test environment for see how all works and I'm finding first problems with setup. After reading the various Streaming_Replication, Warm_Standby and What's_new_in_PostgreSQL_9.0 on the wiki, one first question born: both server (master and standby) need