backup database by cloning itself

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

Responses

Browse pgsql-general by date

  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