LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 12-18-2013, 03:57 AM   #1
zama
Member
 
Registered: Mar 2012
Posts: 34

Rep: Reputation: Disabled
Incremental backup of PostgreSQL database


We run a database server running PostgreSQL with database size of around 130 GB growing at a rate of 500MB per day . We use HP Data Protector software to take backup of the database . The issue here is that our database is on a GFS mounted partition and the current Backup software license does not facilitate taking backup from GFS , NFS mounted partitions.

So , as a workaround we planned to copy the database to a local partition using pg_dump utility and take backup from the local partition using data protector software. But I am not sure whether we can take incremental backup using pg_dump . Full backup everyday is not possible for us.

Please suggest steps for taking incremental backup from PostgreSQL database.
 
Old 12-18-2013, 04:02 AM   #2
pan64
LQ Addict
 
Registered: Mar 2012
Location: Hungary
Distribution: debian/ubuntu/suse ...
Posts: 21,850

Rep: Reputation: 7309Reputation: 7309Reputation: 7309Reputation: 7309Reputation: 7309Reputation: 7309Reputation: 7309Reputation: 7309Reputation: 7309Reputation: 7309Reputation: 7309
here you can find some tips and answers:
http://www.postgresql.org/docs/9.3/s...archiving.html
http://www.postgresql.org/docs/9.3/s...m-standby.html
 
  


Reply

Tags
backup, incremental, postgresql



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
how to take postgresql database backup in linux sanjay87 Linux - Server 1 08-25-2012 12:28 PM
incremental backup mahmoud Linux - Newbie 3 11-28-2008 04:31 AM
incremental backup jdeeptir Linux - Newbie 5 05-24-2008 06:51 PM
Incremental backup Ammad Linux - Software 2 02-22-2008 03:41 PM
About incremental backup satimis Linux - Software 0 06-15-2006 04:01 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 04:07 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration