Re: delete a file everytime pg server starts/crashes

From: pinker <pinker(at)onet(dot)eu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: delete a file everytime pg server starts/crashes
Date: 2017-10-06 15:27:30
Message-ID: 1507303650827-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vladimir Nicolici 2017-10-06 18:39:22 Re: Strange checkpoint behavior - checkpoints take a long time
Previous Message Nico Williams 2017-10-06 15:23:56 Re: Postgresql CDC tool recommendations ?