> > 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.
To restore just do the following:
[postgres(at)linux 26-06-2001]$ /server/pgsql/bin/dropdb -h localhost binary_data
[postgres(at)linux 26-06-2001]$ /server/pgsql/bin/createdb -h localhost binary_data
[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.
In response to
pgsql-hackers by date
|Next:||From: Jim Mercer||Date: 2001-06-26 03:18:20|
|Subject: Re: Proposal for encrypting pg_shadow passwords|
|Previous:||From: Bruce Momjian||Date: 2001-06-26 03:04:15|
|Subject: Proposal for encrypting pg_shadow passwords|