Hi Kyotaro,
Thank you for your explanation, after putting the crl file to client, it
works now, thanks.
Kyotaro Horiguchi 于2021年12月2日周四 下午12:46写道：
> Hi.
>
> At Thu, 2 Dec 2021 11:31:26 +0800, Yi Sun wrote in
> > Hi Kyotaro
> >
> > From the description, seems ~/.postgresql/root.crl is store
>
> I expect my 'vote' counts for naught, but I fully expect seeing these show
> up in the logs would have helped me much more quickly have insight into
> what was going on during times of very high concurrency and extreme
> slowness with many processes showing as waiting on LwLocks.
>
Is there
On Thursday, December 2, 2021, Paul van der Linden <
paul.doskabou...@gmail.com> wrote:
> Hi,
>
> when switching to postgres 14 (from 11) I'm having some slow queries
> because of inlining of CTE's.
> I know I can get the same result as with PG11 when adding MATERIALIZED to
> the cte, but the
On 12/2/21 01:51, Sonai muthu raja M wrote:
Dear Team,
Kindly help us to provide the details that how to find User creation
date in postgresql Database.
Note: we know that we can find the create user query from postgresql
log. Apart from that how to find it from inside the Database
You
"Sonai muthu raja M" writes:
> Kindly help us to provide the details that how to find User creation date in
> postgresql Database.
This information is not stored by Postgres, so you can't.
regards, tom lane
Hi,
when switching to postgres 14 (from 11) I'm having some slow queries
because of inlining of CTE's.
I know I can get the same result as with PG11 when adding MATERIALIZED to
the cte, but the same application also needs to be able to run on older
postgres versions, so that is a no-go.
Is there
Dear Team,
Kindly help us to provide the details that how to find User creation date in
postgresql Database.
Note: we know that we can find the create user query from postgresql log. Apart
from that how to find it from inside the Database
Warm regards,
M Sonai Muthu Raja
Managed Delivery
Vincas Dargis writes:
> Should we expect this fix in the next 14 patch release, or only in 15.x?
I did push it into v14:
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=175edafd1f30a78643359b56c5545b5e7aabfb50
regards, tom lane
Thanks Tom!
Should we expect this fix in the next 14 patch release, or only in 15.x?
If latter, I would add this patch into Conan package itself, to make it work
earlier.
On 2021-11-30 23:33, Tom Lane wrote:
I wrote:
It seems like a useful test when *not* cross compiling, which is most
of
Of course that would be in the manual ;-) Thank you for pointing this
out. We've been doing upgrades the reliable old school way for so long
that I wasn't aware that something better was already well documented.
Thank you,
Alan
On 12/2/21 11:10, Adrian Klaver wrote:
> On 12/2/21 08:05, Alan
On 12/2/21 08:05, Alan Stange wrote:
Hello all,
We're running a 13.x installation and looking to upgrade to 14.1. This
is all on Linux servers. We have a main instance running with a number
of hot standby replicas configured. In the past, we have done a
dump/restore on a slow evening and
Hello all,
We're running a 13.x installation and looking to upgrade to 14.1. This
is all on Linux servers. We have a main instance running with a number
of hot standby replicas configured. In the past, we have done a
dump/restore on a slow evening and then rsynced all the bits around so
that
I realise this may not be applicable to the original problem, but
non-deterministic collations seems to offer a solution::
dakkar@[local] dakkar=> create collation "en-US-ins-icu" (
provider=icu,
locale='en-US-u-ks-level2',
deterministic=false
);
On Wed, Dec 1, 2021 at 8:49 PM Tom Lane wrote:
> Peter Eisentraut writes:
> > Running lower() like this is really the wrong thing to do. We should be
> > doing "case folding" instead, which normalizes these differences for the
> > purpose of case-insensitive comparisons.
>
> That just begs the
Sorry, my previous mail had in the title Publication instead of Subscription
Hi All,
If I find a subscription in subenabled = false state. Is it safe to run ALTER
subscription and put it in ENABLE state or it is better to drop and create it
from scratch?
I'm trying to figure our what can
Hi All,
If I find a subscription in subenabled = false state. Is it safe to run ALTER
subscription and put it in ENABLE state or it is better to drop and create it
from scratch?
I'm trying to figure our what can cause subscription to be in subenabled =
false state. If we know all the
16 matches
Mail list logo
