Re: Announcing Postgresql backup script.

Поиск
Список
Период
Сортировка
От Grant
Тема Re: Announcing Postgresql backup script.
Дата
Msg-id Pine.LNX.4.21.0106261258330.16256-100000@webster.conprojan.com.au
обсуждение исходный текст
Ответ на Re: Announcing Postgresql backup script.  (Jim Mercer <jim@reptiles.org>)
Ответы Re: Announcing Postgresql backup script.  (Jim Mercer <jim@reptiles.org>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Proposal for encrypting pg_shadow passwords
Следующее
От: Jim Mercer
Дата:
Сообщение: Re: Proposal for encrypting pg_shadow passwords