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 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.