From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: pg_dump --comment? |
Date: | 2004-05-28 14:48:56 |
Message-ID: | 40B75158.7090309@dunslane.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Jon Jensen wrote:
>On Fri, 28 May 2004, Christopher Kings-Lynne wrote:
>
>
>
>>>I've encountered a situation where I'd like to store some information
>>>about the database when I do a pg_dump. For instance, the timestamp of
>>>the dump. And some other information that I pull from the database.
>>>
>>>
>>I think every dump should dump the timestamp regardless...
>>
>>
>
>That would cause me a lot of trouble. Every night I do a pg_dump on all my
>databases to a temporary file. Then I use cmp to compare that dump to last
>night's dump. If they're identical I just delete the new dump so that only
>the old one remains, with its original timestamp. That way rsync doesn't
>see any change, and doesn't waste any time comparing it when we do
>backups. It's also handy to see the last day the dump changed by looking
>at the file's timestamp.
>
>Granted, this is only of interest on databases that don't change at all,
>but on a multi-user system we have a surprising number of databases that
>don't change at all for days (alongside the ones that change all the time,
>of course).
>
>However, I would like to see an option to include the timestamp if someone
>wants it.
>
>
>
That makes sense.
A better answer to this particular problem might be incremental dumps,
though :-)
cheers
andrew
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2004-05-28 14:57:48 | Re: Win32, PITR, nested transactions, tablespaces |
Previous Message | Tom Lane | 2004-05-28 14:38:20 | Re: On query rewrite |
From | Date | Subject | |
---|---|---|---|
Next Message | James Robinson | 2004-05-28 15:15:28 | Re: pg_dump --comment? |
Previous Message | Jon Jensen | 2004-05-28 14:15:38 | Re: pg_dump --comment? |