On Mon, 15 Apr 2013 19:54:15 -0700
Jeff Janes wrote:
> On Tue, Apr 9, 2013 at 3:05 AM, Eduardo Morras
>
> > wrote:
>
> > On Mon, 8 Apr 2013 10:40:16 -0500
> > Shaun Thomas > 'stho...@optionshouse.com');>> wrote:
> >
> > >
> > > Anyone else?
> > >
> >
> > If his db has low inserts/updates/delet
Hi Johann,
On Wed, 10 Apr 2013 09:58:05 +0200, Johann Spies
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). We use it
in some cont
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 wil
On Mon, 8 Apr 2013 10:40:16 -0500
Shaun Thomas 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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To mak
On Mon, Apr 8, 2013 at 6:14 AM, 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 p
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 g
2013/4/8 Johann Spies :
> 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 booklet).
Get the bookle
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 database
