Configuring Standby Server in PostgreSQL 9.3.3
От | |
---|---|
Тема | Configuring Standby Server in PostgreSQL 9.3.3 |
Дата | |
Msg-id | 20140402110749.5a830134ae84016b0174832fdc1a3173.28ee073a59.wbe@email11.secureserver.net обсуждение исходный текст |
Ответы |
Re: Configuring Standby Server in PostgreSQL 9.3.3
Re: Configuring Standby Server in PostgreSQL 9.3.3 Re: Configuring Standby Server in PostgreSQL 9.3.3 |
Список | pgsql-bugs |
<span style=3D"font-family:Verdana; color:#000000; font-size:10= pt;">PostgreSQL version: 9.3.3=0AOperating system: Redhat 6.4 Linu= x=0ADescription: =0AWe are in the proc= ess of setting up a standby server. Instead of restoring from a backup take= n from primary server, we want to shutdown the primary server, and then= copy the primary database VM image to the standby server.We want t= o do this because our database is 7TB and takes 4-5 to backup and 8-9 days = to restore to the standby server.Mock Primary :192.168.1.50Mock= standby:192.168.1.1001.) Configure pg_hda.conf on primary#= Allow the user "postgres" from host 192.168.1.100 to connect to the primar= y# as a replication standby if the user's password is correctly supplie= d.## TYPE DATABASE = USER ADDR= ESS = METHODhost replication = postgres 192.1= 68.1.100/32 md52.) Co= nfigure recovery.conf on standbystandby_mode =3D 'on'primary_co= nninfo =3D 'host=3D192.168.1.50 port=3D5432 user=3Dpostgres password=3Dfoop= ass'restore_command =3D 'cp /path/to/archive/%f %p'archive_cleanup_= command =3D 'pg_archivecleanup /path/to/archive %r'3.) re-start bot= h serversQuestion #1 Is this feasible?Question #2 Have I missed= critical steps?Thanks</h= tml>
В списке pgsql-bugs по дате отправления: