Re: Re: Proposal: Store "timestamptz" of database creation
on "pg_database"
From:
Stephen Frost <sfrost(at)snowman(dot)net>
To:
Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
Cc:
Peter Eisentraut <peter_e(at)gmx(dot)net>, Robert Haas <robertmhaas(at)gmail(dot)com>,Christopher Browne <cbbrowne(at)gmail(dot)com>,Hannu Krosing <hannu(at)2ndquadrant(dot)com>,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 <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: Re: Proposal: Store "timestamptz" of database creation
on "pg_database"
Date:
2013-01-05 16:04:43
Message-ID:
20130105160443.GU16126@tamriel.snowman.net (view raw or flat )
Thread:
2012-12-27 00:48:52 from Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
2012-12-27 01:08:13 from Josh Berkus <josh(at)agliodbs(dot)com>
2012-12-27 01:30:29 from Stephen Frost <sfrost(at)snowman(dot)net>
2012-12-27 04:13:54 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-12-27 04:32:44 from Stephen Frost <sfrost(at)snowman(dot)net>
2012-12-27 05:33:01 from Josh Berkus <josh(at)agliodbs(dot)com>
2012-12-27 12:08:56 from Stephen Frost <sfrost(at)snowman(dot)net>
2012-12-27 16:04:42 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2012-12-27 23:02:36 from Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
2012-12-28 02:14:58 from Stephen Frost <sfrost(at)snowman(dot)net>
2012-12-28 10:04:29 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2012-12-28 12:05:57 from Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
2012-12-28 18:53:05 from Josh Berkus <josh(at)agliodbs(dot)com>
2012-12-29 14:12:07 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2012-12-29 14:34:41 from Stephen Frost <sfrost(at)snowman(dot)net>
2012-12-29 14:45:00 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2012-12-29 14:59:49 from Stephen Frost <sfrost(at)snowman(dot)net>
2012-12-29 15:26:18 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-12-29 15:49:23 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-01-03 01:35:00 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-01-03 02:01:48 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-01-03 10:03:17 from Hannu Krosing <hannu(at)krosing(dot)net>
2013-01-03 10:18:08 from Andres Freund <andres(at)2ndquadrant(dot)com>
2013-01-03 11:34:23 from Hannu Krosing <hannu(at)krosing(dot)net>
2013-01-03 13:17:46 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-01-03 13:40:33 from Hannu Krosing <hannu(at)krosing(dot)net>
2013-01-03 13:42:49 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-01-03 13:46:20 from Hannu Krosing <hannu(at)2ndQuadrant(dot)com>
2013-01-03 14:09:22 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-01-03 16:15:31 from Hannu Krosing <hannu(at)2ndQuadrant(dot)com>
2013-01-03 17:27:45 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-01-03 17:54:45 from Christopher Browne <cbbrowne(at)gmail(dot)com>
2013-01-03 20:26:09 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-01-04 18:07:37 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2013-01-05 15:48:40 from Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
2013-01-05 16:04:43 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-01-05 17:59:30 from Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
2013-01-05 19:31:53 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-01-07 00:54:48 from Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
2013-01-07 13:42:32 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-01-08 15:08:29 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-01-08 22:09:23 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2013-01-08 22:12:21 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2013-01-08 22:17:41 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-01-09 04:42:45 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2013-01-08 13:47:27 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-01-03 14:18:38 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2013-01-03 10:20:09 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2013-01-03 13:15:51 from Stephen Frost <sfrost(at)snowman(dot)net>
2012-12-27 22:58:36 from Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
2013-01-03 01:52:27 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-01-03 02:02:09 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2013-01-03 02:12:06 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-01-03 04:04:43 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-01-03 10:28:15 from Bernd Helmle <mailings(at)oopsware(dot)de>
2013-01-03 10:54:03 from Hannu Krosing <hannu(at)2ndQuadrant(dot)com>
2013-01-03 02:06:01 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-01-03 08:16:59 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2013-01-03 16:38:49 from Greg Stark <stark(at)mit(dot)edu>
2013-01-03 04:08:26 from Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
2013-01-03 13:13:11 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-01-03 13:33:47 from Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
2013-01-03 13:40:09 from Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
2013-01-03 13:41:23 from Stephen Frost <sfrost(at)snowman(dot)net>
2013-01-03 15:00:05 from Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
2013-01-03 14:12:25 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2013-01-03 14:18:02 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2013-01-03 14:22:36 from Robert Haas <robertmhaas(at)gmail(dot)com>
2013-01-03 14:30:12 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2013-01-03 15:17:07 from Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
2013-01-03 16:17:33 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Lists:
pgsql-hackers
* Fabrízio de Royes Mello (fabriziomello(at)gmail(dot)com) wrote:
> * also we discuss about create two new catalogs, one local and another
> shared (like pg_description and pg_shdescription) to track creation times
> of all database objects.
Creating a separate catalog (or two) every time we want to track XYZ for
all objects is rather overkill... Thinking about this a bit more, and
noting that pg_description/shdescription more-or-less already exist as a
framework for tracking 'something' for 'all catalog entries'- why don't
we just add these columns to those tables..? This would also address
Peter's concern about making sure we do this 'wholesale' and in one
release rather than spread across multiple releases- just make sure it
covers the same set of things which 'comment' does.
Also, I don't think we really need a GUC for this.
Thanks,
Stephen
In response to
Responses
pgsql-hackers by date
Next :From: Boszormenyi ZoltanDate: 2013-01-05 16:17:03Subject : Re: [PATCH] Make pg_basebackup configure and start standby
[Review]Previous :From : Magnus HaganderDate : 2013-01-05 15:58:01Subject : Re: [PATCH] Make pg_basebackup configure and start standby [Review]
