Re: Order of operations in ascii vs archive format (moderately urgent)

Поиск
Список
Период
Сортировка
От Rob Sargent
Тема Re: Order of operations in ascii vs archive format (moderately urgent)
Дата
Msg-id 4A65F2D7.8000901@gmail.com
обсуждение исходный текст
Ответ на Re: Order of operations in ascii vs archive format (moderately urgent)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
Wonderful news.

I just ran dump and restore against same production server.  Constraints 
and the absence of drop <object> calls appears to have saved my butt. 


Tom Lane wrote:
> Rob Sargent <robjsargent@gmail.com> writes:
>   
>> Is there a difference in the order of execution between an ascii dump 
>> and one using the "custom" format?  Or any difference in the general 
>> operation? 
>>     
>
> There's not supposed to be.  One standard test on the pg_dump code is
>     pg_dump >textfile
>     pg_dump -Fc >dumpfile
>     pg_restore dumpfile >textfile2
>     diff textfile textfile2
> If these don't produce the same results something is broken.
>
>             regards, tom lane
>   


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Order of operations in ascii vs archive format (moderately urgent)
Следующее
От: Rob Sargent
Дата:
Сообщение: Re: Order of operations in ascii vs archive format (moderately urgent)