Ok here you go.
select create_immv('plantskillpayment', 'select distinct kwapp_plant.id
as plantid, kwapp_skill.id as skillid, kwapp_skill.skillname,
kwapp_plant.plantname, kwapp_pltsklpaylvl.level, kwapp_pltsklpaylvl.pay
from kwapp_skill, kwapp_plant, kwapp_pltsklpaylvl where
kwapp_skill.i
When you know that the SELECT statement runs on the local machines, then on
each server, run these SQL statements:
SHOW search_path;
SELECT * FROM pg_extension;
On Fri, Feb 28, 2025 at 12:26 PM Krishnakant Mane
wrote:
>
> On 2/28/25 22:53, Ron Johnson wrote:
>
>
> Differing search_path values
Hello all.
I am not able to use create_immv in postgresql 16.6 even after
installing it and doing create extention.
I did a git clone of the repository and then make sudo make install to
install it.
The issue is not happening on my local ubuntu 24.04 machine but on
ubuntu 24.04 on aws free
Sorry, correction for the openssl command output:
$ openssl s_client -connect 172.21.32.4:5432 -starttls postgres
Connecting to 172.21.32.4
CONNECTED(0003)
Can't use SSL_get_servername
depth=2 C=US, O=DigiCert Inc, OU=www.digicert.com, CN=DigiCert Global Root
G2
verify return:1
depth=1 C=US, O
On Fri, Feb 28, 2025 at 11:41 AM Krishnakant Mane
wrote:
> Hello all.
>
> I am not able to use create_immv in postgresql 16.6 even after installing
> it and doing create extention.
>
> I did a git clone of the repository and then make sudo make install to
> install it.
>
> The issue is not happen
Good afternoon,
I am using an Azure Database for PostgreSQL flexible server with no public
ip.
It is connected to a private VNet and I try to access it from an Alpine
Linux container with openssl and postgresql-client installed.
In Azure portal I have clicked the "Reset password" button, entered
Thank you for the comments, I must think some time how to handle this.
My intention has been to generate 2 random strings in an Azure pipeline,
save them as secrets in an Azure Key Vault (so that our C# ASP.Net app can
fetch them when starting up in Kubernetes) and also pass them to the
pipeline t
Hi Alex,
pt., 28 lut 2025 o 16:05 Alexander Farber
napisał(a):
> Now the connection from a container in AKS works for me:
>
> $ psql "postgresql://postgresql:password12345!!@
> 172.21.32.4:5432/postgres?sslmode=require"
> psql (17.4, server 16.6)
> SSL connection (protocol: TLSv1.3, cipher: TLS_
Ah my team mate has spotted the error for me.
And it paid off, that he has no experience with PostgreSQL yet :-)
Because the admin user for Azure Database for PostgreSQL flexible server is
not "postgres" but "postgresql"
Now the connection from a container in AKS works for me:
$ psql "postgresq
On 2/28/25 22:53, Ron Johnson wrote:
Differing search_path values can lead to problems like this.
So what can I do to resolve this?
On Fri, Feb 28, 2025 at 12:01 PM Krishnakant Mane
wrote:
Ok here you go.
select create_immv('plantskillpayment', 'select distinct
kwapp_plant.id
On Fri, Feb 28, 2025 at 6:50 AM KK CHN wrote:
> List
>
> postgres=# SELECT PID, now() - pg_stat_activity.query_start AS duration,
> query, state FROM pg_stat_activity WHERE (now() - pg
> _stat_activity.query_start) > interval '5 minutes' AND state = 'active';
> pid |duration |
That's harmless, it is the walsender process, and it is meant to be
long-running. You can modify your query and add this:
AND backend_type = 'client backend'
to filter out any background processes.
Cheers,
Greg
--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products
List
postgres=# SELECT PID, now() - pg_stat_activity.query_start AS duration,
query, state FROM pg_stat_activity WHERE (now() - pg
_stat_activity.query_start) > interval '5 minutes' AND state = 'active';
pid |duration | query
| state
--+--
Thank you.
Just a quick question.
should it be in pg_catalog?
if yes then it is so.
On 3/1/25 01:39, Adrian Klaver wrote:
On 2/28/25 09:26, Krishnakant Mane wrote:
On 2/28/25 22:53, Ron Johnson wrote:
Differing search_path values can lead to problems like this.
So what can I do to resol
14 matches
Mail list logo
