Re: Backup & Restore - Mailing list pgsql-general

From Gavin M. Roy
Subject Re: Backup & Restore
Date
Msg-id 000901c1be1e$d10e0da0$03ab8540@Gavin
Whole thread Raw
In response to Backup & Restore  (Marcelo Pereira <gandalf@sum.desktop.com.br>)
Responses Re: Backup & Restore
List 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-----


Attachment

pgsql-general by date:

Previous
From: "Thomas T. Thai"
Date:
Subject: Re: help with getting index scan
Next
From: Tom Lane
Date:
Subject: Re: Urgnt. - problem starting postgres