On Fri, May 20, 2022 at 5:31 AM Julien Rouhaud wrote:
> On Thu, May 19, 2022 at 06:38:46PM -0400, Tom Lane wrote:
> > Julien Rouhaud writes:
> > Pushed, with some minor twiddling to make ... descriptions more alike.
> Thanks a lot!
And thank you both! --DD
I have multiple processes connecting to the same database. In order to
prevent race conditions the I would like the process to issue a
SELECT FOR UPDATE to lock the records that need to be processed.
The problem is that the locks are not inside of a single translation.
The process is multi step.
On Thu, May 19, 2022 at 06:38:46PM -0400, Tom Lane wrote:
> Julien Rouhaud writes:
> > This time with the patch.
>
> Pushed, with some minor twiddling to make the .pgpass and .pg_service.conf
> descriptions more alike. I figured that the .pgpass docs are fine since
> (surely) many more people ha
Julien Rouhaud writes:
> This time with the patch.
Pushed, with some minor twiddling to make the .pgpass and .pg_service.conf
descriptions more alike. I figured that the .pgpass docs are fine since
(surely) many more people have looked at those passages and not
complained, so I made sure that th
On Thu, May 19, 2022 at 11:53:22PM +0800, Julien Rouhaud wrote:
> On Thu, May 19, 2022 at 10:11:06AM -0400, Tom Lane wrote:
> > I do not like your proposed wording, as it seems way too dense.
> > Can't we avoid the parenthetical remarks (plural) inside a sub-clause?
> > You're asking the reader to
On Thu, May 19, 2022 at 10:11:06AM -0400, Tom Lane wrote:
> I do not like your proposed wording, as it seems way too dense.
> Can't we avoid the parenthetical remarks (plural) inside a sub-clause?
> You're asking the reader to keep track of about three levels of
> interrupt.
Yes, I was a bit unhap
On Thu, 2022-05-19 at 15:43 +0200, Koen De Groote wrote:
> On Thu, May 19, 2022 at 9:10 AM Laurenz Albe wrote:
> > On Wed, 2022-05-18 at 22:51 +0200, Koen De Groote wrote:
> > > When connection is gone or blocked, archive_command fails after the
> > > timeout specified
> > > by the NFS mount, as
Julien Rouhaud writes:
> We can't change the default file in older branches obviously, but I'd be a bit
> worried about changing the default in the next major version either as it
> would
> add unnecessary pain for users that do know and rely on the current default.
> I
> guess we have to live
Hello Laurenz,
Thanks for the reply. That would mean the source code is here:
https://github.com/postgres/postgres/blob/REL_11_0/src/backend/postmaster/pgarch.c
Just to be sure, the "signal" you speak of, this is the result of the
command executed by archive_command?
If my understanding of the c
On Thu, May 19, 2022 at 10:57:55AM +0200, Dominique Devienne wrote:
> On Thu, May 19, 2022 at 10:17 AM Julien Rouhaud wrote:
> > > Or is it instead a lack of symmetry in the implementations of these
> > > two mechanisms?
> >
> > As far as I can see from the code it should be
> > %APPDATA%\postgres
On Thu, May 19, 2022 at 10:17 AM Julien Rouhaud wrote:
> > Or is it instead a lack of symmetry in the implementations of these
> > two mechanisms?
>
> As far as I can see from the code it should be
> %APPDATA%\postgresql\.pg_service.conf
>
> Does this one work?
Yes it does! Thanks.
> There is a
Hi,
On Thu, May 19, 2022 at 3:46 PM Dominique Devienne wrote:
>
> The doc is explicit about defaults for the password file:
> From https://www.postgresql.org/docs/current/libpq-pgpass.html
> Linux: ~/.pgpass
> Windows: %APPDATA%\postgresql\pgpass.conf
>
> But for the service file OTOH, only the L
Hi,
The doc is explicit about defaults for the password file:
>From https://www.postgresql.org/docs/current/libpq-pgpass.html
Linux: ~/.pgpass
Windows: %APPDATA%\postgresql\pgpass.conf
But for the service file OTOH, only the Linux default is documented:
From: https://www.postgresql.org/docs/curre
On Wed, 2022-05-18 at 22:51 +0200, Koen De Groote wrote:
> I've got a setup where archive_command will gzip the wal archive to a
> directory that is itself an NFS mount.
>
> When connection is gone or blocked, archive_command fails after the timeout
> specified by the NFS mount, as expected. (fo
14 matches
Mail list logo
