| From: | Adam Witney <awitney(at)sghms(dot)ac(dot)uk> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Backup strategy |
| Date: | 2005-01-18 18:23:23 |
| Message-ID: | BE13049B.3F0C0%awitney@sghms.ac.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
I am setting up the backup strategy for my database.
The database contains around 25 tables containing quite a lot of data that
does not change very much (and when it does it is changed by me). And around
20 tables containing data which will be created and updated by the users
regularly.
I would like to backup the two sets of data separately at different
intervals. The first set only when I update it and the second set several
times per day.
Would it be best to set up a separate schema for the "static" tables? If so
what would be the simplest and safest way to transfer these tables into a
new schema?
Thanks for any help
Adam
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oleg Bartunov | 2005-01-18 18:25:34 | Re: Change type |
| Previous Message | Christopher Browne | 2005-01-18 18:16:55 | Re: What is xmin ? |