Hi everyone,
Is there is any option to perform logical decoding on an active replication
slot.
I'm trying to decode a replication slot but it throughs an error as below.
ERROR: replication slot "my_sub" is active for PID 2525720
On Wed, 19 Feb 2025 at 16:49, Csányi Pál wrote:
> Indeed I did, the trigger should have been assigned on
> javaink_forgalma table, not on havonkenti_megtakaritasaink table.
> Actually, this trigger has been assigned on both tables so far, and I
> just deleted it from the havonkenti_megtakaritasai
Sándor Daku ezt írta (időpont: 2025. febr.
19., Sze, 17:09):
>
>
>
> On Wed, 19 Feb 2025 at 16:49, Csányi Pál wrote:
>>
>> Indeed I did, the trigger should have been assigned on
>> javaink_forgalma table, not on havonkenti_megtakaritasaink table.
>> Actually, this trigger has been assigned on bot
On 2/19/25 05:22, Schmid Andreas wrote:
-Ursprüngliche Nachricht-
Well, according to the last comment below the Stack Overflow question, it was
about installing 17.3 with a v14 cluster already present.
Anyways, I now tried on an Ubuntu 24.04 machine as well, and installing 17.3
alon
Laurenz Albe ezt írta (időpont: 2025. febr.
19., Sze, 12:22):
>
> On Wed, 2025-02-19 at 11:23 +0100, Csányi Pál wrote:
> > I am running postgresql 15 on Debian 12 operating system.
> > I also installed PgAdmin4 and am using the desktop version of it.
> > I have created a trigger function and a tri
You should ask on the pgsql-pkg-debian mailing list, that's where
the packager is listening.
Yours,
Laurenz Albe
--
*E-Mail Disclaimer*
Der Inhalt dieser E-Mail ist ausschliesslich fuer den
bezeichneten Adressaten bestimmt. Wenn Sie nicht der vorgesehene Adressat
dieser E-Mail oder dessen Ver
On 2025-Feb-19, Schmid Andreas wrote:
> Maybe there generally is no cluster created if there is one present
> already. I now checked
> /usr/share/postgresql-common/maintscripts-functions which is installed
> by the postgresql-common_273.pgdg24.04+1_all.deb package. This script
> contains the creat
Not related to the main question, but that query could use a little
adjustment. Something like:
WITH x AS (
select kelt from javaink_forgalma
where en_kaptam is true and az_aru_neve = 'nyugdíjam'
order by kelt desc limit 2
)
,y AS (select min(kelt) from x)
,z AS (select max(kelt) from x)
INS
> -Ursprüngliche Nachricht-
> On Wed, 2025-02-19 at 08:45 +, Schmid Andreas wrote:
> > I'm trying to install the postgresql-17 Debian package from PGDG apt
> > repo alongside an already existing PostgreSQL 16 installation. So
> > there is already a PostgreSQL 16 cluster on my machine (w
On Wed, 2025-02-19 at 11:23 +0100, Csányi Pál wrote:
> I am running postgresql 15 on Debian 12 operating system.
> I also installed PgAdmin4 and am using the desktop version of it.
> I have created a trigger function and a trigger which will run the
> following code, see below.
> Before this trigge
Hi,
I am running postgresql 15 on Debian 12 operating system.
I also installed PgAdmin4 and am using the desktop version of it.
I have created a trigger function and a trigger which will run the
following code, see below.
Before this trigger would run, I tried this code.
When running the code I ge
On Wed, 2025-02-19 at 08:45 +, Schmid Andreas wrote:
> I'm trying to install the postgresql-17 Debian package from PGDG apt repo
> alongside an already existing PostgreSQL 16 installation. So there is
> already a PostgreSQL 16 cluster on my machine (which I want to upgrade
> to version 17 using
Hi
I'm trying to install the postgresql-17 Debian package from PGDG apt repo
alongside an already existing PostgreSQL 16 installation. So there is already a
PostgreSQL 16 cluster on my machine (which I want to upgrade to version 17
using the pg_upgrade command later on).
If I'm not wrong, the
13 matches
Mail list logo
