Online Backups PostGre

From: PostGre Newbie <garbagegigo(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Online Backups PostGre
Date: 2009-05-01 16:22:59
Message-ID: 2a24d250-d5d4-4793-8a4f-f1253f793a97@g31g2000pra.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi everyone,

I am new to PostGreSql but I have to use it at work. I have to take
backups of the database every 10 mins so that work isn't lost in case
of an accident. I use PostGreSql v8.1 on Windows XP.

I have already set up a system that automatically takes the backup of
the database every 10 mins. I did this using a batch file script set
up in scheduled tasks to run every 10 mins. The command I used inside
the batch file is:
pg_dump dbname -U postgres -o > backup_file_name

I tested the system and it works correctly but I know that in the live
server the pg_dump command will take a long time to execute. I know
that I should use a 'point in time recovery backup' but I am confused
how to exactly go about it as I am new to PostGre.

I searched the web and I know I should get a snapshot of the
filesystem and then backup the WAL archive logs but this is the part
where I am confused. I do not know of any open source backup utilities
that can take snapshots of the filesystem. I get the overall concept
of online backups but I am still unclear EXACTLY how the system works.
I would be grateful if anyone could explain it to me. I have already
gone through the postgresql document on online backups.

I know that taking the backup of the whole database every 10 minutes
is a very bad way to go about it but until I find a better way to do
it, it will have to do for now. Any suggestions/tips/articles on how
to do the backup would be appreciated very much.

Thanks in advance,

PostGre Newbie.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ben Chobot 2009-05-01 16:47:07 Re: Online Backups PostGre
Previous Message Tom Lane 2009-05-01 15:50:21 Re: Understand this error