Hi,
We have an application currently running on PostgreSQL 12, partitioned as
shown below. Database size is approx. 1.4TB. We are now in the process of
upgrading the application, using PostgreSQL 15. In the new version, there
is an optional step to implement 'primary key' on history table.
In the
Hi all,
We are currently running Zabbix 5.0 with PostgreSQL 12, and history and
trend data partitioning.
History and trend data housekeeping has been disabled in Zabbix.
In the PostgreSQL logs, we get the following error:
2023-12-06 09:12:47 CET [3509536-5] zabbix@postgres STATEMENT: select
curr
/23 04:21, Arne Henrik Segtnan wrote:
> >
> > Hi all,
> >
> > We are currently running Zabbix 5.0 with PostgreSQL 12, and history and
> > trend data partitioning.
> > History and trend data housekeeping has been disabled in Zabbix.
> >
> > In the Postgr
Hi,
When trying to upgrade from PostgreSQL 10 to 12, the installation fails as
shown below.
# pg_upgradecluster --link --method=upgrade 10 main /dbdata/zabbix
From PosgreSQL log:
2021-05-04 13:06:04.780 CEST [12861] LOG: database system is ready to accept
connections
done
server started
Hi,
Thanks a lot for the feedback, which actually solved the problem. After
executing the below command, upgrade from 10 to 12 worked perfectly fine.
pgsqldb=# DROP EXTENSION pg_repack CASCADE;
Med vennlig hilsen / Best regards,
___
Arne Henrik Segtnan
> 4. mai 2
