It seems like you are maybe wanting this- If the previous row is the same,
then get the previous row's run_nr. If it is different, then increment.
case when lag( property_A ) over() = property_A and lag( property_B )
over() = property_B then coalesce( lag( run_nr ) over(), 1 ) else lag(
run_nr ) o
Hi,
We are having a dependency problem when using the community repo on redhat 7
When we install postgresql12-devel-12.4-1PGDG.rhel7.x86_64 we get the issue
below.
Redhat doesn't support the dependencies. Any ideas? We are trying to get the
ruby gem installed. It works with the Redhat dist of Pos
On Thu, 3 Sep 2020 at 16:01, Tom Lane wrote:
> Alban Hertroys writes:
> > As stated above, I want to enumerate the runs, starting at 1 and
> > incrementing by 1 every time a partition from the 'run' window closes,
> > Is there a way to achieve this through window functions, or do we need to
> >
On Wed, 2 Sep 2020 20:33:09 +0300
Олег Самойлов wrote:
> The software is rather outdated. It works with PostgreSQL 11 and CentOS 7.
> The next step will be upgrading to CentOS 8 and PostgreSQL 12. Please tell
> me, is it useful and worth to continue? Where is better announce it? May be
> somewher
Alban Hertroys writes:
> As stated above, I want to enumerate the runs, starting at 1 and
> incrementing by 1 every time a partition from the 'run' window closes,
> Is there a way to achieve this through window functions, or do we need to
> wrap the thing in a subquery to achieve this?
I think th
On 2020-09-03 14:01, Susan Joseph wrote:
Unfortunately I am not allowed to use wireshark in my environment. Good
idea though
The system view pg_stat_ssl, in combination with pg_stat_activity, will
show you whether a connection is using SSL.
--
Peter Eisentraut http://www.2ndQua
Susan Joseph
sandajos...@verizon.net
-Original Message-
From: Stephen Frost
To: Susan Joseph
Cc: pgsql-gene...@postgresql.org
Sent: Thu, Sep 3, 2020 9:12 am
Subject: Re: SSL between Primary and Seconday PostgreSQL DBs
Greetings,
* Susan Joseph (sandajos...@verizon.net) wrote:
>
Hello,
I’m creating one big installer for several software applications, including
PostgreSQL and I’m facing the following issue:
If the default port of PostgreSQL is changed during installation the port of
pgadmin’s default server is not updated (remains 5432).
[cid:c02b4b49-66ec-450a-b17
Hello,
Switching from SQL Server to PostgreSQL.
Installed Postgresql 11.8 successfully.
Need to install ODBC to connect from front end. When I install ODBC using
stack builder , I see the ODBC name < in ODBC data source
administrator>
PostgresSQL ODBC Driver(ANSI)PostgresSQL ODBC Driver(UNICOD
We are trying to add some information to a query over data from a
continuous process. Most of what we want can be done quite nicely using
window functions, but I got stuck on this particular problem:
The data has records with a timestamp and a few properties that make
subsequent rows belong to the
Greetings,
* Susan Joseph (sandajos...@verizon.net) wrote:
> So I made the changes on the secondary to change the sslmode to verify-fullI
> removed the clientcert=1 in pg_hba.conf and removed any connections other
> than sslI removed the passfile info from recovery.confand now I am getting
> th
So I made the changes on the secondary to change the sslmode to verify-fullI
removed the clientcert=1 in pg_hba.conf and removed any connections other than
sslI removed the passfile info from recovery.confand now I am getting this
error:
2020-09-03 13:01:49.990 UTC [7963] FATAL: could not conne
Greetings,
We really prefer it if you don't top-post on these lists but instead
reply in-line, as I did.
* Susan Joseph (sandajos...@verizon.net) wrote:
> This is great, thanks. I have not heard of verify-full but I will try that
> and let you know if I have issues.
> So I will remove the passf
This is great, thanks. I have not heard of verify-full but I will try that and
let you know if I have issues.
So I will remove the passfile info for recovery.conf. It was there because I
first set it up using passwords to make sure it was working and then moved to
SSL so if not needed I can re
Greetings,
* Susan Joseph (sandajos...@verizon.net) wrote:
>- primary_conninfo = 'user=rep_user passfile=''/data/.pgpass''
> host= port=5432 sslmode=verify-ca sslcert=client.crt
> sslkey=client.key sslcompression=0 target_session_attrs=any'
You really should be using sslmode=verify-full, ot
Unfortunately I am not allowed to use wireshark in my environment. Good idea
though
Susan Joseph
sandajos...@verizon.net
-Original Message-
From: Wim Bertels
To: Susan Joseph ; peter.eisentr...@2ndquadrant.com
; pgsql-gene...@postgresql.org
Sent: Thu, Sep 3, 2020 7:44 am
Subje
First thougt: A general solution that you could use is wireshark.
For example : Search for wireshark ssl traffic
Susan Joseph schreef op September 3, 2020 10:54:36 AM
UTC:
>OK, I understand I was just hoping someone could confirm that my
>settings are correct.
>I didn't come across an error
On Thu, Sep 3, 2020 at 5:54 AM Susan Joseph wrote:
>
> OK, I understand I was just hoping someone could confirm that my settings are
> correct.
> I didn't come across an error so everything seems to be working I just can't
> verify that SSL is working.
> Are there any commands you can run to ver
Hi all.
I tried searching for the response to this but couldn’t find any.
I have pg_restore running in parallel (3 or more) and processing large amount
of data that is in partitioned tables. However it seems that sometime deadlock
appears when one process is trying to process primary key on par
OK, I understand I was just hoping someone could confirm that my settings are
correct.
I didn't come across an error so everything seems to be working I just can't
verify that SSL is working.
Are there any commands you can run to verify that SSL is up and operational?
Testing from a client
Hi all
In master branch, I found a typo in Comments of function
HandleProcSignalBarrierInterrupt.
See the attachment for the patch.
Best regards.
fix-typo.patch
Description: fix-typo.patch
21 matches
Mail list logo
