Re: [GENERAL] Backup advice

2013-04-16 Thread Eduardo Morras
On Mon, 15 Apr 2013 19:54:15 -0700 Jeff Janes jeff.ja...@gmail.com wrote: On Tue, Apr 9, 2013 at 3:05 AM, Eduardo Morras emorr...@yahoo.esjavascript:_e({}, 'cvml', 'emorr...@yahoo.es'); wrote: On Mon, 8 Apr 2013 10:40:16 -0500 Shaun Thomas stho...@optionshouse.com javascript:_e({},

[GENERAL] Backup advice

2013-04-15 Thread Jeff Janes
On Tue, Apr 9, 2013 at 3:05 AM, Eduardo Morras emorr...@yahoo.esjavascript:_e({}, 'cvml', 'emorr...@yahoo.es'); wrote: On Mon, 8 Apr 2013 10:40:16 -0500 Shaun Thomas stho...@optionshouse.com javascript:_e({}, 'cvml', 'stho...@optionshouse.com'); wrote: Anyone else? If his db has low

Re: [GENERAL] Backup advice

2013-04-10 Thread Johann Spies
Thanks everybody for your valuable comments. I can specify how many versions of the files should be kept on Tivoli. The database will regularly get new data and there is a continuous process of data cleaning. It is a database mainly for research purposes and a few researchers are using it. I

Re: [GENERAL] Backup advice

2013-04-10 Thread Gabriele Bartolini
Hi Johann, On Wed, 10 Apr 2013 09:58:05 +0200, Johann Spies johann.sp...@gmail.com wrote: I can specify how many versions of the files should be kept on Tivoli. Another option you can evaluate is the usage of backup catalogues, retention policies and archiving of Barman (www.pgbarman.org).

Re: [GENERAL] Backup advice

2013-04-09 Thread Eduardo Morras
On Mon, 8 Apr 2013 10:40:16 -0500 Shaun Thomas stho...@optionshouse.com wrote: Anyone else? If his db has low inserts/updates/deletes he can use diff between pg_dumps (with default -Fp) before compressing. --- --- Eduardo Morras emorr...@yahoo.es -- Sent via pgsql-general mailing

[GENERAL] Backup advice

2013-04-08 Thread Johann Spies
I would appreciate some advice from the experts on this list about the best backup strategy for my database. The setup: Size: might be about 200Gb The server uses a Tivoli backup client with daily backup At the moment There are pg_dumps for each database on the server on a daily, weekly and

Re: [GENERAL] Backup advice

2013-04-08 Thread Birta Levente
On 08/04/2013 16:14, Johann Spies wrote: I would appreciate some advice from the experts on this list about the best backup strategy for my database. The setup: Size: might be about 200Gb The server uses a Tivoli backup client with daily backup At the moment There are pg_dumps for each

Re: [GENERAL] Backup advice

2013-04-08 Thread Ian Lawrence Barwick
2013/4/8 Johann Spies johann.sp...@gmail.com: I would appreciate some advice from the experts on this list about the best backup strategy for my database. (...) I have read about using pg_basebackup in an article from Shaun Thomas' booklet on Packt Publishers (I will probably buy the

Re: [GENERAL] Backup advice

2013-04-08 Thread Shaun Thomas
On 04/08/2013 08:14 AM, Johann Spies wrote: Size: might be about 200Gb The server uses a Tivoli backup client with daily backup At the moment There are pg_dumps for each database on the server on a daily, weekly and monthly basis. All this gets backed up to the Tivoli server. Ok. So far, so

Re: [GENERAL] Backup advice

2013-04-08 Thread Jeff Janes
On Mon, Apr 8, 2013 at 6:14 AM, Johann Spies johann.sp...@gmail.com wrote: I would appreciate some advice from the experts on this list about the best backup strategy for my database. The setup: Size: might be about 200Gb The server uses a Tivoli backup client with daily backup At the