Re: [GENERAL] Interrupted pg_dump / pg_restore Upgrade

2007-01-05 Thread Thomas F. O'Connell
On Jan 4, 2007, at 7:03 PM, Tom Lane wrote: "Thomas F. O'Connell" <[EMAIL PROTECTED]> writes: My big question is: Is there anything that happens late in the game in a pg_dumpall that affects system catalogs or other non-data internals in any critical ways that would make an interrupted pg_dump

Re: [GENERAL] Interrupted pg_dump / pg_restore Upgrade

2007-01-04 Thread Tom Lane
"Thomas F. O'Connell" <[EMAIL PROTECTED]> writes: > My big question is: Is there anything that happens late in the game > in a pg_dumpall that affects system catalogs or other non-data > internals in any critical ways that would make an interrupted > pg_dumpall | psql sequence unstable? Ther

[GENERAL] Interrupted pg_dump / pg_restore Upgrade

2007-01-04 Thread Thomas F. O'Connell
I just became involved in a scenario wherein a migration between releases (8.1.x -> 8.2) using pg_dumpall piped to psql (per section 23.5 of the 8.2 docs) was interrupted based on duration of the procedure. The interruption was green lit because it was determined that the data had been migr