Re: How to transfer databases form one server to other

Am 27.01.20 um 21:47 schrieb Adrian Klaver: On 1/26/20 10:56 PM, Andrus wrote: Hi! 3. Manually edit role definitions to delete role postgres since it exists in new server. No need, it will throw a harmless error message and continue on. By my knowledge, pgAdmin executes script in single

Re: How to transfer databases form one server to other

On 1/26/20 10:56 PM, Andrus wrote: Hi! 3. Manually edit role definitions to delete role postgres since it exists in new server. No need, it will throw a harmless error message and continue on. By my knowledge, pgAdmin executes script in single transaction and rolls it back on error. Should

Re: How to transfer databases form one server to other

On 27/01/2020 12:40, Andrus wrote: > Hi! > >>> Postgres version 12 pg_dump probably cannot installed in old server >>> (Debian Squeeze 9). > >> I have it installed on my Debian 9 laptop, from the PostgreSQL apt repo: > >>  https://apt.postgresql.org > > Oled server uses Debian Sqeeze whose

Re: How to transfer databases form one server to other

Hi! Postgres version 12 pg_dump probably cannot installed in old server (Debian Squeeze 9). I have it installed on my Debian 9 laptop, from the PostgreSQL apt repo: https://apt.postgresql.org Oled server uses Debian Sqeeze whose version is 6. I mistakenly typed Debian Squeeze 9, I'm

Re: How to transfer databases form one server to other

On 1/26/20 10:44 PM, Andreas Joseph Krogh wrote: På mandag 27. januar 2020 kl. 03:26:59, skrev Ron >: [..] I ran *uncompressed* pg_dump on multiple TB+ sized databases from v8.4 servers across the LAN using 9.6 binaries on the remote server.  It

Re: How to transfer databases form one server to other

On 26/01/2020 22:47, Andrus wrote: > Hi! > >> Before you do any of this I would check the Release Notes for the >> first release of each major release. Prior to version 10 that would be >> X.X.x where X is a major release. For 10+ that is X.x.  I would also >> test the upgrade before doing it on

Re: How to transfer databases form one server to other

Hi! 3. Manually edit role definitions to delete role postgres since it exists in new server. No need, it will throw a harmless error message and continue on. By my knowledge, pgAdmin executes script in single transaction and rolls it back on error. Should psql used or is there some option in

Re: How to transfer databases form one server to other

Hi! Before you do any of this I would check the Release Notes for the first release of each major release. Prior to version 10 that would be X.X.x where X is a major release. For 10+ that is X.x. I would also test the upgrade before doing it on your production setup. I want to create test

Re: How to transfer databases form one server to other

På mandag 27. januar 2020 kl. 03:26:59, skrev Ron mailto:ronljohnso...@gmail.com>>: [..] I ran uncompressed pg_dump on multiple TB+ sized databases from v8.4 servers across the LAN using 9.6 binaries on the remote server. It was quite fast. Threading was key. According to the manual:

Re: How to transfer databases form one server to other

On 1/26/20 7:30 PM, Adrian Klaver wrote: On 1/26/20 2:47 PM, Andrus wrote: Hi! Before you do any of this I would check the Release Notes for the first release of each major release. Prior to version 10 that would be X.X.x where X is a major release. For 10+ that is X.x.  I would also test

Re: How to transfer databases form one server to other

On 1/26/20 2:47 PM, Andrus wrote: Hi! Before you do any of this I would check the Release Notes for the first release of each major release. Prior to version 10 that would be X.X.x where X is a major release. For 10+ that is X.x.  I would also test the upgrade before doing it on your

Re: How to transfer databases form one server to other

On 1/26/20 8:59 AM, Andrus wrote: Hi! VPS server has old Debian 6 Squeeze with Postgres 9.1 It has 24 databases. Every night backup copies are created using pg_dump to /root/backups directory for every database. This directory has 24 .backup files with total size 37 GB. I installed new VPS

How to transfer databases form one server to other

Hi! VPS server has old Debian 6 Squeeze with Postgres 9.1 It has 24 databases. Every night backup copies are created using pg_dump to /root/backups directory for every database. This directory has 24 .backup files with total size 37 GB. I installed new VPS server with Debian 10 and Postgres