Hello,
We custom set variable
Added patroni.nodes_count = 2 in postgresql.conf
postgres=# show patroni.nodes_count;
patroni.nodes_count
-
2
(1 row)
postgres=# select current_setting('patroni.nodes_count');
current_setting
-
2
(1 row)
But can not select i
Dear all,
I recently used benchmarksql to evaluate the performance of postgresql. I
achievednearly 20% improvement with NUM_XLOGINSERT_LOCKS changed from 8 to
16under some cases of high concurrency.
I wonder whether it is feasible to make NUM_XLOGINSERT_LOCKS a
configurationparameter, so that u
I wrote:
> Yeah, that's what psql is expecting, but it does seem a bit
> unforgiving considering that you can write a noise semicolon
> in many other backslash commands. And this:
> dvdb=# \ef opid.bef_ins_axi_reqs_set_trig();
> ERROR: expected a right parenthesis
> seems outright buggy. I've
Adrian Klaver writes:
> On 1/8/24 08:26, David Gauthier wrote:
>> dvdb=# \ef opid.bef_ins_axi_reqs_set_trig;
>> ERROR: function "opid.bef_ins_axi_reqs_set_trig;" does not exist
> Lose the ';'.
> It should be:
> \ef opid.bef_ins_axi_reqs_set_trig
Yeah, that's what psql is expecting, but it does
On 1/8/24 00:23, Innocent Ememe wrote:
Good morning,
Hey I’ve been trying to install the postgresql and pgadmin software on
my Mac book for the past three days now and have been faced with some
issues and restrictions, that won’t allow the software to run. I wanted
to ask if your software is
On 1/8/24 08:26, David Gauthier wrote:
atletx7-reg017:/home/dgauthie[ 120 ] --> dvdbdev
Pager usage is off.
psql (11.5, server 11.3)
Type "help" for help.
dvdb=# \df opid.bef_ins_axi_reqs_set_trig;
List of functions
Schema | Name | Result
atletx7-reg017:/home/dgauthie[ 120 ] --> dvdbdev
Pager usage is off.
psql (11.5, server 11.3)
Type "help" for help.
dvdb=# \df opid.bef_ins_axi_reqs_set_trig;
List of functions
Schema | Name| Result data type | Argument data
types | Type
Hello everyone,
My team and I have a situation and would like to know if anyone is going
through something similar.
We have several RedHat 9 virtual servers, running PostgreSQL version 14.10.
Our backup tool is Veritas Netbackup 10.1.1 WebUI.
We needed to perform a PIT Recovery last week (on a
Good morning,
Hey I’ve been trying to install the postgresql and pgadmin software on my
Mac book for the past three days now and have been faced with some issues
and restrictions, that won’t allow the software to run. I wanted to ask if
your software is compatible with my MacBook Air 2012, iOS ve