Lars Lingner (aa318d92) at 28 Mar 10:39
Lars Lingner (aa318d92) at 28 Mar 10:39
Upgrade to PostgreSQL 16
For new container I'd like to use the newest version. For the still in use DBs I need to do an upgrade, dump the DB and restore it. This will take some time depending on how large a DB is.
Is the idea to do this already for the 24.01
release, or do we do this for the 24.07
, when we also have a lot of changes in the database structure?
Lars Lingner (aa318d92) at 26 Mar 14:49
Upgrade to PostgreSQL 16
Chances that changing just the server version is working are low, probably some upgrade to the pg_data directory needs to be run. I would propose the following steps:
docker exec -it pg-13-container-id /usr/bin/pg_dumpall -U postgres > /path/to/db_backup.dump
(running inside old container)docker exec -it pg-14-container-id /usr/bin/psql -U postgres < /path/to/db_backup.dump
inside running new containerUsing pg_dumpall usually everything necessary (db schema, users, permissions,...) is dumped. You don't need to create the database(s) or anything else first. But if this isn't working I would do it step by step, pg_dumpall --roles-only, then --schema_only, then --data-only to create separate dump-files. Import them one by one and see where it crashes. But first try dumping everything in one go.
That way we will have a backup file in case something goes wrong. If something goes wrong -> find the issue, fix it and redo until nothing goes wrong.
@gislars we can use AMQP to send triggers to Rabotnik from the database. However, we need Postgresql 14 for that and currently 13 is installed. Do you think that would be a problem? Are we able to just change a version while the data stays?
Laurens Oostwegel (3037052a) at 20 Sep 14:30
Add AMQP plugin
Laurens Oostwegel (45366663) at 20 Sep 14:21
Add amqp - checkmark
Laurens Oostwegel (7dfd14c9) at 20 Sep 14:19
Add amqp - checkmark
Laurens Oostwegel (5aa08153) at 20 Sep 14:02
Add amqp - checkmark
Laurens Oostwegel (77b9f710) at 20 Sep 13:55
Add AMQP plugin
Laurens Oostwegel (560f280f) at 20 Sep 13:53
Add AMQP plugin
Laurens Oostwegel (3f5ca1d6) at 20 Sep 13:50
Add AMQP plugin