[9.0] hot standby plus streaming replication questions

From: Michele Petrazzo - Unipex <michele(dot)petrazzo(at)unipex(dot)it>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: [9.0] hot standby plus streaming replication questions
Date: 2010-09-30 12:33:47
Message-ID: 4CA483AB.9060100@unipex.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 a common directory where read and write
the wal files? I don't find a reference where it's specified or said.
On my tests it's needed only for the first startup of the standby
server. After I can disable it on the master (archive_mode=off) and the
replication is
performed however, although the client warn me about a "no such file or
directory wal_archive/00000001000000000000000N+1" where N is the last
file wal archive that I have on the master, before disable the
"archive_mode".
Also on the my tests, I see that the replication happen also if I stop
the slave, add a 1k records to the master and re-start the slave. After
some seconds, on the master I see the connection and querying the slave
I see that all the record (previous inserted on the master) are there!

Just another question about replication: there is the possibility to
build a sync between a 32 and a 64 bit (on linux)?

Thanks,
Michele

Browse pgsql-general by date

  From Date Subject
Next Message Dr. Peter Voigt 2010-09-30 12:42:45 Re: PostgreSQL 9.0 (x86-64) and Windows 7 (x86-64) - Unable to install
Previous Message Matthew Seaman 2010-09-30 12:11:30 Re: rotate psql output