Re: Announcing Postgresql backup script. - Mailing list pgsql-hackers

From Grant
Subject Re: Announcing Postgresql backup script.
Date
Msg-id Pine.LNX.4.21.0106261258330.16256-100000@webster.conprojan.com.au
Whole thread Raw
In response to Re: Announcing Postgresql backup script.  (Jim Mercer <jim@reptiles.org>)
Responses Re: Announcing Postgresql backup script.  (Jim Mercer <jim@reptiles.org>)
List pgsql-hackers
> > 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.



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Proposal for encrypting pg_shadow passwords
Next
From: Jim Mercer
Date:
Subject: Re: Proposal for encrypting pg_shadow passwords