Re: Restore DataBase

Поиск
Список
Период
Сортировка
От Andreas Schmitz
Тема Re: Restore DataBase
Дата
Msg-id 4C0605A6.60803@longimanus.net
обсуждение исходный текст
Ответ на Restore DataBase  (ALEXANDER JOSE <aangelj@hotmail.com>)
Список pgsql-admin
hi,

sounds like a plain text backup. your problem, I guess, will be some
constraint issue. I suggest commenting out the constraints in the backup
file before running the restore.

regards

andreas


ALEXANDER JOSE wrote:
> psql coon I'm trying to restore a database that has 60 GB in size,
> where there is a table with 38 million records, has raised 18 million
> records when the restore process fails on a syntax error, the backup
> was made with a file. sql as the best way I can do to restore??
>
>
> Alexander Angel
> Venezuela
>
> ------------------------------------------------------------------------
> Invite your mail contacts to join your friends list with Windows Live
> Spaces. It's easy! Try it!
> <http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us>


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

Предыдущее
От: Tena Sakai
Дата:
Сообщение: Re: What is field separator?
Следующее
От: Manohar Bhattarai
Дата:
Сообщение: Exception while accessing database