From: | "filippo" <filippo2991(at)virgilio(dot)it> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | backup database by cloning itself |
Date: | 2007-02-13 13:54:44 |
Message-ID: | 1171374883.983895.256770@s48g2000cws.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
my database is not very big so I want to adopt this backup strategy:
I want to clone my database every 1 hour to another
database 'currenttime_mydatabase' in order to have 24 backup a day,
overwriting the yesterday backups by today-same-time backups.
This is good for me because I have all the backups readily available
to be read by my program (opening the backup read only). This is a
very important for my needs.
I'm writing a script run by cron each hour to do accomplish the backup
task.
My target is to have the backup operation not affecting the users, so
I want to be able to copy a database even if the database is used by
someone.
Can I use
CREATE DATABASE my_backup_database TEMPLATE current_database?
Is there a better way to get what I need?
Thanks,
Filippo
From | Date | Subject | |
---|---|---|---|
Next Message | A. Kretschmer | 2007-02-13 13:55:36 | Re: Function, that returns set of 2 tables columns |
Previous Message | Cristiano Panvel | 2007-02-13 13:49:54 | Re: PostgreSQL and OpenLdap |