Re: Database backup and restore

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 db set dump would be one file of this
type per database. Maybe the name could be used in a similar
reverse-direction script to send each to pg_restore to reload things.

I'll be working on it some more and will share what I come up with.

It seems a glaring omission that it is impossible to upgrade PostgreSQL
across major versions if your database(s) contain blobs (at least, not
without a lot of work).

Colin

----- Original Message -----
From: "Dan Langille" <dan(at)langille(dot)org>
To: "dima" <_pppp(at)mail(dot)ru>
Cc: <pgsql-admin(at)postgresql(dot)org>
Sent: Friday, November 22, 2002 2:05 PM
Subject: Re: [ADMIN] Database backup and restore

On 22 Nov 2002 at 19:07, dima wrote:

> i wrote a script in perl which dumps all the DBs but template*
> i can mail it to you if you wish

Why not post it to the list? That way it's available for everyone.
I'm guessing it'll be less than 2K or so...
--
Dan Langille : http://www.langille.org/

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org