Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION

Hello, Belatedly, I came back to this issue in the release notes. Here's a query for correctly reporting the problem and not reporting the cases where there isn't a problem: SELECT conrelid::pg_catalog.regclass AS "constrained table", conname AS constraint, confrelid::pg_catalog.re

Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION

Alvaro Herrera writes: > I'm going to fix the query in the release notes for all past branches > now, to avoid confusing people upgrading in the future ... hopefully not > many, but I don't think it's going to be zero people. OK, thanks. regards, tom lane

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 PostgreSQL

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 that

Re: Postgresql 18beta1 and SPI changes

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 > that I managed to resolve fairly easily. However t

Re: Postgresql database terminates abruptly with too many open files error

On 2025-01-15 11:42:30 +, Sri Mrudula Attili wrote: > The max_connections =200 and max_files_per_process =1000 as you mentioned. > > So should a max_files_per_process =500 helps? > > > I could see from the number of connections to the databaseis not exceeding > 20. But still these 20 are cau

Re: Postgresql database terminates abruptly with too many open files error

-- Forwarded message - From: Sri Mrudula Attili Date: Wed, 15 Jan, 2025, 17:12 Subject: Re: Postgresql database terminates abruptly with too many open files error To: Tom Lane Cc: Hello Tom, The max_connections =200 and max_files_per_process =1000 as you mentioned. So

Re: Postgresql database terminates abruptly with too many open files error

Hello Tom, The max_connections =200 and max_files_per_process =1000 as you mentioned. So should a max_files_per_process =500 helps? I could see from the number of connections to the databaseis not exceeding 20. But still these 20 are causing all the damage or using up all the openfiles quot

Re: Postgresql database terminates abruptly with too many open files error

Sri Mrudula Attili writes: >  We have a postgresql VDB(virtual database- Delphix) that keeps > terminating due "to too many open files". What do you have max_connections set to, and how many actually-live server processes are there typically? > The number of allowed openfiles at OS level are 6

Re: Postgresql database terminates abruptly with too many open files error

On Tue, Jan 14, 2025 at 7:58 AM Sri Mrudula Attili wrote: > Hello Team, > > We have a postgresql VDB(virtual database- Delphix) that keeps > terminating due "to too many open files". > > Below are few alerts that we could see from the postgresql.log > > > < 2025-01-14 11:37:20.724 GMT >LOG: ou

Re: Postgresql database terminates abruptly with too many open files error

Hello, Have you checked something like lsof to see open file descriptors to see? Cheers, frank Am 14.01.25 um 13:58 schrieb Sri Mrudula Attili: Hello Team,  We have a postgresql VDB(virtual database- Delphix) that keeps terminating due "to too many open files". Below are few alerts that w

Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION

Hi Alvaro, > On 30 Nov 2024, at 08:41, Alvaro Herrera wrote: > > Only if you have self-referencing FKs in partitioned tables. It > would be an interesting data point to verify whether this reports > anything else. Also, I'd be really curious if your databases include > the case I'm suspicious

Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION

Hello, On 2024-Nov-29, Paul Foerster wrote: > > On 29 Nov 2024, at 18:15, Alvaro Herrera wrote: > > This reports case 2 as OK and case 1 as bogus, as should be. I tried > > adding more partitions and this seems to hold correctly. I was afraid > > though that this would fail if we create an FK

Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION

Hi Alvaro, > On 29 Nov 2024, at 18:15, Alvaro Herrera wrote: > > This all was to say that the query in the release notes is undoubtedly > wrong. After thinking some more about it, I think the fix is to add 1 > to the number of constraints: > > SELECT conrelid::pg_catalog.regclass AS "constrain

Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION

On 2024-Nov-27, Tom Lane wrote: > I doubt that there's anything actually wrong with the catalog state at > this point (perhaps Alvaro would confirm that). That leads to the > conclusion that what's wrong is the release notes' query for fingering > broken constraints, and it needs some additional

Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION

Hi Tom, hi Alvaro, > On 27 Nov 2024, at 19:52, Tom Lane wrote: > > Okay, so I was able to reproduce this from scratch on HEAD: great, thanks. > I doubt that there's anything actually wrong with the catalog state at > this point (perhaps Alvaro would confirm that). That leads to the > conclusi

Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION

On 2024-Nov-27, Tom Lane wrote: > I doubt that there's anything actually wrong with the catalog state at > this point (perhaps Alvaro would confirm that). That leads to the > conclusion that what's wrong is the release notes' query for fingering > broken constraints, and it needs some additional

Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION

Paul Foerster writes: > On 26 Nov 2024, at 22:25, Tom Lane wrote: >> I'm suspicious that our repair recipe might not have accounted >> for self-reference FKs fully, but that's just a gut feeling at >> this point. > Of course, it contains no secret data. Please find the full log below. > Accordi

Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION

Hi Tom, > On 26 Nov 2024, at 22:25, Tom Lane wrote: > > I would have expected an empty result too. Can you confirm that > p_ci_pipelines used to be a partition of something? Can you show us > the full DDL (or psql \d+ output) for the partitioned table it > used to be part of, and for that matt

Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION

Paul Foerster writes: >> On 26 Nov 2024, at 17:56, Adrian Klaver wrote: >> When you run the query again do you get the same two statements? > Yes. I can repeat the above 4 steps as much as I want. The result remains the > same. I would have expected to have an empty result doing the final repea

Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION

Hi Adrian, > On 26 Nov 2024, at 17:56, Adrian Klaver wrote: > > Did you commit the statements? Yes. I have autocommit on, the psql default. > Are you using concurrent sessions to do this? No. I do this in one session. 1. select, 2. drop, 3. add, 4. select. > When you run the query again do y

Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION

On 11/26/24 01:59, Paul Foerster wrote: Hi, I have a question regarding the recent security update for PostgreSQL 15. We have a gitlab database. It used to run on the PostgreSQL 15.8 software. I updated from 15.8 to 15.10 and executed the corrective actions as outlined in: https://www.postgre

Re: PostgreSQL Log Info

On Fri, Nov 22, 2024 at 9:26 AM Jethish Jethish wrote: > Sorry guys, what I meant was to log the tuple returned count not the > values to get printed in logs. > That too is a no. Though more because is just doesn't seem useful enough to expend effort on designing and implementing something. The

Re: PostgreSQL Log Info

On 11/21/24 21:02, Jethish Jethish wrote: Hi Everyone, Is it possible to log the rows returned by a query in the PostgreSQL logs? https://github.com/pgaudit/pgaudit/blob/main/README.md "pgaudit.log_rows Specifies that audit logging should include the number of rows retrieved or affected by

Re: PostgreSQL Log Info

Sorry guys, what I meant was to log the tuple returned count not the values to get printed in logs. On Fri, Nov 22, 2024, 9:46 PM David G. Johnston wrote: > On Fri, Nov 22, 2024 at 12:32 AM Jethish Jethish > wrote: > >> If an select query is fired I need the query returned values needs to be >>

Re: PostgreSQL Log Info

On Fri, Nov 22, 2024 at 12:32 AM Jethish Jethish wrote: > If an select query is fired I need the query returned values needs to be > logged in my PostgreSQL log file. > Then the answer is no, and unlikely to become a feature anyone would develop or that we'd accept. A more innovative solution is

Re: PostgreSQL Log Info

On 11/21/24 23:32, Jethish Jethish wrote: Hi David, If an select query is fired I need the query returned values needs to be logged in my PostgreSQL log file. For example if a select query returns 5 rows I need the same in the log file What if the query returns 500,000 rows? What is the

Re: PostgreSQL Log Info

Am Fri, Nov 22, 2024 at 01:02:27PM +0530 schrieb Jethish Jethish: > If an select query is fired I need the query returned values needs to be > logged in my PostgreSQL log file. What do you expect your log file to be in size after, say, a day of activity ? Karsten -- GPG 40BE 5B0E C98E 1713 AFA6

Re: PostgreSQL Log Info

On Fri, Nov 22, 2024 at 01:02:27PM +0530, Jethish Jethish wrote: > Hi David, > > If an select query is fired I need the query returned values needs to be > logged in my PostgreSQL log file. > > > For example if a select query returns 5 rows I need the same in the log > file Please note that you

Re: PostgreSQL Log Info

Isn't "I need the query returned values" the purpose of the client application? On Fri, Nov 22, 2024 at 2:32 AM Jethish Jethish wrote: > Hi David, > > If an select query is fired I need the query returned values needs to be > logged in my PostgreSQL log file. > > > For example if a select query

Re: PostgreSQL Log Info

Hi David, If an select query is fired I need the query returned values needs to be logged in my PostgreSQL log file. For example if a select query returns 5 rows I need the same in the log file On Fri, Nov 22, 2024, 10:49 AM David G. Johnston wrote: > On Thursday, November 21, 2024, Jethish J

Re: PostgreSQL Log Info

On Thursday, November 21, 2024, Jethish Jethish wrote: > > Is it possible to log the rows returned by a query in the PostgreSQL logs? > As a practical matter, no. That said, given one can get row contents into the server log in various ways, what is the use case for why this capability is though

Re: PostgreSQL 15.9 Update: Partitioned tables with foreign key constraints

On 11/19/24 08:11, Paul Foerster wrote: Hi, the PostgreSQL 15.9 release notes instruct to look out for especially detached partitions with foreign key constraints. I'm in the process of updating our databases from 15.8 to 15.9 now and found a case where the select statement returns a constrai

Re: PostgreSQL 15.9 Update: Partitioned tables with foreign key constraints

Hi Alvaro, > On 19 Nov 2024, at 17:34, Alvaro Herrera wrote: > > It doesn't really matter when you do it, because the constraint only > gets broken by running DETACH with the old server code. You have > already run the DETACH sometime in the past (that's how the constraint > got broken), which

Re: PostgreSQL 15.9 Update: Partitioned tables with foreign key constraints

Hi Adrian, > On 19 Nov 2024, at 17:17, Adrian Klaver wrote: > > Read this: > > https://www.postgresql.org/about/news/out-of-cycle-release-scheduled-for-november-21-2024-2958/ > > and hold off awhile. Thanks very much. I will. Cheers, Paul

Re: PostgreSQL 15.9 Update: Partitioned tables with foreign key constraints

Hi Tom, > On 19 Nov 2024, at 17:25, Tom Lane wrote: > > Generally speaking, our release notes are addressed to someone who's > already installed the update (or a later one). Thank you for the advice. Cheers, Paul

Re: PostgreSQL 15.9 Update: Partitioned tables with foreign key constraints

Hi Paul, On 2024-Nov-19, Paul Foerster wrote: > the PostgreSQL 15.9 release notes instruct to look out for especially > detached partitions with foreign key constraints. I'm in the process > of updating our databases from 15.8 to 15.9 now and found a case where > the select statement returns a co

Re: PostgreSQL 15.9 Update: Partitioned tables with foreign key constraints

Paul Foerster writes: > the PostgreSQL 15.9 release notes instruct to look out for especially > detached partitions with foreign key constraints. I'm in the process of > updating our databases from 15.8 to 15.9 now and found a case where the > select statement returns a constraint. > The relea

Re: postgresql-17.0-1 Application - silent installation Issue

On 11/14/24 01:05, JOLAPARA Urvi (SAFRAN) wrote: C2 - Confidential Hello Klaver, I have added below the log where setup is failing on FR language machine. Log started 11/14/2024 at 09:04:33 Preferred installation mode : unattended Trying to init installer in mode unattended Mode unattended suc

Re: postgresql-17.0-1 Application - silent installation Issue

l-gene...@postgresql.org > Cc: KRISHNAN LINGATHAR Karupaswamy (SAFRAN) > > Subject: Re: postgresql-17.0-1 Application - silent installation Issue > > CAUTION: This message originated from an outside organization. In case of > suspicion, click on "Report to SAFRAN Secu

RE: postgresql-17.0-1 Application - silent installation Issue

group.com -Original Message- From: Adrian Klaver Sent: Tuesday, November 12, 2024 10:06 PM To: JOLAPARA Urvi (SAFRAN) ; pgsql-gene...@postgresql.org Cc: KRISHNAN LINGATHAR Karupaswamy (SAFRAN) Subject: Re: postgresql-17.0-1 Application - silent installation Issue CAUTION: This message origin

Re: PostgreSQL logical replication

On Tue, Nov 12, 2024 at 7:47 PM Ron Johnson wrote: > The documentation tells you, down in the Notes section. > > https://www.postgresql.org/docs/16/sql-createpublication.html > Thank you.

Re: postgresql-17.0-1 Application - silent installation Issue

On 11/11/24 22:09, JOLAPARA Urvi (SAFRAN) wrote: C2 - Confidential This is a publicly readable list, the above has no meaning in that context. Hello Klaver, We are using PSADT for creating a script and installing through SCCM. 1) I don't work with Windows so I have no idea what the above

Re: PostgreSQL logical replication

The documentation tells you, down in the Notes section. https://www.postgresql.org/docs/16/sql-createpublication.html On Tue, Nov 12, 2024 at 5:46 AM Jayadevan M wrote: > Hello all, > > I am using PostgreSQL 16.4. I tried to set up logical replication with > "postgres" user and all worked fine.

RE: postgresql-17.0-1 Application - silent installation Issue

RAN) Subject: Re: postgresql-17.0-1 Application - silent installation Issue CAUTION: This message originated from an outside organization. In case of suspicion, click on "Report to SAFRAN Security" from the Outlook ribbon. On 11/10/24 07:11, JOLAPARA Urvi (SAFRAN) wrote: > C2 -

Re: postgresql-17.0-1 Application - silent installation Issue

On 11/10/24 07:11, JOLAPARA Urvi (SAFRAN) wrote: C2 - Confidential Hello Team, I am from Application Packaging team. we have created the package of PostgreSQL 17.0-1 Application. You are going to need to provide more detail on the package creation process. We have used the command line

Re: PostgreSQL Database Community Edition -- Please provide list of the supported hypervisors

On 10/21/24 04:06, Sunil Kumar wrote: Classification: *Confidential* If the rest of the list won't tell neither will I:) Hi Team, Can you please provide list of the supported hypervisors to run the PostgreSQL Database. Wouldn't the OS be the important factor? From the database's standpoi

Re: PostgreSQL Database Community Edition -- Please provide list of the supported hypervisors

On Monday, October 21, 2024, Sunil Kumar wrote: > > Can you please provide list of the supported hypervisors to run the > PostgreSQL Database. > > If you can run one of the build farm operating systems on your hypervisor you should be fine. But to the extent I do not believe any build farm member

Re: PostgreSQL Database Community Edition -- Please provide list of the supported hypervisors

I think the correct answer will be "all of them" :D maybe besides DOSBOX, etc. because there are no DOS packages. Also, I do not think you should send "Confidential" emails to public mailing lists :) Cheers, Mateusz pon., 21 paź 2024 o 13:33 Sunil Kumar napisał(a): > Classification: *Confident

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 manipula

Re: postgresql FDW vs dblink for DDL

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 manipulations on the public data, >> t

Re: postgresql FDW vs dblink for DDL

On 9/9/24 03:24, Achilleas Mantzios - cloud wrote: 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 instanc

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 com

Re: postgresql FDW vs dblink for DDL

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 command or script via psql. thanks

Re: PostgreSQL Upgrade Issue - Undefined Symbol Error

Vivek Gadge writes: > I am encountering an error after completion of PostgreSQL upgradation from > version 13.8 to 15.6. Trying to describe a single table, I am receiving an > error. > psql: symbol lookup error: psql: undefined symbol: PQmblenBounded This indicates that your psql executable is l

Re: PostgreSQL Upgrade Issue - Undefined Symbol Error

On 8/15/24 04:03, Vivek Gadge wrote: Hi All, I am encountering an error after completion of PostgreSQL upgradation from version 13.8 to 15.6. Trying to describe a single table, I am receiving an error. psql -d xyz -->> \dt student* The error message is as follows: ``` psql: symbol lookup

Re: PostgreSQL Active-Active Clustering

> On Jul 15, 2024, at 12:06, Sarkar, Subhadeep wrote: > > • Does the Community edition of PostgreSQL provide NATIVE active-active high > availability clustering with objectives of scalability, load balancing and > high availability without using any extensions or external components or > u

Re: PostgreSQL Active-Active Clustering

Στις 15/7/24 22:55, ο/η Ron Johnson έγραψε: On Mon, Jul 15, 2024 at 3:28 PM Christophe Pettus wrote: > On Jul 15, 2024, at 12:06, Sarkar, Subhadeep wrote: > [snip] >   • In the Community edition of PostgreSQL is it possible to setup  a cluster where all the nodes are ab

Re: PostgreSQL Active-Active Clustering

On Mon, Jul 15, 2024 at 5:54 PM Christoph Moench-Tegeder wrote: > ## Ron Johnson (ronljohnso...@gmail.com): > > > This "lack of products" puzzles me, because DEC was doing this with VAX > > (then Alpha and Itanium) clusters 40 years ago via a Distributed Lock > > Manager integrated deep into VMS.

Re: PostgreSQL Active-Active Clustering

## Ron Johnson (ronljohnso...@gmail.com): > This "lack of products" puzzles me, because DEC was doing this with VAX > (then Alpha and Itanium) clusters 40 years ago via a Distributed Lock > Manager integrated deep into VMS. Their Rdb and (CODASYL) DBMS products Tech and trade-offs have changed o

Re: PostgreSQL Active-Active Clustering

On Mon, Jul 15, 2024 at 3:28 PM Christophe Pettus wrote: > > > On Jul 15, 2024, at 12:06, Sarkar, Subhadeep > wrote: > > > [snip] > > • In the Community edition of PostgreSQL is it possible to setup a > cluster where all the nodes are able to concurrently read-write the > underlying database

Re: PostgreSQL Active-Active Clustering

> On Jul 15, 2024, at 12:06, Sarkar, Subhadeep wrote: > > • Does the Community edition of PostgreSQL provide NATIVE active-active > high availability clustering with objectives of scalability, load balancing > and high availability without using any extensions or external components or >

Re: PostgreSQL Active-Active Clustering

On Mon, Jul 15, 2024 at 12:06 PM Sarkar, Subhadeep wrote: > > We are evaluating features of the Community edition of PostgreSQL in > relation to a proposal for a prospective client and need help with the > queries below:- > > > >- Does the Community edition of PostgreSQL provide NATIVE >a

Re: Postgresql range_agg() Return empty list

Your update expression does not handle empty ranges properly, but convert them into complete ranges. https://dbfiddle.uk/Ia6wESpL On Thu, Jul 11, 2024 at 5:55 PM Han Tang wrote: > > Hi > > Hope you are doing well! > > I am using range_agg() function, it works fine with original table value > > Q

Re: Postgresql range_agg() Return empty list

On Wed, Jul 10, 2024 at 6:37 PM Han Tang wrote: > I am using range_agg() function, it works fine with original table value > > But when I try to do some update for range value, it will give back an empty > list > > Select range_agg(b.r) > From ( > Select int8range(lower(bin_range)+1, upper(bin_

Re: PostgreSQL Community Enquire !

On 6/25/24 12:00, madhav sira wrote: Hi Team, Just wanted to reconfirm, for any queries or discussion on postgres coding/peformance tuning related questions, I have email to ( pgsql-gene...@postgresql.org ) and discussion will continue on emails only but 

Re: Postgresql python in upgraded version 16.2

On 6/21/24 00:33, Šika Michal wrote: Hello, I get the install packages from this repository: https://download.postgresql.org/pub/repos/yum/16/redhat/rhel-8.9-ppc64le/ I would go here: https://yum.postgresql.org/contac

Re: PostgreSQL Community Enquire !

Hi On Tue, Jun 25, 2024 at 4:29 AM madhav sira wrote: > Dear PostgreSQL Community, > > > I am new to the PostgreSQL community. I am writing to seek guidance on the > best practices for engaging with the community, particularly regarding > where to post questions related to SQL queries and genera

Re: PostgreSQL Community Enquire !

On 6/24/24 16:28, madhav sira wrote: Dear PostgreSQL Community, I am new to the PostgreSQL community. I am writing to seek guidance on the best practices for engaging with the community, particularly regarding where to post questions related to SQL queries and general database issues. In o

Re: Postgresql python in upgraded version 16.2

Hello, I get the install packages from this repository: https://download.postgresql.org/pub/repos/yum/16/redhat/rhel-8.9-ppc64le/ Michal Od: Adrian Klaver Odesláno: čtvrtek 20. června 2024 17:03 Komu: Šika Michal ; pgsql-gene...@postgresql.org Předmět: Re

Re: Postgresql python in upgraded version 16.2

On 6/19/24 22:05, Šika Michal wrote: TLP:AMBER Hello all, I upgraded version of Postgres from 13.5 to newest 16.2. But Python was not upgraded. I create procedure pyver(): CREATE OR REPLACE FUNCTION pyver ()  RETURNS TEXT  AS $$      import sys      pyversion = sys.version      return p

Re: Postgresql 16.3 Out Of Memory

It looks like I did not copy the list. I did run VACUUM ANALYZE after the upgrade. I've even run it now > before getting a new explain plan that is very similar (just the costs > differ): > Gather Merge (cost=12336145.92..16111570.23 rows=31531596 width=66) >Workers Planned: 4 >-> Sort

Re: Postgresql 16.3 Out Of Memory

On Mon, Jun 3, 2024 at 9:12 AM Greg Sabino Mullane wrote: > On Mon, Jun 3, 2024 at 6:19 AM Radu Radutiu wrote: > >> Do you have any idea how to further debug the problem? >> > > Putting aside the issue of non-reclaimed memory for now, can you show us > the actual query? The explain analyze you p

Re: Postgresql 16.3 Out Of Memory

On Mon, Jun 3, 2024 at 6:19 AM Radu Radutiu wrote: > Do you have any idea how to further debug the problem? > Putting aside the issue of non-reclaimed memory for now, can you show us the actual query? The explain analyze you provided shows it doing an awful lot of joins and then returning 14+ mi

Re: Postgresql active-active nodes in cluster

On Mon, May 13, 2024 at 2:53 AM Vidyashree H S < shreevidya...@exaleapsemi.com> wrote: > >- Is that multi master replication is not recommended to do ? > > No, it is not recommended, as it has a very, very narrow use case, and comes with a lot of drawbacks. Sure, you COULD configure your car t

Re: Postgresql active-active nodes in cluster

Momjian ; Greg Sabino Mullane Cc: Kashif Zeeshan ; pgsql-general@lists.postgresql.org Subject: Re: Postgresql active-active nodes in cluster Thanks all for your inputs. * Currently I'm working on active-passive(Primary and standby scenario). * I'm preparing one study report

Re: Postgresql active-active nodes in cluster

ludes some trails on this. For that, I'm checking for the resources. Thanks Vidyashree H S From: Bruce Momjian Sent: Friday, May 10, 2024 4:53 AM To: Greg Sabino Mullane Cc: Kashif Zeeshan ; Vidyashree H S ; pgsql-general@lists.postgresql.org Subject: Re: Po

Re: Postgresql active-active nodes in cluster

On Thu, May 9, 2024 at 06:33:39PM -0400, Greg Sabino Mullane wrote: > > https://wiki.postgresql.org/wiki/Multimaster > > > That is a pretty old page. There are other solutions, such as pgedge, but the > three most important questions when it comes to active-active replication are: > > * Do

Re: Postgresql active-active nodes in cluster

> https://wiki.postgresql.org/wiki/Multimaster > That is a pretty old page. There are other solutions, such as pgedge, but the three most important questions when it comes to active-active replication are: * Do you really, really need it? (hint: the answer is no) * What problem are you trying to

Re: Postgresql active-active nodes in cluster

Hi You can use BDR, you can have a look on the following link. https://wiki.postgresql.org/wiki/Multimaster Thanks Kashif Zeeshan Bitnine Global On Thu, May 9, 2024 at 3:28 PM Vidyashree H S wrote: > Hi, > > I'm using Postgresql 15.4 version on RISCV architecture > I'm trying to implement act

Re: PostgreSQL hardening best practice

Hi Jason, CIS benchmark is a good place to that. https://www.cisecurity.org/benchmark/postgresql Regards, Flavious On Fri, Mar 29, 2024 at 5:37 PM Jason Long wrote: > Hello, > There are many articles on the internet to secure PostgreSQL, but which > one is valid and up-to-date! > > Please i

Re: PostgreSQL as advanced job queuing system

On 2024-03-25 23:44, Merlin Moncure wrote: On Mon, Mar 25, 2024 at 4:43 AM Dominique Devienne wrote: Hi. Anything you can share? OSS? Doesn't look like it... If it's not, a more details higher level architecture overview would be nice. let me float that, I would love to project-ize this.

Re: PostgreSQL as advanced job queuing system

On Mon, Mar 25, 2024 at 4:43 AM Dominique Devienne wrote: > On Sat, Mar 23, 2024 at 3:13 AM Merlin Moncure wrote: > >> On Fri, Mar 22, 2024 at 6:58 AM ushi wrote: >> >>> the idea to implement a job queuing system using PostgreSQL. >>> >> >> I wrote an enterprise scheduler, called pgtask, which

Re: PostgreSQL as advanced job queuing system

On Sat, Mar 23, 2024 at 3:13 AM Merlin Moncure wrote: > On Fri, Mar 22, 2024 at 6:58 AM ushi wrote: > >> the idea to implement a job queuing system using PostgreSQL. >> > > I wrote an enterprise scheduler, called pgtask, which ochestates a very > large amount of work [...] > Hi. Anything you ca

Re: PostgreSQL as advanced job queuing system

On Fri, Mar 22, 2024 at 6:58 AM ushi wrote: > Hello List, > > i am playing with the idea to implement a job queuing system using > PostgreSQL. To meet requirements the system needs to offer some advanced > features compared to "classic" queuing systems: > > - users can create new queues at any ti

Re: PostgreSQL as advanced job queuing system

Generally, I'd suggest you think carefully about the nature of the jobs, and draw up a list of must-have properties (performance of course, but also things like whether jobs have to survive planned or unplanned outages, be visible across a WAN, numbers of readers and writers, delivery guarantees, e

Re: PostgreSQL as advanced job queuing system

Am 22.03.2024 um 14:15 schrieb Fred Habash: We developed a home-grown queue system using Postgres, but its performance was largely hindered by que tables bloating and the need to continuously vacuum them. It did not scale whatsoever. With some workarounds, we ended up designing three sets of

Re: PostgreSQL as advanced job queuing system

We developed a home-grown queue system using Postgres, but its performance was largely hindered by que tables bloating and the need to continuously vacuum them. It did not scale whatsoever. With some workarounds, we ended up designing three sets of queue tables, switching between them based on some

Re: PostgreSQL as advanced job queuing system

On 2024-03-22 12:43:40 +0100, ushi wrote: > i am playing with the idea to implement a job queuing system using > PostgreSQL. To meet requirements the system needs to offer some advanced > features compared to "classic" queuing systems: > > - users can create new queues at any time > - queues have

Re: PostgreSQL as advanced job queuing system

On Fri, Mar 22, 2024 at 8:05 AM Dominique Devienne wrote: > > On Fri, Mar 22, 2024 at 12:58 PM ushi wrote: >> >> i am playing with the idea to implement a job queuing system using >> PostgreSQL. > > > FYI, two bookmarks I have on this subject, that I plan to revisit eventually: > * https://news.

Re: PostgreSQL as advanced job queuing system

On Fri, Mar 22, 2024 at 12:58 PM ushi wrote: > i am playing with the idea to implement a job queuing system using > PostgreSQL. FYI, two bookmarks I have on this subject, that I plan to revisit eventually: * https://news.ycombinator.com/item?id=20020501 * https://www.enterprisedb.com/blog/liste

Re: Postgresql docker health check

On 2024-03-12 15:43:13 +0100, Amna Abdul Rehman wrote: > When my application runs overnight, I receive the error message > 'FATAL: Sorry, too many clients already.' To address this, I increased > the number of max_connections to 3000, 5000, and also 1, but I > still receive the error. Now, I'm

Re: PostgreSQL Guard

Read https://www.tecmint.com/configure-postgresql-streaming-replication-in-centos-8/ . On Wed, Feb 28, 2024 at 10:36 AM Jason Long wrote: > Hi, > Thanks again. > I have another questions: > > 1- Should I just install PostgreSQL normally on the Standby server? > > 2- Are the steps the same for ot

Re: PostgreSQL Read-only mode usage

Hi,1- What does it mean, not the whole database? 2- Can this be considered a kind of guard? 3- Can you tell me a read-only scenario? For example, if we have three servers, then one of the servers can be the main server and the other two servers can be read only. On Wed, Feb 28, 2024 at 4:2

Re: PostgreSQL Guard

Hi,Thanks again.I have another questions: 1- Should I just install PostgreSQL normally on the Standby server? 2- Are the steps the same for other Linux distributions like Debian? On Wed, Feb 28, 2024 at 9:29 AM, Ron Johnson wrote: As before, I encourage you to read  https://www.tecmint.com/

Re: PostgreSQL Read-only mode usage

På onsdag 28. februar 2024 kl. 13:55:34, skrev Andreas Kretschmer < andr...@a-kretschmer.de >: Am 28.02.24 um 13:34 schrieb Jason Long: > Hello, > What is the use of a database in read-only mode? a standby-database will also be in read-only mode. Right, we have

Re: PostgreSQL Guard

On Tue, Feb 27, 2024 at 3:48 PM Jason Long wrote: > Suppose you want to transfer the database of a website like Amazon.com to > a new server and delete the old one. Many users are buying and selling on > this website at the same time and it is not possible to turn off the > server. What do you do

Re: PostgreSQL Read-only mode usage

Am 28.02.24 um 13:34 schrieb Jason Long: Hello, What is the use of a database in read-only mode? a standby-database will also be in read-only mode. Regards, Andreas -- Andreas Kretschmer CYBERTEC PostgreSQL Services and Support

Re: PostgreSQL Read-only mode usage

On Wed, 28 Feb 2024 at 13:34, Jason Long wrote: > What is the use of a database in read-only mode? Normally it is a connection/session to the database what is in read-only mode, not the whole database. As it has been pointed out, you connect in read only mode to read, so you are protected from a

Re: PostgreSQL Guard

As before, I encourage you to read https://www.tecmint.com/configure-postgresql-streaming-replication-in-centos-8/ . On Tue, Feb 27, 2024 at 3:48 PM Jason Long wrote: > Hi, > Do I have to run this command on the server where the main database is > located? > > Suppose you want to transfer the da

  1   2   3   4   5   6   7   8   9   10   >