Re: Q: pg_hba.conf separate database names file format

On Tue, Nov 08, 2022 at 02:16:03PM +0100, Albrecht Dreß wrote: > However, I could not find a specification of the format for this > file… It appears as if simply giving each database name on a > separate line does the job. Is this correct? May the file contain > comments (i.e. lines starting wit

Re: escaping double-quotes in varchar array

On Tue, Nov 8, 2022 at 6:27 PM David Gauthier wrote: > > > dvdb=# insert into testarr (arr) values ('{"hijk\"lmnop"}'); > This is (one of) the correct ways to formulate what you want. > INSERT 0 1 > dvdb=# select * from testarr; >arr > - > {abc

escaping double-quotes in varchar array

psql (11.5, server 11.3) on linux Trying to insert a string containing a double-quote into a varchar arr. Here's my attempt dvdb=# create table testarr (arr varchar[]); CREATE TABLE dvdb=# insert into testarr (arr) values ('{"abcdefg"}'); INSERT 0 1 dvdb=# select * from testarr

Re: "set role" semantics

On 11/8/22 16:24, David G. Johnston wrote: On Tue, Nov 8, 2022, 17:16 Bryn Llewellyn > wrote: Notice that I didn't grant "connect" on either of the databases, "d1" or "d2", to any of the roles, "clstr$mgr, "d1$mgr", or "d2$mgr". You didn't have to since PUBLI

Re: "set role" semantics

On Tue, Nov 8, 2022, 17:16 Bryn Llewellyn wrote: > > Notice that I didn't grant "connect" on either of the databases, "d1" or > "d2", to any of the roles, "clstr$mgr, "d1$mgr", or "d2$mgr". > You didn't have to since PUBLIC gets that privilege and you didn't revoke it. https://www.postgresql.or

"set role" semantics

I created a little test to demonstrate to myself how “set role” works. I ran it in a freshly-created PG 11.17 cluster on Ubuntu, installed and configured like I’ve recently discussed on this list. I copied my "pg-init.sh" script at the end. I then did this test, after starting like this (as the

Re: Segmentation Fault PG 14

Willian Colognesi writes: > Looks like we can confirm that the jit disable fixed the problem, because > since yesterday when I disabled jit, the database did not restarted again, > and before it the database was restarting at least once per hour. Hmm. I now recall that we had a previous report o

Re: Segmentation Fault PG 14

Looks like we can confirm that the jit disable fixed the problem, because since yesterday when I disabled jit, the database did not restarted again, and before it the database was restarting at least once per hour. I don't think it will cause too much impact in our use case having it disabled, so,

Re: Information to CVE-2022-42889

> if the above product is affected by the CVE You will find the "Known PostgreSQL Security Vulnerabilities in Supported Versions" here: https://www.postgresql.org/support/security/ For the PostgreSQL JDBC Driver: please check https://jdbc.postgresql.org/security/ or the fixed CVE lists: https://g

Q: pg_hba.conf separate database names file format

Hi, according to the docs, the database specification in the pg_hba.conf file can be read from a separate file (: “A separate file containing database names can be specified by preceding the file name with @.”) However, I could no

Re: Feature suggestions for backup and replication

On 11/7/22 16:03, da avory wrote: Hi all, not sure whether this is the right list to ask. I do have two (small!?) feature suggestions, both regarding backup and replication, which might appeal to a wider audience. 1) it would be very great to have the option to add a timestamp to all lines

Aw: Information to CVE-2022-42889

> the german bureau for IT-Security "BSI" (Bundesamt für Sicherheit in der > Informationstechnik) has issued a warning for CVE CVE-2022-42889 with the > name commons-text. Insurance companies are obliged to analyse the installed > software for vulnerabilities of this type. As the Barmenia is usi

Re: Information to CVE-2022-42889

> On 08/11/2022 11:50 CET Cedric Aaron Towstyka > wrote: > > the german bureau for IT-Security "BSI" (Bundesamt für Sicherheit in der > Informationstechnik) has issued a warning for CVE CVE-2022-42889with the name > commons-text. Insurance companies are obliged to analyse the installed > software

Re: Segmentation Fault PG 14

You are right Thomas, Just confirmed and it's installed: ubuntu@ip-10-x-x-x:~$ apt search llvm | grep inst WARNING: apt does not have a stable CLI interface. Use with caution in scripts. libllvm10/focal,now 1:10.0.0-4ubuntu1 arm64 [installed,automatic] I was trying something like `llvm -version`

Information to CVE-2022-42889

Hello dear PostgreSQL Server Team, the german bureau for IT-Security "BSI" (Bundesamt für Sicherheit in der Informationstechnik) has issued a warning for CVE CVE-2022-42889 with the name commons-text. Insurance companies are obliged to analyse the installed software for vulnerabilities of this

for integer/bigint type while format to scientific notation, automatically get the correct number of precision

Hi, looking for the reverse of select '1.2923904e+07'::numeric::int; every time, I have to select to_char(12923904,'9.999'); if I do select to_char(12923904,'9.99'); then the result is different. For integer or bigint can I automatically have something like: select to_char(int,'9.

Feature suggestions for backup and replication

Hi all, not sure whether this is the right list to ask. I do have two (small!?) feature suggestions, both regarding backup and replication, which might appeal to a wider audience. 1) it would be very great to have the option to add a timestamp to all lines of output of pg_dump and pg_restore. We