Re: PostgreSQL C++ Interface version 14.9 using static library instead of shared library

; /lib64/ld-linux-x86-64.so.2 (0x7f2306bee000) > > Any suggestion and feedback , why it is taking static library instead of > shared object ? > *Also there is the size difference of libpq.so. in 14.8 it is around 320 > kb and in 14.9 it is around 6 mb**.* > > Thanks >

Re: pg_agent jobs

a more "SQL only way to do it? thanks in advance, G Il giorno ven 29 set 2023 alle ore 18:15 Adrian Klaver < adrian.kla...@aklaver.com> ha scritto: > On 9/29/23 08:55, Giovanni Biscontini wrote: > > Hello all members, here's my question: db version 14.5 > > we have to

pg_agent jobs

Hello all members, here's my question: db version 14.5 we have to create a pg_agent job with 2 steps: 1_step execute query: if query result is true or find > 0 records then process next step, else it stops executing job 2_step execute batch command we tried to seta as 1_step the query: SELECT EXIST

Re: pgbouncer

y > it on the db server or on the webserver? > -- > --- Get your facts first, then you can distort them as you please.-- > -- *Best Regards* *Dott. Giovanni Biscontini* Software Developer & Database Architect Web: https://www

Re: PostgreSQL

E, DELETE or > can affects to operations on whole database, table like vacuum or reindex > etc ? > > Wiadomość napisana przez Giovanni Biscontini > w dniu 07.02.2023, o godz. 12:16: > >  > Hi Joseph, >one way to filter without RLS is using functions to make queries:

Re: PostgreSQL

ny better solutions?? > > What are the advantages and disadvantages of RLS? > > How much RLS will cause a decrease in database performance? > > JK > > > > > -- *Cordiali Saluti* *Dott. Giovanni Biscontini* * [Divisone Software]* *Str. Po

Re: New to PostgreSQL - looking for query writing tools

d around with >> pgAdmin (doesn’t seem to have the same query writing abilities) and EMS SQL >> Query (seems more cumbersome than the Microsoft tool). Are there any other >> tools I should be looking at for query writing help? I like to something >> visual and a grid to help

Best Open Source OS for Postgresql

choice? Thanks in advance and best regards, Giovanni -- *Cordiali Saluti - Best Regards* *Dott. Giovanni Biscontini* * [Divisone Software]* WEB: https://www.es2000.it <http://www.es2000.it/> Privacy e riservatezza: il present

replication phisical + logical

ption than the whole master2 is restored: so db2 is removed as template0, template1 and postgres system db are replaced from restore command. Alternative suggestions' will be appreciated. Thanks in advance and best regards, Giovanni -- *Dott. Giovanni Biscontini* * [Divisone Software]*

Re: recovery_command has precedence over phisical slots?

Il giorno mer 24 ago 2022 alle ore 13:00 Laurenz Albe < laurenz.a...@cybertec.at> ha scritto: > On Wed, 2022-08-24 at 14:18 +0900, Kyotaro Horiguchi wrote: > > At Fri, 19 Aug 2022 18:37:53 +0200, Laurenz Albe < > laurenz.a...@cybertec.at> wrote in > > > On Fri, 20

recovery_command has precedence over phisical slots?

Hello everyone, I'm experiencing a behaviour I don't really understand if is a misconfiguration or a wanted behaviour: 1) I set up a primary server (a.k.a. db1) with and archive_command to a storage 2) I set up a replica (a.k.a. db2) that created a slot named as slot_2 and that has the recovery_com