Skip site navigation (1) Skip section navigation (2)

Re: Re: Proposal: Store "timestamptz" of database creation on "pg_database"

From: "Kevin Grittner" <kgrittn(at)mail(dot)com>
To: "Andrew Dunstan" <andrew(at)dunslane(dot)net>
Cc: "Robert Haas" <robertmhaas(at)gmail(dot)com>,"Christopher Browne" <cbbrowne(at)gmail(dot)com>,"Hannu Krosing" <hannu(at)2ndquadrant(dot)com>,"Stephen Frost" <sfrost(at)snowman(dot)net>,"Andres Freund" <andres(at)2ndquadrant(dot)com>,"Dimitri Fontaine" <dimitri(at)2ndquadrant(dot)fr>,"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>,"Josh Berkus" <josh(at)agliodbs(dot)com>,pgsql-hackers(at)postgresql(dot)org
Subject: Re: Re: Proposal: Store "timestamptz" of database creation on "pg_database"
Date: 2013-01-03 22:30:49
Message-ID: 20130103223050.4850@gmx.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Andrew Dunstan wrote:

> I don't especially have a horse in the race, but ISTM that if you want 
> the information you want it to be able to persist across dump/restore, 
> at least optionally. If you can happily lose it when you're forced to 
> recover using a logical dump then it's not that important to you.

On that point I guess we will just disagree. In my experience, if
you are OK with a periodic pg_dump for your primary backup
technique, then the data is just not that important to you. And if
you drop and re-create a table from pg_dump output, that event is
worth noting -- I would rather see the timestamp of applying the
pg_dump output.

When it comes to forensics, why don't we feel that it is worth
preserving next available xid and every tuple's xmin and xmax
through pg_dump? I don't think we should, but the arguments against
trying to do it seem similar to me. They are newly created tables
when you run the SQL generated by pg_dump, with fresh rows and
indexes. To pretend otherwise seems to me to reduce the value of
the feature.

On the other hand, having one central way to deal with it for all
object types seems to increase the value of the feature.

-Kevin


Responses

pgsql-hackers by date

Next:From: Joshua D. DrakeDate: 2013-01-03 22:45:11
Subject: Re: Re: Proposal: Store "timestamptz" of database creation on "pg_database"
Previous:From: Andrew DunstanDate: 2013-01-03 22:11:28
Subject: Re: Re: Proposal: Store "timestamptz" of database creation on "pg_database"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group