This is a very important security measurement since you want only the created user to have the ability to access your data in the database. In this step, you are going to prepare your server before you start the installation of PostgreSQL 14 such as group and user that you want to specifically assign permission to work only with Postgresql. Therefore, we have to install those packages first as the following command sudo apt-get update There are some dependent packages such as gcc, zlib1g as a prerequisite to installing PostgreSQL. You can download using the wget command as following wget STEP 1: Download Source from PostgreSQL websiteįirst, you have to download the source code of new released PostgreSQL 14 from the official website here. In this experiment, we are going to use Google Cloud Engine (Similar to AWS EC2 or Digital Ocean Droplet) to perform it. Now, let's start to fresh source installation of PostgreSQL 14 on ubuntu 20.04. If you are using PostgreSQL with cloud providers such as Amazon Web Services or Digital Oceans you may have to wait for their update or you can check with their support in order to get at least the planned upgrade date. This release was highly recommended to upgrade especially for large, high-connection-count sites such as bank or telecom sector. In this release, there are no huge gigantic features but there are many small things that will make your task better and easier. PostgreSQL 14 has been officially released on 30 September 2021 with hundreds of improvements, fixes, and changes that have been mentioned in the release note on their official website.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |