Re: Backup & Restore
От | Gavin M. Roy |
---|---|
Тема | Re: Backup & Restore |
Дата | |
Msg-id | 000901c1be1e$d10e0da0$03ab8540@Gavin обсуждение исходный текст |
Ответ на | Backup & Restore (Marcelo Pereira <gandalf@sum.desktop.com.br>) |
Ответы |
Re: Backup & Restore
|
Список | pgsql-general |
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Attached is a small backup script that I wrote. It requires command line PHP w/ PostgreSQL support. What it does is rip through all the databases, gets the table listings, makes a directory structure and dumps every table to its own .sql file using pg_dump. Then it backs it up to tape. With some minor modifications it may work for you :D The reason I wrote this is with the size of my database, single table restorations from on pg_dumpall file were horrendous, and since the database changes structure on a regular basis (new tables, etc) I didn't want to be limited to a shell script I had to hand configure every time I added/removed a table. Cheers, Gavin - -----Original Message----- From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Marcelo Pereira Sent: Monday, February 25, 2002 4:17 AM To: pgsql-general@postgresql.org Subject: [GENERAL] Backup & Restore Hello All, Which is the simplest way to do a backup? My db is really small (about 4Mb), so I would like to make a backup to each day, save it in separated files, and restore it if necessary. So, which is the usual way to create the backup files? And how can I restore these backups? Thanks in advance, Marcelo Pereira - -- Remember that only God and Esc+:w saves. __ (_.\ Marcelo Pereira | / / ___ | / (_/ _ \__ Matematica/99 - IMECC | _______\____/_\___)___Unicamp_______________/ - ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org -----BEGIN PGP SIGNATURE----- Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com> iQA/AwUBPHpvKH9xeBXAlKqsEQIH/QCgkm6mqH/LjMeaFFE6UBZtC/825JcAoI7i ZyYUF2Y/Sr3Ni+AoIbSG1CZi =SIMe -----END PGP SIGNATURE-----
Вложения
В списке pgsql-general по дате отправления: