Skip site navigation (1) Skip section navigation (2)

Re: Announcing Postgresql backup script.

From: Grant <grant(at)conprojan(dot)com(dot)au>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Announcing Postgresql backup script.
Date: 2001-06-26 03:04:41
Message-ID: Pine.LNX.4.21.0106261258330.16256-100000@webster.conprojan.com.au (view raw or flat)
Thread:
Lists: 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(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.


In response to

Responses

pgsql-hackers by date

Next:From: Jim MercerDate: 2001-06-26 03:18:20
Subject: Re: Proposal for encrypting pg_shadow passwords
Previous:From: Bruce MomjianDate: 2001-06-26 03:04:15
Subject: Proposal for encrypting pg_shadow passwords

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group