usr/pgsql-12/bin/postgresql-12-setup initdb Yum install postgresql12-server postgresql12 Pg_dump –compress=9 –create –port=5432 postgres > postgres_ Vi /etc/systemd/system/rviceĬd /data/postgres_upgrade/backup_postgres92/ The file is in /etc/systemd/system/rvice: We achieve this by changing the TCP port on which the database is listening. PostgreSQL should be running during the upgrade, but we also need to make sure that no daemons are accessing the database. Make sure to close all applications using Postgres(Tomcat – IdM). Mkdir /data/postgres_upgrade/backup_postgres12Ĭhown postgres:root /data/postgres_upgrade/backup_postgres92Ĭhown postgres:root /data/postgres_upgrade/backup_postgres12 Mkdir /data/postgres_upgrade/backup_postgres92 This how-to can also be used for production deployments, as the original data is not modified during the upgrade. The upgrade process in this article installs another PostgreSQL engine alongside the old one and migrates the data. In order for your database to be properly patched, secured, and have all the DB features your applications need, you are supposed to upgrade your database. I'm getting: sudo: postgresql-setup: command not found. Afterwards, when I try to initialize the PostgreSQL database: sudo postgresql-setup initdb. Then, contrib package for additional features: sudo dnf install postgresql-contrib. That’s a Tutorial for upgrading the PostgreSQL9 database on CentOS 7 server. Installing PostgreSQL 12: sudo dnf install postgresql:12. Share on Twitter Share on Facebook Share on LinkedIn
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |