[GENERAL] Most efficient way to initialize a standby server

2013-05-27 Thread Edson Richter
I've two distant servers I would like to configure async replication between. Servers are running 9.2.4. Since 9.0 days I do use script with rsync for transfer. And sometimes the servers get out of sync (due large processing in master database and huge network latency), and I have to

Re: [GENERAL] Most efficient way to initialize a standby server

2013-05-27 Thread Sergey Konoplev
Try this step-by-step instruction https://code.google.com/p/pgcookbook/wiki/Streaming_Replication_Setup. I constantly update it when discovering useful things, including low bandwidth issues. On Mon, May 27, 2013 at 5:08 PM, Edson Richter edsonrich...@hotmail.com wrote: Since 9.0 days I do use

Re: [GENERAL] Most efficient way to initialize a standby server

2013-05-27 Thread Joshua D. Drake
On 05/27/2013 05:43 PM, Sergey Konoplev wrote: Try this step-by-step instruction https://code.google.com/p/pgcookbook/wiki/Streaming_Replication_Setup. I constantly update it when discovering useful things, including low bandwidth issues. On Mon, May 27, 2013 at 5:08 PM, Edson Richter

Re: [GENERAL] Most efficient way to initialize a standby server

2013-05-27 Thread Edson Richter
Em 27/05/2013 21:43, Sergey Konoplev escreveu: Try this step-by-step instruction https://code.google.com/p/pgcookbook/wiki/Streaming_Replication_Setup. I constantly update it when discovering useful things, including low bandwidth issues. Thanks. This is a good idea, of course! I also have a

Re: [GENERAL] Most efficient way to initialize a standby server

2013-05-27 Thread Edson Richter
Em 28/05/2013 00:03, Joshua D. Drake escreveu: On 05/27/2013 05:43 PM, Sergey Konoplev wrote: Try this step-by-step instruction https://code.google.com/p/pgcookbook/wiki/Streaming_Replication_Setup. I constantly update it when discovering useful things, including low bandwidth issues. On

Re: [GENERAL] Most efficient way to initialize a standby server

2013-05-27 Thread Joshua D. Drake
On 05/27/2013 08:13 PM, Edson Richter wrote: I think the use of PITRTools is probably up your alley here. JD Assume I know nothing about PITRTools (which I really don't know!), can you elaborate a bit more your suggestion? It is an open source tool specificaly for working with