Re: psql schemas

Поиск
Список
Период
Сортировка
От Peter Koczan
Тема Re: psql schemas
Дата
Msg-id 4544e0330711050939i586246caodbbd17c044a6939b@mail.gmail.com
обсуждение исходный текст
Список pgsql-admin

I had a file with name "dump_live" which contains all the dump using "pg_dumpall > dump_live". Now, I need to restore it to another schema "schema2". How can I restore the data from that file to specified empty schema2. (This schema is created with out any objects). Pls advice me how to handle.

You dumped the entire database cluster...data, schema definitions, user/group data, etc. You're going to have to specify options for dumping and restoring data to do what you wish. This is well-documented in the list archives, the website, man pages, and many, many other places. Please read them.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Error Migrating From 7.4 to 8.2.5
Следующее
От: "Peter Koczan"
Дата:
Сообщение: Re: Postgresql pg_dumpall