Re: Question: Multiple pg clusters on one server can be reached with the standard port.

Hi, Am 19.06.23 um 12:33 schrieb Peter J. Holzer: As Francisco already pointed out, this can't work with nginx either. The client resolves the alias and the TCP packets only contain the IP address, not the alias which was used to get that address. So nginx simply doesn't have that information an

Re: Question: Multiple pg clusters on one server can be reached with the standard port.

Hi, Am 16.06.23 um 13:53 schrieb Brainmue: possible solutions: * set up a firewall rule to forward connection * use a tcp proxy (nginx can do that) * check pg_bouncer best regards Thomas Hello Thomas, Thank you for your quick reply. With firewall you mean an additional software, right? Bec

Re: Question: Multiple pg clusters on one server can be reached with the standard port.

Hi Am 16.06.23 um 11:40 schrieb Brainmue: Hello all, I am currently looking for a solution similar to Oracle Listener. Current situation: I have a system with multiple PostgreSQL clusters for different databases. Each cluster is running on the same physical machine and is accessed through its

Re: Getting json-value as varchar

Hi, Am 06.01.22 um 13:36 schrieb Andreas Joseph Krogh: På torsdag 06. januar 2022 kl. 13:31:19, skrev Thomas Markus : Hi, Am 06.01.22 um 13:28 schrieb Andreas Joseph Krogh: Hi, in PG-14 this query returns "value" (with double-quotes): SELECT ('{"key&quo

Re: Getting json-value as varchar

Hi, Am 06.01.22 um 13:28 schrieb Andreas Joseph Krogh: Hi, in PG-14 this query returns "value" (with double-quotes): SELECT ('{"key":"value"}'::jsonb)['key']; ┌─┐ │  jsonb  │ ├─┤ │ "value" │ └─┘ (1 row) and this returns 'value' (without the quotes): SELECT ('{"key":"valu

Re: Match 2 words and more

Am 28.11.21 um 01:27 schrieb Shaozhong SHI: this is supposed to find those to have 2 words and more. select name FROM a_table where "STREET_NAME" ~ '^[[:alpha:]+ ]+[:alpha:]+$'; But, it finds only one word as well. It appears that regex is not robust. Can anyone shed light on this? Rega

Re: Parallelism on Partitioning .

Hi Hi , We are trying to assign the parallel worker or execute the query in parallel manner on partitioned Tables and partitioned master table but not able to do that ,could u plz suggest . Current Postgresql version :- 9.6 Fyi, We have tried with all parameters which can allow the paralle

Re: Practical usage of large objects.

Am 14.05.20 um 15:36 schrieb Laurenz Albe: Interesting; only recently I played with that a little and found that that is not necessarily true: https://www.cybertec-postgresql.com/en/binary-data-performance-in-postgresql/ Yours, Laurenz Albe We used lo a lot in a project for large uploads (>4G

Re: install postgres

Hi, there's a section "Direct RPM download" ;) Or https://download.postgresql.org/pub/repos/yum/12/redhat/ regards Thomas Am 20.12.19 um 10:24 schrieb Marc Millas: Hi, I may overlook something obvious.. I am just looking, on the download pages of postgresql.org for a

Re: sha512sum (program) gives different result than sha512 in PG11

Hi, echo contains a trailing carriage return. Try echo -n "A" | sha512sum regards Thomas Am 14.01.19 um 16:16 schrieb Andreas Joseph Krogh: Hi. Anyone can explain why these two don't give the same result? 1. $ echo "A" | sha512sum 7a296fab5364b34ce3e0476d55bf291bd41aa085e5ecf2a96883e593aa183

Re: duplicate primary key

Am 22.11.17 um 12:05 schrieb Alexander Pyhalov: Hello. I'm a bit shocked. During import/export of our database we've found a duplicate primary key. # \d player Table "public.player"    Column   |    Type |     Modifiers --