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
On first glance at dima's script it does not seem to deal with blobs,
although could easily me made to do so.
I think that would be a very good addition to the PostgreSQL toolkit.
FWIW, I do not use blobs and consequently do not think of them when
backups are required.
I'll be working on it
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
On 22 Nov 2002 at 14:41, Colin Stearman wrote:
Dan
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. And
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.
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/
PROTECTED]]
Sent: Friday, November 22, 2002 11:07
To: Colin Stearman
Cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] Database backup and restore
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
] 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
On 22 Nov 2002 at 14:41, Colin Stearman wrote:
Dan,
On first glance at dima's script it does not seem to deal with blobs,
although could easily me made to do so.
I think that would be a very good addition to the PostgreSQL toolkit.
FWIW, I do not use blobs and consequently do not think of