Re: How to transfer databases form one server to other

Поиск
Список
Период
Сортировка
От Andrus
Тема Re: How to transfer databases form one server to other
Дата
Msg-id F6ED65CDABB64AFCAAD0932CC9CF481B@dell2
обсуждение исходный текст
Ответ на Re: How to transfer databases form one server to other  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: How to transfer databases form one server to other
Список 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. 




В списке pgsql-general по дате отправления:

Предыдущее
От: Andreas Joseph Krogh
Дата:
Сообщение: Re: How to transfer databases form one server to other
Следующее
От: Ray O'Donnell
Дата:
Сообщение: Re: How to transfer databases form one server to other