backup and restore questions
От | Sally Sally |
---|---|
Тема | backup and restore questions |
Дата | |
Msg-id | BAY9-F658F3dUJUsiGK0006d4f9@hotmail.com обсуждение исходный текст |
Ответы |
Re: backup and restore questions
Re: backup and restore questions Re: backup and restore questions |
Список | pgsql-general |
I had a few questions concerning the backup/restore process for pg. 1) Is it possible to dump data onto an existing database that contains data (assumning the schema of both are the same).Has anyone done this? I am thinking of this in order to expediate the data load process 2) I read that when dumping and restoring data the insert option is safer but slower than copy? Does anyone know from experiencehow much slower (especially for a database containing millions of records). 3) can pg_restore accept a file that is not archived like a zipped file or plain text file (file.gz or file) 4) Is the general practise to have one whole dump of a database or several separate dumps (by table etc...)? Thanks a lot Sally Take off on a romantic weekend or a family adventure to these great U.S. locations.
В списке pgsql-general по дате отправления: