[ADMIN] Database backup and restore

2002-11-25 Thread Colin Stearman
ntribution directory, if desired. - Original Message - From: "Dan Langille" <[EMAIL PROTECTED]> To: "Colin Stearman" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, November 22, 2002 2:46 PM Subject: Re: [ADMIN] Database backup and restore

Re: [ADMIN] Database backup and restore

2002-11-22 Thread Colin Stearman
Dan, On first glance at dima's script it does not seem to deal with blobs, although could easily me made to do so. Also it does not address automated reloading. In light of the fact that blobs must be output by -Ft or -Fc in pg_dump, which are tar and custom respectively, the result of an entire

[ADMIN] Database backup and restore

2002-11-22 Thread Colin Stearman
Am I missing something?   There seems to be no way to dump all databases and then restore them (as you'd have to do on a version change) if the databases contain blobs.   pg_dump supports dumping of blobs with the -b -Ft switch, but using pg_dumpall with those switches doesn't seem to work.