Обсуждение: Restore backup of database to new database name

Поиск

Список

Период

Сортировка

Restore backup of database to new database name

От

sam turnbull

Дата:

26 июня 2015 г., 13:31:14

Hi All,

Apologies, incase posting my query in inappropriate group, I am newbie in PostgreSQL admin.

Requirement

backup database - Test

User(owner) - A

Restore to new database - Test1

under new user - B

Is this possible, since looking at some of discussion, there is no direct way of doing it.

Appreciate your suggestion.

Regards

Re: Restore backup of database to new database name

От

Matheus de Oliveira

Дата:

26 июня 2015 г., 19:06:40

On Fri, Jun 26, 2015 at 10:31 AM, sam turnbull <samturnbull73@gmail.com> wrote:

backup database - Test
User(owner) - A

Restore to new database - Test1
under new user - B

You can either create your dump file with --no-owner (or -O), or use a binary format and use --no-owner | -O on pg_restore. Then, when you restore you must do it connecting as user B.

Example with pg_restore:

- Dump:

$ pg_dump -Fc -d Test -f /path/to/test.dump

- Restore:

$ createuser B

$ createdb --template=template0 --owner=B Test1

$ pg_restore --no-owner -U B -d Test1 /path/to/test.dump

And you are done. You might also want to include --no-privileges, but that depends.

Regards,

Matheus de Oliveira

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Обсуждение: Restore backup of database to new database name

Restore backup of database to new database name

Re: Restore backup of database to new database name