Move Postgres DB to new computer

[waynewilliams]

Hi,

Our computer is old and running Postgres 9.5. I have set up a new computer and installed Postgres 16. I’m having problems backing up the DB and restoring it on the new computer.

I’ve tried pgadmin and also pg_dump and pg_restore but it fails on the restore every time with errors relating to permissions.

Is there a foolproof method of doing this or a step-by-step guide I can follow?

Thanks

[marckxz]

I don’t have a step-by-step procedure but maybe a good suggestion to backup and restore your database with https://sqlbackupandftp.com/

[CROOZEmaster]

Have you created the same users (and credentials) on the new database as you have on the old one? And have you already created the database with the same name?

I’m not a specialist, just my 2 cts…

[uli.mairlist]

[OT]

Have you read this (nothing about the database, but mAirList v5)?

Special upgrade deal ends on December 31, 2023

Dear mAirList customers using version 5, in the past, we have been very generous when upgrading to the current version if a generation was “skipped” (example v4.x to v6.x). They were then available at the “normal” (simple) upgrade price to make the switch palatable. This offer is currently also available for switching from version 5 to 7. Owners of version 5 can find the corresponding cheap offer in the customer area under “My Licenses”. Users of version 5 who don’t see t…

Just to remind you.

[/OT]

[waynewilliams]

Hi,

Yes I saw that. It’s not broken though so why fix it? V5 works great for us.

I managed to sort my issue with the database migration. It was an issue with the database roles which resolved itself after re-creating them.