Thank you Adrian.
Regards,
Bhanu Priya
Internal
-Original Message-
From: Adrian Klaver
Sent: Tuesday, August 24, 2021 9:50 AM
To: Bhanu Priya ; pgsql-general@lists.postgresql.org
Cc: Pulimi Varshitha ; Murali Ambati
; Yogesh Butala ; GARAPATI CHANDRA
SYAM KUMAR
Subject: Re: Multipl
Hi Adrian,
Thank you for your response on our query. Could you please confirm if this is
an expected behavior and the link shared by you gives the details for the same.
Regards,
Bhanu Priya
Internal
-Original Message-
From: Adrian Klaver
Sent: Monday, August 23, 2021 8:30 PM
To: GAR
Hi,
dict_int is trusted extension in pg13. After creating dict_int extension with unprivileged user, ALTER TEXT SEARCH DICTIONARY intdict ((MAXLEN = 7) failed.
admin=> ALTER TEXT SEARCH DICTIONARY intdict (MAXLEN = 7);ERROR: must be owner of text search dictionary intdict
This is by design o
On 8/23/21 8:07 PM, Bhanu Priya wrote:
Hi Adrian,
Thank you for your response on our query. Could you please confirm if this is
an expected behavior and the link shared by you gives the details for the same.
The link lays it out.
If you want more confirmation:
https://www.postgresql.org/doc
Sorry, I misspoke there - I meant to say that since one should not count on
the standby-failover process to always run smoothly (whether it's due to
hardware, operator, automated scripts, or software issues), DB backups
should also be in place if at all possible.
On Mon, Aug 23, 2021 at 1:37 PM Sa
Hi Moishe,
Since we use pgbackrest ourselves, this is the process I followed to set up
something similar on PG 10:
https://pgstef.github.io/2018/11/28/combining_pgbackrest_and_streaming_replication.html
(Not knowing much [if at all] about the reason for your requirements, I
would recommend looki
What are the parameters have you set in the recovery.conf file?
Regards,
Ninad Shah
On Fri, 20 Aug 2021 at 18:53, Hispaniola Sol wrote:
> Team,
>
> I have a pg 10 cluster with a master and two hot-standby nodes. There is a
> requirement for a manual failover (nodes switching the roles) at will
On 8/23/21 5:00 AM, GARAPATI CHANDRA SYAM KUMAR wrote:
Hi,
We are using Postgres 10 (Single client)and observed that there are
multiple PostgreSQL Server process are running in background.
Why these additional processes are created or is this an expected behavior.
Yes
https://www.postgresq
Hi,
We are using Postgres 10 (Single client)and observed that there are multiple
PostgreSQL Server process are running in background.
Why these additional processes are created or is this an expected behavior.
[cid:72095bed-31cc-47e2-bcd9-4711533cdd68]
Regards
Chandra Syam Kumar Garapati
I
You are right, I also found the same behaviour when using e.g the UNIX sed
command.
Ingolf
On Mon, Aug 23, 2021 at 4:24 PM Francisco Olarte
wrote:
> Ingolf:
>
> On Mon, Aug 23, 2021 at 2:39 PM Markhof, Ingolf
> wrote:
> > Yes, When I use (\1)? instead of (\1)+, the expression is evaluated
> q
Ingolf:
On Mon, Aug 23, 2021 at 2:39 PM Markhof, Ingolf
wrote:
> Yes, When I use (\1)? instead of (\1)+, the expression is evaluated quickly,
> but it doesn't return what I want. Once a word is written, it is not subject
> to matching again. i.e.
> select regexp_replace( --> remove double entri
On Mon, 23 Aug 2021 at 11:20, Marc wrote:
> On 23 Aug 2021, at 11:55, Oliver Kohll wrote:
>
> > Hi,
> >
> > Just wondering if anyone knows which release (if any) this is targeted
> for?
> >
> > https://wiki.postgresql.org/wiki/Incremental_View_Maintenance
> >
> > Asking because this could make a
Argh...
Yes, When I use (\1)? instead of (\1)+, the expression is evaluated
quickly, but it doesn't return what I want. Once a word is written, it is
not subject to matching again. i.e.
select regexp_replace( --> remove double entries
'one,one,one,two,two,three,three',
'([^,]+)(,\1)?($|,)
On 23 Aug 2021, at 11:55, Oliver Kohll wrote:
> Hi,
>
> Just wondering if anyone knows which release (if any) this is targeted for?
>
> https://wiki.postgresql.org/wiki/Incremental_View_Maintenance
>
> Asking because this could make a massive difference to some of our
> workload, even when limited
Hi,
Just wondering if anyone knows which release (if any) this is targeted for?
https://wiki.postgresql.org/wiki/Incremental_View_Maintenance
Asking because this could make a massive difference to some of our
workload, even when limited to relatively simple queries. It's quite
exciting.
Regards
Tom, I see your point. Which is valid considering there could be any value
in col_y for some value in col_x. But in my case, col_y is a a function of
col_x, i.e. two rows with the same value in row_x will have the same value
in row_y as well.
Consider, you need to store some length values. Like t
On Mon, 2021-08-23 at 15:34 +0800, Kelvin Lau wrote:
> I have been using Python to deal with CRUD of the database. I have discovered
> that there are
> some issues when dealing with long queries (either SELECT or COPY, since it
> is somewhat big data). The
> connection is dropped by the 2~3 hours
Right. Considering a longer sequence of a's, "(a*)\1" allows a wide variety
of matches. But in fact, this is not what I was trying to use. I was more
looking at "(a)\1*" which shall match exactly what "a+" matches. As
matching is greedy, "(a)\1*" shall consume all a's in a sequence in one go,
just
Hello psql community,
I have been using Python to deal with CRUD of the database. I have
discovered that there are some issues when dealing with long queries
(either SELECT or COPY, since it is somewhat big data). The connection
is dropped by the 2~3 hours mark and I have no idea what is wrong
19 matches
Mail list logo
