Horton
Menu

Re: Proposal for Allow postgresql.conf values to be changed via SQL

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Greg Smith <greg@2ndQuadrant.com>
Cc: Amit kapila <amit.kapila@huawei.com>, "'Robert Haas'" <robertmhaas@gmail.com>, "'Josh Berkus'" <josh@agliodbs.com>, "'Magnus Hagander'" <magnus@hagander.net>, "'Christopher Browne'" <cbbrowne@gmail.com>, "'PostgreSQL-development'" <pgsql-hackers@postgresql.org>
Date: 2012-11-12T14:17:01Z
Lists: pgsql-hackers 
Greg Smith <greg@2ndQuadrant.com> writes:
> Regardless, exactly how to prevent two concurrent processes from writing 
> the same file feels like the last step in the small roadmap for what 
> this feature needs.

"Write a temp file and use rename(2) to move it into place" is the
standard solution for that.

			regards, tom lane