Re: Restore backup of database to new database name

Поиск
Список
Период
Сортировка
От Matheus de Oliveira
Тема Re: Restore backup of database to new database name
Дата
Msg-id CAJghg4K5s=bAbrap7Yhks8kq2sRqA=HFZ8U5SEaXMa8muPVLnA@mail.gmail.com
обсуждение исходный текст
Ответ на Restore backup of database to new database name  (sam turnbull <samturnbull73@gmail.com>)
Список pgsql-admin

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


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

Предыдущее
От: sam turnbull
Дата:
Сообщение: Restore backup of database to new database name
Следующее
От: Kevin Grittner
Дата:
Сообщение: Re: Does VACUUM FULL need ANALYZE ?