Re: [GENERAL] delete a file everytime pg server starts/crashes - Mailing list pgsql-general
On Sun, Oct 8, 2017 at 10:01 AM, athinivas <athinivas@gmail.com> wrote:
Yes, will take the epoch value from same and create a new file. Upon
subsequent calls, will access with that filename...if it fails(incase if the
postmaster is restarted), will create a new one.
@Melvin Does this capture all failure scenarios?? Or you have any other
better ways to do it. Your comments are much appreciated !!
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general- f1843780.html
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
athinivas,
This is covered in the documentation:
9.25. System Information Functions
pg_postmaster_start_time()
pg_postmaster_start_time()
It does not matter what caused the failure, it is the time Postgres is started again.
--
Melvin Davidson
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
pgsql-general by date: