Re: [GENERAL] PG 9.3 Switch streaming to wal shipping

2014-09-29 Thread Andy Colson
On 09/29/2014 05:16 PM, Adrian Klaver wrote: On 09/29/2014 02:17 PM, Andy Colson wrote: Crap! Is this a problem?! I switched back to cp, all was going well, here are some logs: Sep 29 16:07:10 webserv postgres[17735]: [590-1] ,,2014-09-29 16:07:10.888 CDT,: LOG: restored log file "000200

Re: [GENERAL] PG 9.3 Switch streaming to wal shipping

2014-09-29 Thread Adrian Klaver
On 09/29/2014 02:17 PM, Andy Colson wrote: Crap! Is this a problem?! I switched back to cp, all was going well, here are some logs: Sep 29 16:07:10 webserv postgres[17735]: [590-1] ,,2014-09-29 16:07:10.888 CDT,: LOG: restored log file "000200B90023" from archive Sep 29 16:07:13 w

Re: [GENERAL] PG 9.3 Switch streaming to wal shipping

2014-09-29 Thread Andy Colson
Crap! Is this a problem?! I switched back to cp, all was going well, here are some logs: Sep 29 16:07:10 webserv postgres[17735]: [590-1] ,,2014-09-29 16:07:10.888 CDT,: LOG: restored log file "000200B90023" from archive Sep 29 16:07:13 webserv postgres[17734]: [3-1] ,,2014-09-29

[GENERAL] PG 9.3 Switch streaming to wal shipping

2014-09-29 Thread Andy Colson
Hi All. I have a slave that was using streaming replication, and all was well, but its far away (remote data center), and its using too much bandwidth at peak times. I'm switching it to wal shipping at night. I don't really need it constantly up to date, nightly is good enough. In my reco