On 10/6/22 1:54 PM, Ron wrote:
On 10/6/22 14:32, Adrian Klaver wrote:
On 10/6/22 10:46, Christophe Pettus wrote:
On Oct 6, 2022, at 10:44, Ron <ronljohnsonjr@xxxxxxxxx> wrote:
Sadly, that VM doesn't have nearly enough disk space to hold the
backup folder.
Use file mode, and stream the output via scp/ssh to a different machine?
Or Plan B:
1) Use pg_dump 9.6.24 on existing(going EOL) server
2) Set up a 9.6.24 instance somewhere you have control.
3) pg_restore to it.
4) Then use pg_dump 13.8 on the new instance.
While that would certainly work, it's a heck of a lot of extra effort
for large one-time operations.
1) It could be scripted.
2) Nothing to stop you from splitting into schema only dump for the 9.6
--> 9.6 --> 13 restore of schema.
3) Then data only dump restored directly to 13.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
