Re: [GENERAL] pg_dump - ERROR - PostgreSQL 9.2

2016-02-01 Thread drum.lu...@gmail.com
[SOLVED] Just to let you guys know.. I've solved this issue changing the max_standby_streaming_delay on my slave to "-1". Cheers Lucas Possamai - kinghost.co.nz - DigitalOcean

[GENERAL] pg_dump - ERROR - PostgreSQL 9.2

2016-02-01 Thread drum.lu...@gmail.com
Hi all, *masterdb01 -> slave01 -> slave02 -> slave03* *testmaster01 (Full copy from masterdb01)* I'm trying to refresh my main DB, by running this command on my test server: ssh postgres@slave02 "/usr/pgsql-9.2/bin/pg_dump > --exclude-table-data='junk.*' --format=custom master_db_name" | > /usr