RE: [EXTERNAL]Re: pg_dump -Fd -j2 on standby in 9.6.6

2018-03-28 Thread Stefan Petrea
upgrading to 10 would be quite a heavy thing for now, since it would involve many changes so I don't believe that would be feasible right now. [3] https://github.com/postgres/postgres/blob/REL_10_STABLE/src/bin/pg_dump/pg_dump.c#L1149 Stefan Petrea System Engineer/DBA, Network Engineer

RE: [EXTERNAL]pg_dump -Fd -j2 on standby in 9.6.6

2018-03-27 Thread Stefan Petrea
d you approach this aspect of generating dumps faster? Or, can pg_dump -Fd -j be made to work on standbys? Also, does using --no-synchronized-snapshots mean that the dumps will be inconsistent? Thank you, Stefan Stefan Petrea System Engineer/DBA, Network Engineering stefan.pet...@tango

pg_dump -Fd -j2 on standby in 9.6.6

2018-03-27 Thread Stefan Petrea
he code in [1] says they should work for standby servers. My master is 9.6.6 and my slave is 9.6.6 as well. Any ideas would be appreciated. Thank you, Stefan [1] https://github.com/postgres/postgres/blob/REL9_6_STABLE/src/bin/pg_dump/pg_dump.c#L689 Stefan Petrea System Engineer/DBA, Network