public inbox for [email protected]  

help / color / mirror / Atom feed

From: David G. Johnston <[email protected]>
To: Dave Cramer <[email protected]>
Cc: Manav Kumar <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Unable to set guc via setProperty
Date: Fri, 20 Jun 2025 14:14:59 -0700
Message-ID: <CAKFQuwaLXgfpPAfEgwL7Q+a80-bCew3Z-rLbiWgEBJnjNBUkUg@mail.gmail.com> (raw)
In-Reply-To: <CADK3HH+0+Y8zC7EvxeP=LzKUPeFf2j+tn8sMY-w4EcnzXbTy2A@mail.gmail.com>
References: <CAPhCW+9yjyFbf21-LmGWkFZPNCF0hYPVy5ukTRxYXgOL+CHX7A@mail.gmail.com>
	<CAKFQuwaLd4tOYxE-Hw8CCWw2KZN_GooAmg6uHcOFF+et6hDNxw@mail.gmail.com>
	<CADK3HH+0+Y8zC7EvxeP=LzKUPeFf2j+tn8sMY-w4EcnzXbTy2A@mail.gmail.com>

On Fri, Jun 20, 2025 at 1:11 PM Dave Cramer <[email protected]>
wrote:

>
>
> On Fri, 20 Jun 2025 at 10:23, David G. Johnston <
> [email protected]> wrote:
>
>> On Friday, June 20, 2025, Manav Kumar <[email protected]> wrote:
>>
>>> Hi Team,
>>> I've a doubt regarding passing guc variables in start up packet as key
>>> value pairs instead of in options.
>>>
>>> I'm unable to set jdbc:postgresql://10.150.3.175:6433/postgres?&geqo=off
>>> m geqo to 'off'. I don't want to use "options" rather pass directly key
>>> value pairs similar to what JDBC driver internally does.
>>>
>>
>>> Neither setProperty("geqo", "off") works in this case.
>>> Can someone let me know why I can't do it?
>>>
>>
>> Probably because that isn’t how things work…connection properties are set
>> using set property and gucs aren’t connection properties - though there is
>> a pass-through connection property called options that can hold a list of
>> gucs to set.
>>
> David, for my elucidation are they GUC's ? The docs state:
> "Command-line arguments for the backend. (This is deprecated in favor of
> setting individual run-time parameters.) Spaces within this string are
> considered to separate arguments, unless escaped with a backslash (\);
> write \\ to represent a literal backslash."
>

geqo is a GUC
https://www.postgresql.org/docs/current/runtime-config-query.html#GUC-GEQO

And to pass GUCs into the postgres server process you bundle them up into
the "options" cli argument via the "options" parameter keyword that you've
quoted.

I do not see that deprecation warning in v18 documentation.

https://www.postgresql.org/docs/devel/libpq-connect.html#LIBPQ-CONNECT-OPTIONS

While some GUCs are also connection parameters (e.g., application_name) and
thus can be used directly most GUCs are not and much get lumped into
options.

David J.

view thread (4+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Unable to set guc via setProperty
  In-Reply-To: <CAKFQuwaLXgfpPAfEgwL7Q+a80-bCew3Z-rLbiWgEBJnjNBUkUg@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox