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 transaction and
rolls it
back on error.
Should psql used or is there some option in pgadmin.
There are options on pgAdmin:
https://www.pgadmin.org/docs/pgadmin4/4.17/restore_dialog.html
See:
Single transaction
Exit on error
Can't remember if you are taking a custom format backup or plain text.
If plain text you can use psql. If custom then will need to use pg_restore.
I have no read the fill post but perhaps netcat or ssh tunnel can be an
option to tansfer db's from a to b.
