doubt about pg_dumpall

Поиск
Список
Период
Сортировка
Искать

doubt about pg_dumpall

От:
javier garcia - CEBAS <rn001@cebas.csic.es>
Дата:
Hi all;

In the documentation I'm missing some explanation about pg_dumpall.
I would like to know if there is any difference if I restore an entire 
database cluster over an existing database or over an empty cluster.

For example: if I restore the database cluster over a database that contains 
more tables than the backed database, will these additional tables be dropped 
previously to the restoration? Or if the tables already exist in the 
destination database will be any kind of cheking to see if the tables in the 
backup are newer or older than these existing tables?

Thanks and best regards,

Javier

Re: doubt about pg_dumpall

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
javier garcia - CEBAS  writes:
> For example: if I restore the database cluster over a database that contains 
> more tables than the backed database, will these additional tables be
> dropped 

No.  You should generally start from an empty database or cluster when
restoring.

			regards, tom lane
FAQ