Re: Announcing Postgresql backup script.

> > I have written a simple bourne shell script which performs all backup
> > functions, but no restore at this point.
>
> ah, isn't that like building a really fast car with no brakes?

This car has brakes, but they're not so easy to use just yet.

Volunteering? :)

To restore just do the following:

[postgres(at)linux 26-06-2001]$ /server/pgsql/bin/dropdb -h localhost binary_data
DROP DATABASE
[postgres(at)linux 26-06-2001]$ /server/pgsql/bin/createdb -h localhost binary_data
CREATE DATABASE
[postgres(at)linux 26-06-2001]$ gunzip 12:00-postgresql_database-binary_data-backup.gz
[postgres(at)linux 26-06-2001]$ psql -h localhost binary_data < 12:00-postgresql_database-binary_data-backup
You are now connected as new user postgres.
CREATE...

etc etc.