Thread: Hot stand by streaming replication in postgresql 9.2
Hi i am new to PostgreSQL and one of my colleague gave me a task to do Hot stand by streaming replication in 9.2. I am having some confusion how to set the "archive_command" and restore_command parameters master postgresql server installation was loacted at /opt/PostgreSQL/9.2(IN Redhat Linux (6.x) slave server installation was configured at /var/lib/postgres/ and also help me how to set the restore_command in the slave side(recovery.conf file). master details IP:10.0.0.100 In postgresql.conf file: listen_addresses = '*' wal_level = hot_standby max_wal_senders = 1 wal_keep_segments = 5 archive_mode = on archive_command = ?(Dont no how to setup the parameter) In pg_hba.conf file: host replication repuser 10.0.0.200 trust Slave Details: postgresql.conf hot_standby = on Created recovery.conf, with the following lines: restore_command = (Help me how to set this parameter) standby_mode = 'on' primary_conninfo = 'host=10.0.0.100 port= xxxx user=repuser password=rep select pg_start_backup('base backup'); here i have to copy all the data dir to slave rsync -av --exclude pg_xlog --exclude postgresql.conf data/* 10.0.0.200:/var/lib/postgresql/data/ select pg_stop_backup(); My Lead said when you query the below three SQL statements you have to get same O/P then you have done every thing fine. For Example: In master SELECT pg_current_xlog_location(); pg_current_xlog_location -------------------------- 0/1C000080 (1 row). Then on the standby, you can run: # SELECT pg_last_xlog_receive_location(); pg_last_xlog_receive_location -------------------------- 0/1C000080 (1 row) # SELECT pg_last_xlog_replay_location(); pg_last_xlog_replay_location -------------------------- 0/1C000080 (1 row) Sorry For my english. Thanks in advance venkat -- View this message in context: http://postgresql.1045698.n5.nabble.com/Hot-stand-by-streaming-replication-in-postgresql-9-2-tp5804542.html Sent from the PostgreSQL - pgadmin hackers mailing list archive at Nabble.com.