Re: How to transfer databases form one server to other

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: "pgsql-general" <pgsql-general(at)postgresql(dot)org>, "Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com>
Subject: Re: How to transfer databases form one server to other
Date: 2020-01-27 06:56:18
Message-ID: F6ED65CDABB64AFCAAD0932CC9CF481B@dell2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

>> To repeat transfer after testing:
>>
>> 1. Delete restored databases.
>> 2. Delete imported roles in new server
>That will probaly not end well. I'm guessing there are objects that have a
>dependency on the the roles.

If imported databases are dropped before, there will be hopefully no
dependencies.

Andrus.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ray O'Donnell 2020-01-27 09:39:04 Re: How to transfer databases form one server to other
Previous Message Andreas Joseph Krogh 2020-01-27 04:44:52 Re: How to transfer databases form one server to other