![]() check consistency between the two versions (again, as postgres user):.usr/pgsql-11/bin/initdb -D /var/lib/pgsql/11/data" initialize the new data directory, note that you need to do this as postgres user:. ![]() ![]() stop and disable the older version service.Yum install postgresql11 postgresql11-contrib postgresql11-devel postgresql11-libs postgresql11-server enable repository with the new version, as I was on Centos, I followed the instructions from here.If that’s not possible, however, because you don’t have enough space on your system, you can use –link parameter that makes pg_upgrade tool reclaim the old directory as its own. This is usually more safe as you can go back to the older postgresql version if something went wrong the old data directory is till intact. The only problem there was that the database in question had bloated over the years to such an extent that it was not possible to have two separate data directories for both versions, 9.3 and 11, which is the normal way to go about this – you install the newer version, run pg_upgrade tool against the old data directory and it takes the data, converts them to the new format and saves them in a new directory of the newly installed postgresql version. Luckily, this process is quite straightforward and all the hard lifting is done by the postgresql update tool. I had to update an already unsupported Postgresql instance running on version 9.3 to the latest version 11.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |