Hi.
After applying the latest patch we have encountered a problem with the
pg_notify queue.
The queue is filling up and starts issuing warnings like
WARNING: NOTIFY queue is 87% full
DETAIL: The server process with PID 2969993 is among those with the oldest
transactions.
NOTIFY queue cannot b
()
;
pg_notification_queue_usage
-
0.245367050170898
(1 row)
If my calculations is correct we will reach 50% on monday.
kr
/Mikael Gustavsson
Från: David G. Johnston
Skickat: den 27 november 2020 15:28
Till: Gustavsson Mikael
Kopia: pgsql
Hi.
We installed PG 11.10 last week. So the latest release of PG 11.
KR
Mikael Gustavsson
Från: Tom Lane
Skickat: den 27 november 2020 16:21:33
Till: Gustavsson Mikael
Kopia: pgsql-generallists.postgresql.org; Svensson Peter; Almen Anders
Ämne: Re: Problem
Clarification, we upgraded from PG 11.9 to PG 11.10.
KR Mikael Gustavsson
Från: externaly-forwar...@smhi.se för Gustavsson
Mikael
Skickat: den 27 november 2020 16:24:38
Till: Tom Lane
Kopia: pgsql-generallists.postgresql.org; Svensson Peter; Almen Anders
Ämne
Hi,
We are starting our journey to migrate from Postgresql 11 to Postgresql 13 and
have run into a problem.
The postgresql 13 version of psql don´t seem to work with ssl.
We use the community built rpms on redhat 8.3:
$ rpm -q postgresql11
postgresql11-11.10-1PGDG.rhel8.x86_64
$ rpm -q postgres
Hi,
I have used this setup to do something similar.
https://github.com/2ndQuadrant/audit-trigger
KR, Mikael Gustavsson
Från: Ayub M
Skickat: den 15 december 2020 18:13:39
Till: PostgreSQL General
Ämne: postgres auditing truncates and deletes on tables
for
different
psql-clients.
KR
Från: Kyotaro Horiguchi
Skickat: den 17 december 2020 09:29:38
Till: Gustavsson Mikael
Kopia: pgsql-gene...@postgresql.org; Svensson Peter
Ämne: Re: Problem with ssl and psql in Postgresql 13
Hi.
At Thu, 17 Dec 2020 07:21:08 +, Gustavsson Mikael
w
gres", SSL off
KR
Mikael Gustavsson, SMHI
Från: Tom Lane
Skickat: den 17 december 2020 15:20:01
Till: Gustavsson Mikael
Kopia: Kyotaro Horiguchi; pgsql-gene...@postgresql.org; Svensson Peter
Ämne: Re: SV: Problem with ssl and psql in Postgresql 13
Gustavsson Mikael
alle", database "postgres", SSL off
FATAL: no pg_hba.conf entry for host "nn.nnn.n.nnn", user "kalle", database
"postgres", SSL off
KR Mikael Gustavsson, SMHI
Från: Magnus Hagander
Skickat: den 17 december 2020 15:52:5
conf entry for host "nn.nnn.n.nnn", user "kalle", database
"postgres", SSL off
/Mikael
____
Från: Magnus Hagander
Skickat: den 17 december 2020 17:03:18
Till: Gustavsson Mikael
Kopia: Tom Lane; Kyotaro Horiguchi; pgsql-gene...@pos
.so.3 (0x7f8840de3000)
/lib64/ld-linux-x86-64.so.2 (0x7f88437b6000)
libselinux.so.1 => /lib64/libselinux.so.1 (0x7f8840bb9000)
libcrypt.so.1 => /lib64/libcrypt.so.1 (0x7f884099)
libpcre2-8.so.0 => /lib64/libpcre2-8.so.0 (0x7f884070c000)
/Mikael
_
ver11
Password for user kalle:
psql (13.1, server 11.10)
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256,
compression: off)
Type "help" for help.
postgres=>
KR Mikael Gustavsson, SMHI
________
Från: externaly-forwar...@smhi.se
Jul as we say in Sweden.
KR
Mikael Gustavsson, SMHI
Från: Tom Lane
Skickat: den 18 december 2020 21:02:50
Till: Gustavsson Mikael
Kopia: Magnus Hagander; Kyotaro Horiguchi; pgsql-gene...@postgresql.org;
Svensson Peter
Ämne: Re: SV: SV: SV: Problem with ssl and
__
Från: externaly-forwar...@smhi.se för Gustavsson
Mikael
Skickat: den 22 december 2020 09:07:17
Till: Tom Lane
Kopia: Magnus Hagander; Kyotaro Horiguchi; pgsql-gene...@postgresql.org;
Svensson Peter
Ämne: SV: SV: SV: SV: Problem with ssl and psql in Postgresql 13
Hi,
Yes it´
Hi,
Is it something like row_number() you want?
https://www.postgresql.org/docs/current/functions-window.html
KR
Mikael
Från: Durumdara
Skickat: den 10 mars 2023 8:12
Till: Postgres General
Ämne: Onfly, function generated ID for Select Query
Dear Members!
I'm
No, the result will be ordered by the window functions order clause so no
additional ordering is nessesary.
You can try this by changing it to OVER(ORDER BY product_name)
KR
Mikael
Från: Durumdara
Skickat: den 10 mars 2023 08:41:06
Till: Gustavsson Mikael
Hi,
I have a Postgresql 11 and Slony 2.2.7 setup with one master and multiple slave
nodes. On one of the slaves I want a user defined trigger to fire on insert.
The trigger fires a notify function.
Now to the problem.
If I create the trigger it looks like it is enabled on the slave but it do n
KR /Mikael
Från: Achilleas Mantzios [ach...@matrix.gatewaynet.com]
Skickat: den 18 februari 2019 12:31
Till: pgsql-general@lists.postgresql.org
Ämne: Re: Slony and triggers on slavenodes.
On 18/2/19 1:09 μ.μ., Gustavsson Mikael wrote:
Hi,
I have a Postgresql 11 and Slony 2
>From documentation:
"REFRESH MATERIALIZED VIEW completely replaces the contents of a materialized
view. To execute this command you must be the owner of the materialized view."
So it is intended behavior.
https://www.postgresql.org/docs/11/sql-refreshmaterializedview.html
___
Hi,
We recently upgraded from PG9.6 to PG11 and I have some questions regarding the
function to_timestamp.
We have an application that for some reason unknown to me uses timestamps with
hour = 24.
After upgrade we got som problems with this. The solution is to use cast
instead of the function
Thanks for fast reply!
I'll forward the answer to my developers.
kr
Mikael Gustavsson
Från: Tom Lane [t...@sss.pgh.pa.us]
Skickat: den 20 mars 2019 17:33
Till: Gustavsson Mikael
Kopia: pgsql-general@lists.postgresql.org
Ämne: Re: to_timestamp fun
Hi,
You can use generate_series.
select generate_series(1,select max(id) from theserecords)
EXCEPT
select id from theserecords;
KR
Från: Durumdara [durumd...@gmail.com]
Skickat: den 22 maj 2019 15:43
Till: Postgres General
Ämne: Which records aren't in list? Use
Here is one without syntax error.
select generate_series(1,(select max(id) from theserecords))
EXCEPT
select id from theserecords;
Från: Gustavsson Mikael [mikael.gustavs...@smhi.se]
Skickat: den 22 maj 2019 15:51
Till: Durumdara; Postgres General
Ämne: SV: Which
Hi,
idle_in_transaction_session_timeout came in PG 9.6 if im not mistaken.
KR
Mikael
Från: Atul Kumar
Skickat: den 7 maj 2021 8:34
Till: pgsql-general
Ämne: idle_in_transaction_session_timeout
Hi,
I have postgres 9.5 version running on my machine.
When I am
24 matches
Mail list logo
