postgresql custom variable in pg_settings table

2024-01-08 Thread Yi Sun
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

Make NUM_XLOGINSERT_LOCKS configurable

2024-01-08 Thread 1111hqshj
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

Re: How to \ef a function ?

2024-01-08 Thread Tom Lane
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

Re: How to \ef a function ?

2024-01-08 Thread Tom Lane
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

Re: Unable to install postgresql and pgadmin

2024-01-08 Thread Adrian Klaver
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

Re: How to \ef a function ?

2024-01-08 Thread Adrian Klaver
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

How to \ef a function ?

2024-01-08 Thread David Gauthier
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

Point-In-Time Recovery issue - Timeline file lost

2024-01-08 Thread Carlos Augusto Ferreira de Oliveira
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

Unable to install postgresql and pgadmin

2024-01-08 Thread Innocent Ememe
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