Re: DB Backup / Restore with PG Admin 2?

Поиск
Список
Период
Сортировка
От Dave Page
Тема Re: DB Backup / Restore with PG Admin 2?
Дата
Msg-id D85C66DA59BA044EB96AB9683819CF6101511B@dogbert.vale-housing.co.uk
обсуждение исходный текст
Список pgadmin-support

> -----Original Message-----
> From: Jeff Rhys-Jones [mailto:jeff@emojo.com]
> Sent: 27 June 2002 17:36
> To: pgadmin-support-owner@postgresql.org
> Subject: DB Backup / Restore with PG Admin 2?
>
>
> Hi There,
>
> Sorry if this has been asked before, but what is the
> recommended way of backing up and restoring databases with PGAdmin?
>
> Does the DB Schema copy everything? Can I then fully restore
> a database from this schema?

Backing up & restoring databases is *not* a job pgAdmin should be used
for. The DB Schema dumps are there as a convenience when hacking designs
about, however there may be errors in the code it generates because most
of it is reverse-engineered from the system catalogues and I may have
got something wrong.

Perform your backups using pg_dump or pg_dumpall on the server. They are
designed to dump the database *exactly* as it should be.

Regards, Dave



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

Предыдущее
От: Allan Lemos
Дата:
Сообщение: Re: Delphi x Postgresql
Следующее
От: liping guo
Дата:
Сообщение: Replication