autovacuum worker started without a worker entry

Hi all, I occasionally see the message "WARNING: autovacuum worker started without a worker entry" in the logs. >From what I can see here , the launcher forked a worker and in the meantime the launcher deci

Re: Using functions in regexp replace captures

On Wednesday, August 4, 2021, David G. Johnston wrote: > > But no, you cannot directly write: f(x, y, g(a)) where a is the > replacement string because you don’t know what a is when the inner function > g is evaluated first. You need: f(x, y, g(h(x, y))) where h is the > matching function, g i

Re: Using functions in regexp replace captures

On Wednesday, August 4, 2021, Tim Uckun wrote: > I want to do something like this > > SELECT REGEXP_REPLACE('some_string','(.*) > (.*)',some_function_that_returns_string('\2',' \1')); > > Is this possible at all? > > Generally I’d say yes, it is possible to combine multiple subqueries together to

Using functions in regexp replace captures

I want to do something like this SELECT REGEXP_REPLACE('some_string','(.*) (.*)',some_function_that_returns_string('\2',' \1')); Is this possible at all?

Re: Unexpected block ID found when reading data

On Tue, 3 Aug 2021 at 20:37, Gilar Ginanjar wrote: > I’m not sure which patch version i used to dump, but i was using postgre > 12.5 for pg_dump back then. > > I’m running pg_restore -f dbdump.backup right now, I think it will take > some times because it has a large size (around 9 GB). There are

Re: “tlsv1 alert unknown ca” with PQconnectdb

M Tarkeshwar Rao writes: > I am trying psql with following options where I am providing client > certificates also. It is connected perfectly. > psql "host= 10.10.11.18 sslmode=verify-ca sslrootcert=em-ca-crt.pem > sslcert=em-client-crt.pem sslkey=em-client-key.pem port=5433 user=postgres > dbn

“tlsv1 alert unknown ca” with PQconnectdb

Hi all, I made following changes in my Postgres server which means I am enabling one way authentication: (Disabled Mutual authentication. Only client will authenticate server.) hostssl all myuser 0.0.0.0/0 md5 clientcert=0 I am trying psql with following optio