Search Postgresql Archives

Re: streaming replication question

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

 






On Thu, Mar 21, 2013 at 3:32 PM, Roberto Scattini <roberto.scattini@xxxxxxxxx> wrote:
hi list,

i'm installing a streaming replication master-slave setup in ubuntu 12.04 LTS, with postgresql 9.1

the tutorials and the documentation are a very good start point, but i have one question related to some fine grained configurations.

it is said that i should stop the master db in order to make de starting backup, OR run pg_start_backup and keep the archive files for the slave to catch up. if i dont do this, maybe the slave stays far behind the master and the wal_segments arent enough to start the replication. 
if I understand this right, i can "combine" the old "warm standby" configs of archive_command in the master and restore command in the slave to ensure that the slave will have the necessary info to start the replication.


i mean, i can have both configurations enabled?


no, i think my setup, with this config, is just doing warm standby. but the streaming replication was working before adding archive_command to master and restore_command to slave.

i used the info from this site:
http://wiki.postgresql.org/wiki/Streaming_Replication

--
Roberto Scattini

[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