Is there a way to determine creation time of a PostgreSQL database?

Question

I have a PostgreSQL server with several databases on it.

Is it possible to determine when each database on a database server was created?

score 1 · Answer 1 · answered Sep 21 '19 at 23:25

1

SELECT (pg_stat_file('base/'||oid ||'/PG_VERSION')).modification, datname FROM pg_database;

You can find answer here.

answered Sep 21 '19 at 23:25

Alan Sereb

I’ll try this out and see what it looks like. – Brett Rowberry Sep 22 '19 at 00:22

1 Answers1