I have written a simple bourne shell script which performs all backup
functions, but no restore at this point. I personally find it's very
good and keeps each daily backup (gzipped) in it's own dated directory
under the parent directory being the current month. It's available at:

http://database.sourceforge.net

I am open to suggestions and if anyone would like to critique the code to
make it simpler or more powerful then by all means go ahead.

Thanks.


Tue, 26 Jun 2001 11:47:24 +1000 (EST)
Grant <grant@conprojan.com.au>
Announcing Postgresql backup script.
On Tue, Jun 26, 2001 at 11:47:24AM +1000, Grant wrote:
> 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?

-- 
[ Jim Mercer        jim@reptiles.org         +1 416 410-5633 ]
[ Now with more and longer words for your reading enjoyment. ]

Mon, 25 Jun 2001 22:22:28 -0400
Jim Mercer <jim@reptiles.org>
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@linux 26-06-2001]$ /server/pgsql/bin/dropdb -h localhost binary_data
DROP DATABASE
[postgres@linux 26-06-2001]$ /server/pgsql/bin/createdb -h localhost binary_data
CREATE DATABASE
[postgres@linux 26-06-2001]$ gunzip 12:00-postgresql_database-binary_data-backup.gz
[postgres@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.


Tue, 26 Jun 2001 13:04:41 +1000 (EST)
Grant <grant@conprojan.com.au>
Re: Announcing Postgresql backup script.
On Tue, Jun 26, 2001 at 01:04:41PM +1000, Grant wrote:
> > > 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. 

i'm glad you caught the humour intended.  i forgot the 8^)

> Volunteering? :)

not at this point.

> To restore just do the following:
> 
> [postgres@linux 26-06-2001]$ /server/pgsql/bin/dropdb -h localhost binary_data
> DROP DATABASE
> [postgres@linux 26-06-2001]$ /server/pgsql/bin/createdb -h localhost binary_data
> CREATE DATABASE
> [postgres@linux 26-06-2001]$ gunzip 12:00-postgresql_database-binary_data-backup.gz
> [postgres@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...

i haven't looked at the scripts (and probably should before commenting further)
but, alas, a few beers makes me bold.

this looks alot like what i would do with:

backup:

pg_dump dbname | gzip > /backup/`date +%Y-%m-%d`.gz

restore:

dropdb dbname
createdb dbname
zcat /some/YYYY-MM-DD.gz | psql -q dbname

-- 
[ Jim Mercer        jim@reptiles.org         +1 416 410-5633 ]
[ Now with more and longer words for your reading enjoyment. ]

Mon, 25 Jun 2001 23:24:45 -0400
Jim Mercer <jim@reptiles.org>
Re: Announcing Postgresql backup script.