@MrGeneration You’re recommending using psql in your post above—but whatever I’ve tried, I cannot manage to get it to work. Seems to be as @mbpws wrote in the linked thread (emphasis mine):
In the meantime I managed to get it working. I already figured out that the migration from CentOS7 to Ubuntu will not work when using the provided backup script. It will throw errors all over.
Could anyone elaborate on why this happens in the first place?
Also, he advised to use pg_restore (which is why I used for this migration from Docker/Alpine to CentOS). As I said, CentOS uses an older version of pg_restore—so this seems to be the issue here.
tl;dr / Summary:
- Using the provided backup script doesn’t seem to work (I’ve tried a few things—nothing works)
- @mbpws said in another thread that the backup script doesn’t work when migrating from CentOS to Ubuntu
- Backup script uses ‘psql’ (which seems to be the bad guy here—for whatever reason)
- pg_restore won’t work because the version in CentOS is older (9.2.24) than in Docker/Alpine (9.6.13)
Looking forward to your ideas. Maybe @martin.von.wittich ran into some sort of similar issue?