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

Presentation tools used ?

s and libreoffice Impress.  What tools would you suggest ? What's your setup ? Thank you! Achilleas Mantzios IT DEV - HEAD IT DEPT Dynacom Tankers Mgmt

Re: pg_basebackup / recovery

Στις 13/4/23 01:31, ο/η Michael Paquier έγραψε: On Wed, Apr 12, 2023 at 01:45:56PM +0300, Achilleas Mantzios - cloud wrote: On 4/12/23 12:32, Fabrice Chapuis wrote: During recovery process of a self contained backup, how postgres know to stop reading wal when consistency is reached? Because

Re: pg_basebackup / recovery

On 4/12/23 12:32, Fabrice Chapuis wrote: During recovery process of a self contained backup, how postgres know to stop reading wal when consistency is reached? Because it knows the full packup info. It will observe the STOP WAL LOCATION: 3BC7/4B000130 (file 00023BC7004B) inside

Re: Guidance on INSERT RETURNING order

lect i.id from i order by id; +1 for this version! Sorry for the long email, Thanks Federico -- Achilleas Mantzios IT DEV - HEAD IT DEPT Dynacom Tankers Mgmt

Re: doc sql-grant.html Synopsis error?

EMA twice ? -- Achilleas Mantzios IT DEV - HEAD IT DEPT Dynacom Tankers Mgmt

Re: PostgreSQL vs MariaDB

On 3/28/23 06:44, Thomas Guyot wrote: On 2023-03-24 07:07, Inzamam Shafiq wrote: Hi Team, Hope you are doing well. Can someone please list pros and cons of MariaDB vs PostgreSQL that actually needs serious consideration while choosing the right database for large OLTP DBs (Terabytes)?

Re: PostgreSQL vs MariaDB

some commercial DBs lack. Thanks. Regards, /Inzamam Shafiq/ /Sr. DBA/ -- Achilleas Mantzios IT DEV - HEAD IT DEPT Dynacom Tankers Mgmt

Re: pgsql 10.19 : "ERROR: cannot convert infinity to numeric" except there is no infinity

On 19/7/22 20:32, Adrian Klaver wrote: On 7/19/22 10:26 AM, Achilleas Mantzios wrote: Thank you Adrian! Actually thank: https://sqlformat.darold.net/ Στις 19/7/22 18:36, ο/η Adrian Klaver έγραψε: On 7/19/22 03:38, Achilleas Mantzios wrote: I reformatted queries to see thing better

Re: pgsql 10.19 : "ERROR: cannot convert infinity to numeric" except there is no infinity

On 19/7/22 20:31, David G. Johnston wrote: On Tuesday, July 19, 2022, Achilleas Mantzios wrote: Thanks David Στις 19/7/22 17:19, ο/η David G. Johnston έγραψε: On Tuesday, July 19, 2022, Achilleas Mantzios wrote: ERROR:  cannot convert infinity to numeric

Re: pgsql 10.19 : "ERROR: cannot convert infinity to numeric" except there is no infinity

Thank you Adrian! Στις 19/7/22 18:36, ο/η Adrian Klaver έγραψε: On 7/19/22 03:38, Achilleas Mantzios wrote: I reformatted queries to see thing better. -- still has problem testing the range select it.id ,cept.value::numeric as val, numrange(ceptl.min_alarm::numeric,ceptl.max_alarm

Re: pgsql 10.19 : "ERROR: cannot convert infinity to numeric" except there is no infinity

Στις 19/7/22 17:23, ο/η Tom Lane έγραψε: "David G. Johnston" writes: On Tuesday, July 19, 2022, Achilleas Mantzios wrote: ERROR: cannot convert infinity to numeric The column cept.value contains an infinity. I see nothing unusual in any of these queries given that fact. If

Re: pgsql 10.19 : "ERROR: cannot convert infinity to numeric" except there is no infinity

Thanks David Στις 19/7/22 17:19, ο/η David G. Johnston έγραψε: On Tuesday, July 19, 2022, Achilleas Mantzios wrote: ERROR:  cannot convert infinity to numeric -- has no problem testing against infinity select it.id <http://it.id> ,cept.value::numeric as val, nu

pgsql 10.19 : "ERROR: cannot convert infinity to numeric" except there is no infinity

s it, cept_report cept , dynacom.vessels vsl, machdefs md, cept_reportli mits ceptl where it.id=cept.id AND md.defid=ceptl.defid AND it.defid=md.defid AND it.vslwhid=vsl.id AND vsl.vs lstatus='Active' and md.application = 'Critical Equipment Performance Test' AND cept.systemdate>= (now()-'1 ye ar'::interval)  ORDER BY 1) select * from bar where NOT range @> val; -- good data here -- Achilleas Mantzios DBA, Analyst, IT Lead IT DEPT Dynacom Tankers Mgmt

Re: What do you guys use for issue tracking, CI/CD and team management? any nice open source options?

On 16/4/22 6:39 π.μ., Michael Paquier wrote: On Thu, Apr 14, 2022 at 06:19:44PM +0300, Achilleas Mantzios wrote: What issue/bug tracking is PostgreSQL itself using? What continuous build system (CI/CD) is PostgreSQL itself using? Any tool that you ppl or the PostgreSQL infrastructure use that

What do you guys use for issue tracking, CI/CD and team management? any nice open source options?

/push, manages issues/projects/people ? I know I am asking a lot, any help welcome, thanks! -- Achilleas Mantzios DBA, Analyst, IT Lead IT DEPT Dynacom Tankers Mgmt

Re: Refresh ONE publication out of the Two Publications the Subscription has

Στις 4/1/22 5:47 μ.μ., ο/η Avi Weinberg έγραψε: Is it possible to specify the publication name to be refreshed in case I do not want to refresh all publications of the subscription? Something like: alter subscription subscription_name refresh publication publication_name Here is the method:

Re: Visibility of data from table inherits function

Στις 2/1/22 2:23 μ.μ., ο/η ourdiaspora έγραψε: Recipients, A table was created: CREATE TABLE exampletable ( name varchar(200) ); Table 'exampletable' _already_ contains data, e.g. 'Jane Bloggs' A new table was created with inheritance of 'exampletable': Please could someone explain why the

Re: Postgresql + containerization possible use case

Thank you Rainer, I'll have to play a little bit myself, and read some serious docs about it, in order to fully comprehend your thoughts. I'll revisit your positions I hope. On 13/12/21 5:11 μ.μ., Rainer Duffner wrote: Am 13.12.2021 um 12:41 schrieb Achilleas Mantzios

Re: Postgresql + containerization possible use case

On 13/12/21 5:55 μ.μ., Adrian Klaver wrote: On 12/13/21 03:41, Achilleas Mantzios wrote: Hi Rainer, On 13/12/21 11:50 π.μ., Rainer Duffner wrote: So Docker is NOT free? Please share your thoughts? I am a complete noob. Take a look here: https://www.docker.com/pricing Thank you Adrian

Re: Postgresql + containerization possible use case

ion of pgsql on the ships. So apps are much more frequently upgraded than the system of pgsql. I will check out rolling upgrades with kubernetes. (are we talking BDR here?) On Mon, Dec 13, 2021, 11:03 AM Achilleas Mantzios mailto:ach...@matrix.gatewaynet.com>> wrote: Hi Berto,

Re: Postgresql + containerization possible use case

Hi Berto, On 13/12/21 3:03 μ.μ., Bèrto ëd Sèra wrote: On Mon, 13 Dec 2021 at 12:41, Achilleas Mantzios mailto:ach...@matrix.gatewaynet.com>> wrote: Hmm, I don't know about that. The hardware is given (existing) and limited. You are like the 2nd person who warned about com

Re: Postgresql + containerization possible use case

Hi Rainer, On 13/12/21 11:50 π.μ., Rainer Duffner wrote: Am 10.12.2021 um 13:01 schrieb Achilleas Mantzios mailto:ach...@matrix.gatewaynet.com>>: On 10/12/21 1:24 μ.μ., o1bigtenor wrote: On Fri, Dec 10, 2021 at 3:24 AM Achilleas Mantzios mailto:ach...@matrix.gatewaynet.com&g

Re: Postgresql + containerization possible use case

ubles because of unreliable system setup in the past, that I'd hate to repeat the same (or similar) mistakes again. -- Achilleas Mantzios DBA, Analyst, IT Lead IT DEPT Dynacom Tankers Mgmt

  1   2   3   >