Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] delete a file everytime pg server starts/crashes - Mailing list pgsql-general

From pinker
Subject Re: [GENERAL] delete a file everytime pg server starts/crashes
Date
Msg-id 1507303650827-0.post@n3.nabble.com
Whole thread Raw
In response to [GENERAL] delete a file everytime pg server starts/crashes  (athinivas <athinivas@gmail.com>)
Responses Re: [GENERAL] delete a file everytime pg server starts/crashes  (athinivas <athinivas@gmail.com>)
List pgsql-general
Tree view 
Actually if the name of the file doesn't matter you could put it into
$PGDATA/pg_stat and name it global.stat. When postgres stops (clean or
because of failure), replaces the file with his own. So your content will be
erased.
I'm not sure it's completely safe but works in simple test.



--
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

pgsql-general by date:

Previous
From: Nico Williams
Date:
Subject: Re: [GENERAL] Postgresql CDC tool recommendations ?
Next
From: Vladimir Nicolici
Date:
Subject: Re: [GENERAL] Strange checkpoint behavior - checkpoints take a long time