Re: PgBouncer-Postgres : un supported startup parameter statement_timeout

On 7/16/25 08:40, Achilleas Mantzios wrote: On 7/16/25 08:22, KK CHN wrote: Hi, I am facing an issue with PgBouncer-Postgres setup, *PgBouncer (PgBouncer 1.23.1 running on VM instance FreeBSD 14.2) and PostgreSQL DB cluster on a virtual machine (PG version 16.0,  RHEL 9.4) *. My

Re: PgBouncer-Postgres : un supported startup parameter statement_timeout

On 7/16/25 08:22, KK CHN wrote: Hi, I am facing an issue with PgBouncer-Postgres setup, *PgBouncer (PgBouncer 1.23.1 running on VM instance FreeBSD 14.2) and PostgreSQL DB cluster on a virtual machine (PG version 16.0,  RHEL 9.4) *. My application backend is nodeJS which throws the follow

Re: issue/bug management, project management, people management, product management all in one, preferably open source software ?

On 5/23/25 09:58, Wim Bertels wrote: Justin Clift schreef op vr 23-05-2025 om 09:23 [+1000]: On 2025-05-23 03:52, Achilleas Mantzios wrote: Hi people I'd like to know if people here know of or use any integrated solution for all or some of the above. It would be nice if it supported

Re: issue/bug management, project management, people management, product management all in one, preferably open source software ?

On 5/23/25 00:23, Justin Clift wrote: On 2025-05-23 03:52, Achilleas Mantzios wrote: Hi people I'd like to know if people here know of or use any integrated solution for all or some of the above. It would be nice if it supported LDAP / OAuth 2.0 , integrate with plain vanilla git

Re: issue/bug management, project management, people management, product management all in one, preferably open source software ?

On 5/22/25 20:33, Albrecht Dreß wrote: Am 22.05.25 21:04 schrieb(en) Adrian Klaver: On 5/22/25 10:52, Achilleas Mantzios wrote: Hi people I'd like to know if people here know of or use any integrated solution for all or some of the above. It would be nice if it supported LDAP / OAut

Re: issue/bug management, project management, people management, product management all in one, preferably open source software ?

On 5/22/25 20:23, Ray O'Donnell wrote: On 22/05/2025 18:52, Achilleas Mantzios wrote: Hi people I'd like to know if people here know of or use any integrated solution for all or some of the above. It would be nice if it supported LDAP / OAuth 2.0 , integrate with plain vanill

Re: issue/bug management, project management, people management, product management all in one, preferably open source software ?

On 5/22/25 20:04, Adrian Klaver wrote: On 5/22/25 10:52, Achilleas Mantzios wrote: Hi people I'd like to know if people here know of or use any integrated solution for all or some of the above. It would be nice if it supported LDAP / OAuth 2.0 , integrate with plain vanilla git

Re: issue/bug management, project management, people management, product management all in one, preferably open source software ?

e take) VS complexity of usage (we give). Thing is , I do a lot of things , lots of roles, but project mgmt is a must, so someone , somewhere must bite the bullet sooner or later. I will definitely consider this JIRA ! On Thu, May 22, 2025 at 10:52 AM Achilleas Mantzios wrote: Hi peo

issue/bug management, project management, people management, product management all in one, preferably open source software ?

Hi people I'd like to know if people here know of or use any integrated solution for all or some of the above. It would be nice if it supported LDAP / OAuth 2.0 , integrate with plain vanilla git (not github / gitlab) and be open, and active as a project. We are at a phase our business is ex

Re: Logical replication, need to reclaim big disk space

Στις 20/5/25 12:17, ο/η Moreno Andreo έγραψε: On 19/05/25 20:49, Achilleas Mantzios wrote: On 19/5/25 17:38, Moreno Andreo wrote: On 19/05/25 14:41, Achilleas Mantzios wrote: On 5/19/25 09:14, Moreno Andreo wrote: On 16/05/25 21:33, Achilleas Mantzios wrote: On 16/5/25 18:45

Re: Logical replication, need to reclaim big disk space

On 19/5/25 17:38, Moreno Andreo wrote: On 19/05/25 14:41, Achilleas Mantzios wrote: On 5/19/25 09:14, Moreno Andreo wrote: On 16/05/25 21:33, Achilleas Mantzios wrote: On 16/5/25 18:45, Moreno Andreo wrote: Hi,     we are moving our old binary data approach, moving them from bytea

Re: Logical replication, need to reclaim big disk space

On 5/19/25 09:14, Moreno Andreo wrote: On 16/05/25 21:33, Achilleas Mantzios wrote: On 16/5/25 18:45, Moreno Andreo wrote: Hi,     we are moving our old binary data approach, moving them from bytea fields in a table to external storage (making database smaller and related operations

Re: Logical replication, need to reclaim big disk space

On 16/5/25 18:45, Moreno Andreo wrote: Hi,     we are moving our old binary data approach, moving them from bytea fields in a table to external storage (making database smaller and related operations faster and smarter). In short, we have a job that runs in background and copies data from the

Re: How to have a smooth migration

On 5/15/25 07:09, veem v wrote: Hi, Its postgres database behind the scenes. We have a use case in which the customer is planning to migrate data from an older version (V1) to a newer version (V2). For V2, the tables will be new, but their structure will be similar to the V1 version with fe

Re: Postgresql 18beta1 and SPI changes

On 12/5/25 15:50, Achilleas Mantzios wrote: Dear All, Dear Tom On 5/11/25 16:20, Tom Lane wrote: Achilleas Mantzios writes: We use are own version of DBmirror, we run our replication in a highly fine grained manner. So every upgrade I have to make the code compile and test. Up to

Re: Postgresql 18beta1 and SPI changes

Dear All, Dear Tom On 5/11/25 16:20, Tom Lane wrote: Achilleas Mantzios writes: We use are own version of DBmirror, we run our replication in a highly fine grained manner. So every upgrade I have to make the code compile and test. Up to PostgreSQL 17, I only got minor compilation problems

Postgresql 18beta1 and SPI changes

Dear members We use are own version of DBmirror, we run our replication in a highly fine grained manner. So every upgrade I have to make the code compile and test. Up to PostgreSQL 17, I only got minor compilation problems that I managed to resolve fairly easily. However this didn't prove to b

Re: Soundness of strategy for detecting locks acquired by DDL statements

On 6/5/25 12:06, Agis Anastasopoulos wrote: Hello! I'd like to "preflight" a given schema migration (i.e. one or more DDL statements) before applying it to the production database (e.g. for use in a CI pipeline). I'm thinking of a strategy and would like to know about its soundness. The gene

Re: Different execution plans in PG17 and pgBouncer...

-- *From:* Mladen Marinović *Sent:* Monday, May 5, 2025 12:27 PM *To:* Achilleas Mantzios *Cc:* pgsql-general@lists.postgresql.org *Subject:* Re: Different execution plans in PG17 and p

Re: Different execution plans in PG17 and pgBouncer...

On 5/5/25 13:27, Mladen Marinović wrote: On Mon, May 5, 2025 at 12:07 PM Achilleas Mantzios wrote: On 5/5/25 11:00, Mladen Marinović wrote: On Mon, May 5, 2025 at 11:24 AM Achilleas Mantzios wrote: On 5/5/25 09:52, Mladen Marinović wrote: Hi

Re: Different execution plans in PG17 and pgBouncer...

affect the plan. He could find if any GUC are set for the particular user : select * from pg_db_role_setting where setrole = to_regrole(''); Regards, *Rúben Morais* On Mon, May 5, 2025 at 11:07 AM Achilleas Mantzios wrote: On 5/5/25 11:00, Mladen Marinović wrote: On

Re: Different execution plans in PG17 and pgBouncer...

On 5/5/25 11:00, Mladen Marinović wrote: On Mon, May 5, 2025 at 11:24 AM Achilleas Mantzios wrote: On 5/5/25 09:52, Mladen Marinović wrote: Hi, We recently migrated our production instances from PG11 to PG17. While doing so we upgraded our pgBouncer instances from 1.12

Re: Different execution plans in PG17 and pgBouncer...

On 5/5/25 09:52, Mladen Marinović wrote: Hi, We recently migrated our production instances from PG11 to PG17. While doing so we upgraded our pgBouncer instances from 1.12 to 1.24. As everything worked on the test servers we pushed this to production a few weeks ago. We did not notice any pro

Re: replication

On 4/25/25 14:50, Marc Millas wrote: Hello, One of my customers tells me he did a replication with the master on a debian 10 and the slave on a debian 12, both with a pg13.20, one on a pgdg110+1, the other a pgdg120.1 is this a good idea ??? (I don't think so...) Sorry I dont quite get t

Re: Clarification on RLS policy

On 4/25/25 14:01, Vydehi Ganti wrote: This is my Scenario: CREATE OR REPLACE FUNCTION one.get_country( powner name, ptable_name name)     RETURNS character varying LANGUAGE 'plpgsql'     COST 100     STABLE PARALLEL UNSAFE AS $BODY$ DECLARE     lOSUser         varchar(4000) := UPPER(SUBSTR

Re: Clarification on RLS policy

On 4/25/25 08:08, Vydehi Ganti wrote: Hi Team, We are presently using Postgresql:PostgreSQL 15.12 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-23), 64-bit I have a scenario where 1.I need to enforce RLS policy on a table for Select by calling a Function 2.The f

Re: Best Tool for PostgreSQL Auditing and Storing Audit Logs Separately

care about COMMIT and ROLLBACK statements. In my experience auditors care a lot about a statement that happened versus a statement that didn't happen. On Wed, Apr 16, 2025 at 1:35 PM Achilleas Mantzios wrote: On 16/4/25 15:36, Ron Johnson wrote: pgaudit is statement-level, not trans

Re: Best Tool for PostgreSQL Auditing and Storing Audit Logs Separately

On 16/4/25 15:36, Ron Johnson wrote: pgaudit is statement-level, not transaction-level; that's its nature.  This is the same as log_statement. ok, but log_statement prints ROLLBACKs/COMMITs, but pgaudit not. On Wed, Apr 16, 2025 at 5:10 AM Achilleas Mantzios - cloud wrote: On

Re: Best Tool for PostgreSQL Auditing and Storing Audit Logs Separately

On 4/15/25 12:14, KENAN ÇİFTÇİ wrote: Hi, You can use pgaudit and pgauditlogtofile extension (https://github.com/fmbiete/pgauditlogtofile) together to write audit logs in a separate file. One issue we have with pgaudit is that it prints AUDIT records even if the xaction gets rollbacked, how

Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm

*From:* Achilleas Mantzios *Sent:* Friday, April 11, 2025 00:17 *To:* pcr...@yahoo.com *Cc:* pgsql-general@lists.postgresql.org *Subject:* Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm Hi Brent how do you

Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm

Hi Brent how do you plan to cope with future upgrades based on logical replication ? Do you run timescale on a dedicated/separate system from the rest of your PostgreSQL cluster(s)? On 10/4/25 08:25, Amitabh Kant wrote: On Wed, Apr 9, 2025 at 11:50 AM Achilleas Mantzios - cloud wrote

Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm

On 4/9/25 04:50, Amitabh Kant wrote: Thank you, I meant the paid/supported service not the community version. Which of the two do you use? I use the community version. On 4/9/25 05:23, Brent Wood wrote: I also use the free community edition on internal servers, but under Ubuntu.

Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm

On 8/4/25 20:37, Amitabh Kant wrote: On Tue, Apr 8, 2025 at 9:40 PM Achilleas Mantzios - cloud wrote: Hi timescaledb seemed mature, but also exotic, allow me the term. No way to use native logical replication, shortage of options to run on premise or self hosted

timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm

Hi in continuation of "Ideas about presenting data coming from sensors" https://www.postgresql.org/message-id/flat/8d2dd92a-da16-435b-a38e-fe72191fc9d1%40cloud.gatewaynet.com we got the system working in single tables fashion (3 kinds of them), since no timeseries solution seemed to fit 100% al

Re: ERROR: could not read block 0 in file when creating an index out of a function

On 3/12/25 14:31, Luca Ferrari wrote: On Wed, Mar 12, 2025 at 12:54 PM Artur Zakirov wrote: I can reproduce this with the table `t` on PG 15.10. I didn't mention I'm running 16.6, but I'm pretty sure it is reproducible on other versions too. In your case `base/357283/365810` file is a new in

Re: exclusion constraint question

On 3/11/25 00:28, Rhys A.D. Stewart wrote: Greetings, I think I got it : ALTER TABLE shelves ADD CONSTRAINT shelves_excl EXCLUDE USING gist( array_remove((ARRAY[l_mug_id,c_mug_id,r_mug_id]::int[]),NULL) WITH && ); but the caveat is I had to cast to 32-bit int array. Haven't found any opcla

Re: exclusion constraint question

On 3/10/25 10:43, Achilleas Mantzios - cloud wrote: On 3/8/25 21:01, Rhys A.D. Stewart wrote: Greetings All, I have the following table: CREATE TABLE shelves( shelf_id bigint PRIMARY KEY, l_mug_id bigint UNIQUE, c_mug_id bigint UNIQUE, r_mug_id bigint UNIQUE, CHECK

Re: exclusion constraint question

On 3/8/25 21:01, Rhys A.D. Stewart wrote: Greetings All, I have the following table: CREATE TABLE shelves( shelf_id bigint PRIMARY KEY, l_mug_id bigint UNIQUE, c_mug_id bigint UNIQUE, r_mug_id bigint UNIQUE, CHECK (l_mug_id <> c_mug_id AND l_mug_id <> r_mug_id AND c_mu

Re: No. Of wal files generated

On 3/7/25 17:59, Atul Kumar wrote: Hi, Please could you help me by sharing any redhat linux command through which I can count the no. of wal files and no. of ".ready" files generated in last 10 minutes. Do you have wal archiving enabled? If yes, then simply go to the archive dir and suit y

Re: Quesion about querying distributed databases

On 3/5/25 11:55, Laurenz Albe wrote: On Wed, 2025-03-05 at 12:57 +0330, me nefcanto wrote: Right now this data is in MariaDB, on separate databases (schema) but on one server. The solution in this situation is to have a cross-database query. (this is the status quo of our application) Now our

Re: Ideas about presenting data coming from sensors

On 2/27/25 09:05, Achilleas Mantzios - cloud wrote: On 2/26/25 18:29, Adrian Klaver wrote: On 2/26/25 01:27, Achilleas Mantzios - cloud wrote: Hi Again Up to this day we have set the data acquisition system running for just one ship and writing the code to display the data. For less than

Re: Ideas about presenting data coming from sensors

On 2/26/25 18:29, Adrian Klaver wrote: On 2/26/25 01:27, Achilleas Mantzios - cloud wrote: Hi Again Up to this day we have set the data acquisition system running for just one ship and writing the code to display the data. For less than 20 days we have 6M rows. I gave a shot to timescale

Re: Ideas about presenting data coming from sensors

. So this is serious decision, so ppl please share your stories with timescale . On 2/14/25 12:46, Achilleas Mantzios - cloud wrote: On 2/14/25 11:34, Allan Kamau wrote: On Thu, Feb 13, 2025 at 9:44 PM Thiemo Kellner wrote: 13.02.2025 10:54:05 Achilleas Mantzios - cloud

Re: Ideas about presenting data coming from sensors

On 2/13/25 20:44, Thiemo Kellner wrote: 13.02.2025 10:54:05 Achilleas Mantzios - cloud : If we followed a strict normalized approach then we would create additionally 11 tables each tag of type c) . And we are not guaranteed that the same tags would have the same structure over the whole

Re: Ideas about presenting data coming from sensors

On 2/14/25 11:34, Allan Kamau wrote: On Thu, Feb 13, 2025 at 9:44 PM Thiemo Kellner wrote: 13.02.2025 10:54:05 Achilleas Mantzios - cloud : > If we followed a strict normalized approach then we would create additionally 11 tables each tag of type c) . And we are

Re: Ideas about presenting data coming from sensors

On 2/13/25 19:12, Adrian Klaver wrote: On 2/13/25 01:53, Achilleas Mantzios - cloud wrote: Now my problem is on the design . We have : a) tags that have primitive values, float4 lets say - this is the majority, e.g. 60% of all tags b) tags that contain alarms data also with defined

Re: Ideas about presenting data coming from sensors

On 1/30/25 18:45, Adrian Klaver wrote: On 1/30/25 06:18, Achilleas Mantzios - cloud wrote: Dear PostgreSQL people We have a project having to do with capturing sensor data and alarms from various machinery using various protocols/standards (e.g. NMEA , MODBUS). We have about 150 sites

Ideas about presenting data coming from sensors

Dear PostgreSQL people We have a project having to do with capturing sensor data and alarms from various machinery using various protocols/standards (e.g. NMEA , MODBUS). We have about 150 sites (vessels of various types) and each site will generate about 500 rows per minute. We have solved mo

Re: Clusters and shared permissions using LDAP

On 12/10/24 17:59, Felipe Matas wrote: Hi all! I'm trying to build three postgres clusters (in different servers), I'm thinking to use CITUS to make the data available across the clusters, I'm checking the docs. What I have not been able to found in any place, is how to handle the permission

Re: Seamless age (xid) replacement

On 12/4/24 17:51, Ivan Shershnev wrote: Hello! I need to use the 'age (xid)' function, but I have noticed that it is deprecated without a clear alternative. I know that xid is also kinda deprecated, so it makes sense not to use it. I can get xid8 from 'pg_current_xact_id()', which replaced

Re: CVE-2024-10979 Vulnerability Impact on PostgreSQL 11.10

On 11/22/24 10:00, Matthias Apitz wrote: El día viernes, noviembre 22, 2024 a las 05:52:34 +0100, Laurenz Albe escribió: On Fri, 2024-11-22 at 10:01 +0530, Subhash Udata wrote: Currently, my environment is running PostgreSQL 15.0. I understand that version 15.9 contains the fix for CVE-2024-

Re: Suddenly all queries moved to seq scan

On 11/20/24 12:50, Sreejith P wrote: Hi, We are using PostgresQL 10 in our production database. We have around 890 req /s request on peak time. We have 1 primary and 4 slave databases as well in the same postgres cluster. 2 days back we applied some patches in the primary server and rest

Re: Getting error 42P02, despite query parameter being sent

Στις 16/11/24 18:09, ο/η Adrian Klaver έγραψε: On 11/16/24 03:15, Achilleas Mantzios wrote: Στις 16/11/24 12:55, ο/η Max Ulidtko έγραψε: Greetings, group! I'm trying to understand a low-level issue. Am evaluating a new client library for Postgres; it's not particular

Re: Getting error 42P02, despite query parameter being sent

Στις 16/11/24 12:55, ο/η Max Ulidtko έγραψε: Greetings, group! I'm trying to understand a low-level issue. Am evaluating a new client library for Postgres; it's not particularly popular / mainstream, and as I've understood so far, sports an independent implementation of PG binary protocol.

Re: Fwd: A million users

On 11/13/24 12:29, Alvaro Herrera wrote: On 2024-Nov-13, Vijaykumar Jain wrote: I tried to grant select permissions to 5000 different roles on one table, It failed with row size too big already at 2443. But you can grant select to one "reader" role, and grant that one role to however many ot

Re: Duplicate key error

On 11/11/24 07:40, yudhi s wrote: We have a merge query as below for a partition table which is range partitioned on a truncated date column 'part_date'. And the only unique key in this table is a composite primary key on (id, part_date). And this merge queries ON condition is based on one of

Re: Can we directly upgrade postgresql from 13 to 15.4

Στις 8/11/24 20:16, ο/η Christophe Pettus έγραψε: On Nov 8, 2024, at 10:12, jayesh thakare wrote: Can we upgrade postresql from 13 to 15.4 directly? Can we upgrade postgresql from 13 to 16 directly? Yes. Ideally how many major version can we jump to from older version ? There's no practi

Re: Plans for partitioning of inheriting tables

On 10/24/24 21:58, David G. Johnston wrote: On Thursday, October 24, 2024, wrote: Up to version 17, partitioning of tables inheriting from other tables is not possible. psql:../code_files/data_storage/PostgreSQL/tables/TOPO_FILES.pg_sql:68: ERROR:  no se puede crear u

Re: Regression in Postgres 17?

Στις 22/10/24 18:54, ο/η Colin 't Hart έγραψε: Hi, This works in Postgres 15: pg15> create function json_test(out value text, out json jsonb) returns record language sql as $$   select null::text, null::jsonb; $$ ; CREATE FUNCTION pg15> select * from json_test(); ┌───┬──┐ │ value │ jso

Re: Backup

Στις 16/10/24 23:02, ο/η Ron Johnson έγραψε: On Wed, Oct 16, 2024 at 4:00 PM Achilleas Mantzios wrote: Στις 16/10/24 22:55, ο/η Ron Johnson έγραψε: On Wed, Oct 16, 2024 at 3:37 PM Andy Hartman wrote: I am very new to Postgres and have always worked in the mssql

Re: Backup

Στις 16/10/24 22:55, ο/η Ron Johnson έγραψε: On Wed, Oct 16, 2024 at 3:37 PM Andy Hartman wrote: I am very new to Postgres and have always worked in the mssql world. I'm looking for suggestions on DB backups. I currently have a DB used to store Historical information that has imag

Re: What are best practices wrt passwords?

Στις 16/10/24 19:47, ο/η Tom Lane έγραψε: Bruce Momjian writes: On Wed, Oct 16, 2024 at 06:16:57PM +0200, mb...@mbork.pl wrote: `ps auxe` shows all processes with their environments, no? I think that only shows for super-user. I believe it depends on your platform --- some BSDen are pretty

Re: Strange permission effect depending on DEFERRABILITY

Στις 10/9/24 20:22, ο/η Laurenz Albe έγραψε: On Tue, 2024-09-10 at 12:20 +0300, Achilleas Mantzios - cloud wrote: On 9/10/24 00:09, Laurenz Albe wrote: On Mon, 2024-09-09 at 16:14 +0300, Achilleas Mantzios - cloud wrote: The below runs on PostgreSQL 16.4 We are trying to implement a certain

Re: Strange permission effect depending on DEFERRABILITY

On 9/10/24 00:09, Laurenz Albe wrote: On Mon, 2024-09-09 at 16:14 +0300, Achilleas Mantzios - cloud wrote: The below runs on PostgreSQL 16.4 We are trying to implement a certain operation based on a security definer function : mariner_update_availability_date This is supposed to update a

Re: postgresql FDW vs dblink for DDL

Στις 9/9/24 18:40, ο/η Tom Lane έγραψε: Adrian Klaver writes: On 9/9/24 03:24, Achilleas Mantzios - cloud wrote: And the thing is that this creation via DDL is inside our design. Certain users create some backup tables of the public data in their own schema (via our app), then do some

Re: Strange permission effect depending on DEFERRABILITY

On 9/9/24 17:21, Tom Lane wrote: Achilleas Mantzios - cloud writes: As you noticed the last trigger is a CONSTRAINT DEFERRABLE trigger. This function mariner_update_availability_date is supposed to be run by a user : cbt_results_import strippedof any privileges to the rest of the system. Here

Re: ssh to DB server and su normal users very slow :

On 9/9/24 16:18, KK CHN wrote: update :  the      ssh -v root@db_Server_IP from my Windows cmd   pasted below for more details Why is your windows cmd important here, show ssh debugging from your DB host to the pgbackrest host. On Mon, Sep 9, 2024 at 4:50 PM KK CHN wrote: List,

Strange permission effect depending on DEFERRABILITY

Dear List The below runs on PostgreSQL 16.4 We are trying to implement a certain operation based on a security definer function : mariner_update_availability_date This is supposed to update a table : mariner , which has several other triggers : mariner_build_natural_id_tg BEFORE INSERT OR

Re: postgresql FDW vs dblink for DDL

On 9/8/24 23:46, Adrian Klaver wrote: On 9/8/24 13:04, Achilleas Mantzios wrote: Hi for remote DDL execution (such as CREATE TABLE) is dblink my only option? You will need to define in what context you are considering options. For instance you can do remote DDL operations by passing a

postgresql FDW vs dblink for DDL

Hi for remote DDL execution (such as CREATE TABLE) is dblink my only option? thanks

Re: PostgreSQL Active-Active Clustering

nt rows on the same data page. -- Achilleas Mantzios IT DEV - HEAD IT DEPT Dynacom Tankers Mgmt (as agents only)

Re: Can a long running procedure detect when smart shutdown is pending?

Στις 6/7/24 09:22, ο/η Pavel Stehule έγραψε: so 6. 7. 2024 v 8:19 odesílatel Pavel Stehule napsal: so 6. 7. 2024 v 8:06 odesílatel Achilleas Mantzios napsal: Στις 6/7/24 08:39, ο/η Pavel Stehule έγραψε: so 6. 7. 2024 v 1:36 odesílatel Dennis White

Re: Can a long running procedure detect when smart shutdown is pending?

own try to cancel any query. The plpgsql routine should be canceled without problems. fast mode will have this effect. smart mode not, from my testing. The running queries do not get interrupted in smart shutdown. Thanks On Fri, Jul 5, 2024 at 4:57 PM Achilleas Mantzios wrote:

Re: Can a long running procedure detect when smart shutdown is pending?

il against the log and then implement some logic using NOTIFY , ideally you want your procedure to be interrupted rather than do polling. Thanks, Dennis -- Achilleas Mantzios IT DEV - HEAD IT DEPT Dynacom Tankers Mgmt (as agents only)

Re: Description field for tables and views

not sure how to populate it. am using PostgreSQL 13.xx in Debian. In addition to the COMMENT advised by PostgreSQL friends above, you might put your schema into some version control system, such as git, so you can have all the info : why something was added/changed, by whom, what for, etc.

Re: Autovacuum, dead tuples and bloat

with my verification? Thanks in advance & Best regards, Manuel -- Achilleas Mantzios IT DEV - HEAD IT DEPT Dynacom Tankers Mgmt (as agents only)

Re: Help. The database was created using collation version 2.17, but the operating system provides version 2.34.

hi On 6/20/24 10:23, Dmitry O Litvintsev wrote: Hello, I am in the process of migrating DB to Alma9 host. The databse is rather large - few TBs. I have run pg_basebackup on Alma9 host and established replication from production to it. The idea is to quickly switch from master to this new host

Re: Is a VACUUM or ANALYZE necessary after logical replication?

ce part would be nice to be handled in a more elegant manner, e.g. by an option in pg_dump to dump only sequences, for "nearly zero" downtime upgrades, this step should happen rapidly at the switchover. Regards, Koen De Groote -- Achilleas Mantzios IT DEV - HEAD IT DEPT Dynacom Tankers Mgmt (as agents only)

Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ?

Στις 7/3/24 21:29, ο/η Adrian Klaver έγραψε: On 3/7/24 10:13, Achilleas Mantzios wrote: Στις 7/3/24 18:44, ο/η Robert Treat έγραψε: I am not talking for fun. I am talking about the future programmers of this world. Teaching Python or C to them upon arrival to the classes seems so wrong in

Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ?

Στις 7/3/24 18:44, ο/η Robert Treat έγραψε: On Thu, Mar 7, 2024 at 11:26 AM Pavel Stehule wrote: čt 7. 3. 2024 v 16:59 odesílatel Christophe Pettus napsal: On Mar 7, 2024, at 06:56, Achilleas Mantzios - cloud wrote: So, I ask, have there been any efforts to bring PL/PGSQL to the terminal

Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ?

Στις 7/3/24 18:25, ο/η Pavel Stehule έγραψε: čt 7. 3. 2024 v 16:59 odesílatel Christophe Pettus napsal: > On Mar 7, 2024, at 06:56, Achilleas Mantzios - cloud wrote: > So, I ask, have there been any efforts to bring PL/PGSQL to the terminal? Strictly speaki

Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ?

Στις 7/3/24 17:13, ο/η Karsten Hilbert έγραψε: Am Thu, Mar 07, 2024 at 04:56:18PM +0200 schrieb Achilleas Mantzios - cloud: Python IMHO is too advanced, too rich, Python _is_ powerful but it needn't be difficult. weird indentation rules A matter of taste IMO. no simple for loop R

pl/pgsql outside the DB, (i.e. on the terminal) possible ?

Hello I notice both my kids struggling with either C or Python as first programming languages. I believe both are unsuitable for use as introductory languages to college juniors. Python IMHO is too advanced, too rich, weird indentation rules, no simple for loop etc. C, ok, punishing little

Re: postgresql custom variable in pg_settings table

On 1/9/24 09:38, Yi Sun wrote: 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

Re: Removing oids with pg_repack

Στις 27/11/23 16:51, ο/η CG έγραψε: On Wednesday, November 22, 2023 at 12:38:54 PM EST, Achilleas Mantzios wrote: Στις 22/11/23 15:14, ο/η CG έγραψε: On Wednesday, November 22, 2023 at 01:20:18 AM EST, Achilleas Mantzios <mailto:a.mantz...@cloud.gatewaynet.com> wrote: Στις

Re: Removing oids with pg_repack

Στις 22/11/23 15:14, ο/η CG έγραψε: On Wednesday, November 22, 2023 at 01:20:18 AM EST, Achilleas Mantzios wrote: Στις 21/11/23 20:41, ο/η CG έγραψε: I have a very large PostgreSQL 9.5 database that still has very large tables with oids. I'm trying to get rid of the oids with as l

Re: Removing oids with pg_repack

or a 2TB table conversion) : https://www.percona.com/blog/performing-etl-using-inheritance-in-postgresql/ CG -- Achilleas Mantzios IT DEV - HEAD IT DEPT Dynacom Tankers Mgmt

Re: pgBackRest on old installation

file, but if you give password on the command line or env variable then you give this info to all users in the system. On Mon, Nov 20, 2023 at 4:16 PM Achilleas Mantzios - cloud wrote: On 11/20/23 12:31, KK CHN wrote: list, I am trying pgBackRest on an RHEL 7.6 and old EDB

Re: pgBackRest on old installation

On 11/20/23 12:31, KK CHN wrote: list, I am trying pgBackRest on an RHEL 7.6 and old EDB 10 database cluster( a legacy application.) I have installed pgbackrest through  package install on RHEL7.6 But unable to get the basic stanza-creation working It throws an error. * /etc/pgbackrest.con

Re: Getting most records possibly from an Inner/Left Join

the community can understand and refrain from giving external links for downloading files. Many people won't click on your URL or hit the download button. ... -- Achilleas Mantzios IT DEV - HEAD IT DEPT Dynacom Tankers Mgmt

Re: PostgreSQL inheritance vs https://wiki.postgresql.org/wiki/Don%27t_Do_This

as well, I have to say. PostgreSQL was presented as catching up MySQL in terms of usage/growth. In some future similar events I'd love to prepare a better and more current presentation for the local Greek community! Στις 23/10/23 14:45, ο/η Achilleas Mantzios - cloud έγραψε: Hello All i

Re: PostgreSQL inheritance vs https://wiki.postgresql.org/wiki/Don%27t_Do_This

Στις 23/10/23 19:58, ο/η Achilleas Mantzios έγραψε: Στις 23/10/23 19:54, ο/η Alvaro Herrera έγραψε: On 2023-Oct-23, Achilleas Mantzios wrote: I find PostgreSQL inheritance a great feature. The caveats are the same since a long time, nothing changed in that regard, but as you say, the

Re: PostgreSQL inheritance vs https://wiki.postgresql.org/wiki/Don%27t_Do_This

Στις 23/10/23 20:06, ο/η Laurenz Albe έγραψε: On Mon, 2023-10-23 at 19:49 +0300, Achilleas Mantzios wrote: Tom Lane wrote:  But there are valid use-cases where you actually do want more columns in the child tables than the parent. also data departmentalization, consolidation, multi-tenancy

Re: PostgreSQL inheritance vs https://wiki.postgresql.org/wiki/Don%27t_Do_This

Στις 23/10/23 19:54, ο/η Alvaro Herrera έγραψε: On 2023-Oct-23, Achilleas Mantzios wrote: I find PostgreSQL inheritance a great feature. The caveats are the same since a long time, nothing changed in that regard, but as you say, the implementation/limitations exist in native table partitioning

Re: PostgreSQL inheritance vs https://wiki.postgresql.org/wiki/Don%27t_Do_This

Στις 23/10/23 17:07, ο/η Christophe Pettus έγραψε: On Oct 23, 2023, at 04:45, Achilleas Mantzios - cloud wrote: I believe this text is false on too many accounts. So, what's the consensus about Inheritance in PostgreSQL, I am going to give a talk on it in November and I wouldn'

Re: PostgreSQL inheritance vs https://wiki.postgresql.org/wiki/Don%27t_Do_This

Στις 23/10/23 17:01, ο/η Alvaro Herrera έγραψε: On 2023-Oct-23, Achilleas Mantzios - cloud wrote: I believe this text is false on too many accounts. So, what's the consensus about Inheritance in PostgreSQL, I am going to give a talk on it in November and I wouldn't like to adverti

Re: PostgreSQL inheritance vs https://wiki.postgresql.org/wiki/Don%27t_Do_This

Στις 23/10/23 17:35, ο/η Tom Lane έγραψε: Achilleas Mantzios - cloud writes: someone added this section about inheritance : Don't use table inheritance That's one person's opinion. (Well, they're not alone in it, but it's just an opinion not a considered communi

PostgreSQL inheritance vs https://wiki.postgresql.org/wiki/Don%27t_Do_This

Hello All in the wiki above and specifically in this commit : https://wiki.postgresql.org/index.php?title=Don%27t_Do_This&type=revision&diff=33210&oldid=33082 someone added this section about inheritance : " Don't use table inheritance Don't use table inheritance

Re: Presentation tools used ?

Thank you All people!

Re: Presentation tools used ?

Στις 22/10/23 10:06, ο/η Matthias Apitz έγραψε: El día domingo, octubre 22, 2023 a las 08:50:10a. m. +0300, Achilleas Mantzios escribió: Hello All I am going to give a talk about PostgerSQL, so I'd like to ask you people what do you use for your presentations, also I have no idea ho

  1   2   3   >