Database backup and restore

I have completed the development of a BASH script to dump and load DBs with
(or without) blobs.

It will dump the globals also, like user names, but I don't know about
triggers, etc. As it uses pg_dump
and pg_restore to deal with the DBs and pg_dumpall to deal with the globals,
it should be all there.

You can get the scripts from www.infofind.com/postgreSQL.

Although I tested them, NO GUARANTEES OF ANY KIND ARE GIVEN. So test them
on something you don't care about first (especially the fullrestore script)!

Colin

PS. Mail list admin is welcome to add these scripts to the contribution
directory, if desired.

----- Original Message -----
From: "Dan Langille" <dan(at)langille(dot)org>
To: "Colin Stearman" <cstearman(at)infofind(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
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,
>
> 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 some more and will share what I come up with.

I'm sure it will be added to the contrib directory.
--
Dan Langille : http://www.langille.org/