Re: a back up question - Mailing list pgsql-general

From Martin Mueller
Subject Re: a back up question
Date
Msg-id DC910292-168E-4FE2-956D-D5C942D9E5C3@northwestern.edu
Whole thread Raw
In response to Re: a back up question  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Responses Re: a back up question
Re: a back up question
Re: a back up question
List pgsql-general

On 12/6/17, 4:39 AM, "karsten.hilbert@gmx.net" <karsten.hilbert@gmx.net> wrote:

    On Tue, Dec 05, 2017 at 09:52:28PM +0000, Martin Mueller wrote:
    
    > Are there rules for thumb for deciding when you can dump a
    > whole database and when you’d be better off dumping groups of
    > tables?
    
    It seems to me we'd have to define the objective of "dumping" first ?
    
    Regards,
    Karsten
    -- 
    GPG key ID E4071346 @ eu.pool.sks-keyservers.net
    E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346
    

The objective is to create a  backup from which I can restore any or all tables in the event of a crash. In my case,  I
usePostgres for my own scholarly purposes. Publications of whatever kind are not directly made public via the database.
Iam my only customer, and a service interruption, while a nuisance to me, does not create a crisis for others. I don’t
wantto lose my work, but a service interruption of a day or a week is no big deal. 
 
    


pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: a back up question
Next
From: Bruyninckx Kristof
Date:
Subject: replication terminated by primary server