Re: connect postgres using url

On 6/27/23 16:30, Adrian Klaver wrote: On 6/27/23 16:14, Atul Kumar wrote: HI, Could you please help me in telling how I can connect my postgres database using http url ? Are you actually talking about a Web based URL or a URI as in?:

Re: connect postgres using url

On 6/27/23 16:14, Atul Kumar wrote: HI, Could you please help me in telling how I can connect my postgres database using http url ? Are you actually talking about a Web based URL or a URI as in?: https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-CONNSTRING If you are talking

connect postgres using url

HI, Could you please help me in telling how I can connect my postgres database using http url ? What steps need to be taken care of ? Please share any referral link, if possible. Regards, Atul

Re: typical active table count?

On 6/27/23 12:08 PM, Ron wrote: > On 6/27/23 13:47, Jeremy Schneider wrote: >> On 6/27/23 9:32 AM, Ben Chobot wrote: >>> We certainly have databases where far more than 100 tables are updated >>> within a 10 second period. Is there a specific concern you have? >>> >> Thank Ben, not a concern but

Re: pb with join plan

On Tue, Jun 27, 2023 at 8:12 PM Kirk Wolak wrote: > On Wed, Jun 21, 2023 at 12:10 PM Marc Millas > wrote: > >> Marc MILLAS >> On Wed, Jun 21, 2023 at 12:43 PM Tomas Vondra < >> tomas.von...@enterprisedb.com> wrote: >> >>> On 6/21/23 00:26, Marc Millas wrote: >>> > >>> > >>> > On Tue, Jun 20,

Re: regex failing

On Tue, 27 Jun 2023 at 14:59, Zahir Lalani wrote: > > Hi All > > > > Got a weird one. I am using the regex below to case match numeric only values. > > > > '^([0-9]+[.]?[0-9]*)$' > > > > This works well by and large but not for a value like “1234:567”. This seems > to match positive and then

Re: regex failing

Probably not much help but it seems to work ok for me (unless I'm doing something stupid). You didn't actually say how/where you were doing the regex match, but the '~' operator seems to work ok. [~/git/caas-sqs-consumer] psql psql (15.3 (Homebrew), server 13.7) SSL connection (protocol: TLSv1.2,

Re: regex failing

On Tue, Jun 27, 2023 at 11:59 AM Zahir Lalani wrote: > Hi All > > > > Got a weird one. I am using the regex below to case match numeric only > values. > > > > '^([0-9]+[.]?[0-9]*)$' > > > > This works well by and large but not for a value like “1234:567”. This > seems to match positive and then

Re: typical active table count?

On 6/27/23 11:47 AM, Jeremy Schneider wrote: On 6/27/23 9:32 AM, Ben Chobot wrote: We certainly have databases where far more than 100 tables are updated within a 10 second period. Is there a specific concern you have? Thank Ben, not a concern but I'm trying to better understand how common

Re: typical active table count?

On 6/27/23 13:47, Jeremy Schneider wrote: On 6/27/23 9:32 AM, Ben Chobot wrote: We certainly have databases where far more than 100 tables are updated within a 10 second period. Is there a specific concern you have? Thank Ben, not a concern but I'm trying to better understand how common this

regex failing

Hi All Got a weird one. I am using the regex below to case match numeric only values. '^([0-9]+[.]?[0-9]*)$' This works well by and large but not for a value like “1234:567”. This seems to match positive and then fails due to not being an actual number in the subsequent cast. Any ideas?

Re: typical active table count?

On 6/27/23 9:32 AM, Ben Chobot wrote: > We certainly have databases where far more than 100 tables are updated > within a 10 second period. Is there a specific concern you have? > Thank Ben, not a concern but I'm trying to better understand how common this might be. And I think sharing general

Re: bug or lacking doc hint

On Mon, Jun 26, 2023 at 4:21 PM Marc Millas wrote: > On Mon, Jun 26, 2023 at 4:05 PM Ron wrote: > >> On 6/26/23 07:22, Marc Millas wrote: >> >> On Mon, Jun 26, 2023 at 5:47 AM Avin Kavish wrote: >> >>> Sounds like the problem you are having is, the server is running out of >>> temporary

Re: pb with join plan

On Wed, Jun 21, 2023 at 12:10 PM Marc Millas wrote: > Marc MILLAS > On Wed, Jun 21, 2023 at 12:43 PM Tomas Vondra < > tomas.von...@enterprisedb.com> wrote: > >> On 6/21/23 00:26, Marc Millas wrote: >> > >> > >> > On Tue, Jun 20, 2023 at 11:19 PM David Rowley > > >

Re: typical active table count?

We certainly have databases where far more than 100 tables are updated within a 10 second period. Is there a specific concern you have? Jeremy Schneider wrote on 6/27/23 9:01 AM: Question for other PostgreSQL users On your moderately busy DB, how many different tables might receive at least

Requesting Information for GSSAPI

Team, We have configured postgres GSSAPI setup on Linux server. We have huge domain AD users in our org. But we are looking to limit access only to setup AD distributed groups. Is there any way to control access only at AD distribution list user can only access gssapi configured postgres

Re: When will trusted PL/Python be supported?

On Tue, Jun 27, 2023 at 12:17 PM Tom Lane wrote: > > Adrian Klaver writes: > > On 6/27/23 04:46, Bowen Shi wrote: > >> I'd like to know is supporting trusted PL/Python still in the > >> schedule? What is the reason for the current lack of support, and do > >> we have any relevant email

Re: When will trusted PL/Python be supported?

Adrian Klaver writes: > On 6/27/23 04:46, Bowen Shi wrote: >> I'd like to know is supporting trusted PL/Python still in the >> schedule? What is the reason for the current lack of support, and do >> we have any relevant email discussion?

typical active table count?

Question for other PostgreSQL users On your moderately busy DB, how many different tables might receive at least one change/DML during a 10 second window? 10? 50? 100? More? Ballpark guess off the top of your head. I'm in a discussion & there's questions about whether it's unusual to have more

typical active table count?

Question for other PostgreSQL users On your moderately busy DB, how many different tables might receive at least one change/DML during a 10 second window? 10? 50? 100? More? Ballpark guess off the top of your head. I'm in a discussion & there's questions about whether it's unusual to have more

Re: Large scale reliable software system

On 6/27/23 07:58, Merlin Moncure wrote: On Mon, Jun 26, 2023 at 6:49 PM B M > wrote: Dear all, After greeting, I taught PostgreSQL myself and developed a small scale experimentalsoftware system using PostgreSQL in the back-end. I would like

Re: Large scale reliable software system

On Mon, Jun 26, 2023 at 6:49 PM B M wrote: > Dear all, > > After greeting, > > I taught PostgreSQL myself and developed a small scale experimental > software system using PostgreSQL in the back-end. > > I would like to know your advices to develop a large scale reliable > software system using

Re: When will trusted PL/Python be supported?

On 6/27/23 04:46, Bowen Shi wrote: Dears, It seems to me that we have untrusted PL/Python for a long time, but till now we still do not support trusted plpython. I'd like to know is supporting trusted PL/Python still in the schedule? What is the reason for the current lack of support, and do

Re: Query regarding managing Replication

Hello, You can have a look at the parameter : listen_addresses in the file postgresql.conf. By default the value is localhost. Regards Romain MAZIÈRE romain.mazi...@sigmaz-consilium.fr +33.535.545.085 +33.781.46.36.96 https://sigmaz-consilium.fr Le 27/06/2023 à 16:04, Ashok Patil a écrit :

Query regarding managing Replication

Hello Sir/Madam, I have to perform task of database replication. For that for testing purpose I have installed Postgress 14 on two different machine. One is primary (We can say it as server) and another one is secondary (stand by). Below steps i have performed *On Primary* 1. Update

Re: Helping planner to chose sequential scan when it improves performance

On Sun, Jun 25, 2023 at 3:48 PM David Rowley wrote: > On Wed, 14 Jun 2023 at 07:28, Patrick O'Toole > wrote: > > Maybe we are barking up the wrong tree with the previous questions. Are > there other configuration parameters we should consider first to improve > performance in situations like

Re: Large scale reliable software system

Well, seeing as postgres isn't designed to serve http requests or to run general purpose code that doesn't involve databases, which you can express elegantly in python, to answer OP's question - my vote is on the original answer - Django. It's got everything out of the box - authentication. file

Aw: When will trusted PL/Python be supported?

> It seems to me that we have untrusted PL/Python for a long time, but > till now we still do not support trusted plpython. > > I'd like to know is supporting trusted PL/Python still in the > schedule? What is the reason for the current lack of support, and do > we have any relevant email

When will trusted PL/Python be supported?

Dears, It seems to me that we have untrusted PL/Python for a long time, but till now we still do not support trusted plpython. I'd like to know is supporting trusted PL/Python still in the schedule? What is the reason for the current lack of support, and do we have any relevant email discussion?

Re: Large scale reliable software system

On Tue, 27 Jun 2023 at 07:08, Guyren Howe wrote: > Correct. It’s a tragically wrong piece of folk wisdom that’s pretty > general across web development communities. > > On Jun 26, 2023, at 21:32, Michael Nolan wrote: > > It's not just Ruby, dumb databases are preferred in projects like >

Re: 2 master 3 standby replication

I have also searched on this type of architecture, but unfortunately PostgreSQL does not have any such solution till date. Regards, On Fri, Jun 23, 2023 at 1:40 PM Pavel Stehule wrote: > Hi > > pá 23. 6. 2023 v 10:37 odesílatel Atul Kumar > napsal: > >> Hi, >> >> Please help me with the

Re: Large scale reliable software system

> Correct. It’s a tragically wrong piece of folk wisdom that’s pretty general across web development communities. So, what's your advice, and is there some book / resource to get upto speed? Thanks! On Tue, Jun 27, 2023 at 10:38 AM Guyren Howe wrote: > Correct. It’s a tragically wrong piece