* Tom Lane (t...@sss.pgh.pa.us) wrote:
> Stephen Frost writes:
> > At least on a first blush look through the threads linked from such a
> > search, I'm unimpressed by the arguments against and note that there are
> > quite a few arguments for.
>
> I think you missed the worries around what dump/
Stephen Frost writes:
> At least on a first blush look through the threads linked from such a
> search, I'm unimpressed by the arguments against and note that there are
> quite a few arguments for.
I think you missed the worries around what dump/reload semantics would be.
> We could provide a
David,
* David G. Johnston (david.g.johns...@gmail.com) wrote:
> The only source of data for that question is the local filesystem. If
> that is acceptable you can find examples online provided to others who have
> asked this question.
What on the local filesystem would help here..? All you kno
On 02/22/2016 03:24 PM, Edson F. Lidorio wrote:
+ 1
Listen11similar discussionat [1]
[1]
http://pgsql-hackers.postgresql.narkive.com/TQSHWw1l/proposal-store-timestamptz-of-database-creation-on-pg-database
Where the above leads to is implementing a version control system inside
the datab
avid G. Johnston <mailto:david.g.johns...@gmail.com>
Sent: 2/23/2016 0:14
To: Edson F. Lidorio <mailto:ed...@openmailbox.org>
Cc: pgsql-general <mailto:pgsql-general@postgresql.org>
Subject: Re: [GENERAL] Get the date of creation of objects in the
database
O
On Mon, Feb 22, 2016 at 5:18 PM, Zlatko Asenov
wrote:
> You may find useful a SIEM to record activity like this.
> --
> From: David G. Johnston
> Sent: 2/23/2016 0:14
> To: Edson F. Lidorio
> Cc: pgsql-general
> Subject: Re: [GENERAL] Get th
You may find useful a SIEM to record activity like this.
-Original Message-
From: "David G. Johnston"
Sent: 2/23/2016 0:14
To: "Edson F. Lidorio"
Cc: "pgsql-general"
Subject: Re: [GENERAL] Get the date of creation of objects in the database
On Mon, Fe
On Mon, Feb 22, 2016 at 3:00 PM, Edson F. Lidorio
wrote:
> Hello,
>
> How to get the date of creation of objects in batabase?
> For example: The date of creation of tables and trigger.
>
The only source of data for that question is the local filesystem. If
that is acceptable you can find examp
On 02/22/2016 02:00 PM, Edson F. Lidorio wrote:
Hello,
How to get the date of creation of objects in batabase?
For example: The date of creation of tables and trigger.
AFAIK that is not recorded by default. If you are using Postgres 9.3+
you could roll your own audit system, going forward, us