How to Install PostgreSQL on Linux

  Installation of PostgreSQL on Linux

In this article, you will learn how to install PostgreSQL on Linux using rpm packages. Most Linux platforms such as Debian, Oracle Linux, Red Hat / CentOS, SUSE, and Ubuntu have PostgreSQL integrated with their package management.

It is recommended that you install PostgreSQL this way since it ensures a proper integration with the operating system including automatic patching and other update management functionality.

In this tutorial, we’ll show you how to install PostgreSQL on Oracle Linux version 8.2

Installation using RPMS:

Below URL can be used to download rpms of PostgreSQL version 15.1 for Linux platforms.

https://download.postgresql.org/pub/repos/yum/15/redhat/rhel-8.2-x86_64/

For smooth installation, below listed rpms are required:

  • postgresql15-devel-15.1-1PGDG.rhel8.x86_64.rpm 
  • postgresql15-contrib-15.1-1PGDG.rhel8.x86_64.rpm 
  • postgresql15-libs-15.1-1PGDG.rhel8.x86_64.rpm
  • postgresql15-server-15.1-1PGDG.rhel8.x86_64.rpm 
  • postgresql15-15.1-1PGDG.rhel8.x86_64.rpm   

Ship these rpms to server where Linux is already installed. 
Now is the time to do the actual PostgreSQL installation. This will install the latest PostgreSQL version.
  1. Install libs rpm first as below::
    yum localinstall /tmp/postgresql15-libs-15.1-1PGDG.rhel8.x86_64.rpm

      2. Next, install PGDG package using below command:
    yum localinstall /tmp/postgresql15-15.1-1PGDG.rhel8.x86_64.rpm   

      3. At third step server package can be installed as below
   yum localinstall /tmp/postgresql15-server-15.1-1PGDG.rhel8.x86_64.rpm 
      4. Now devel package will be installed
    yum localinstall /tmp/postgresql15-devel-15.1-1PGDG.rhel8.x86_64.rpm 
      5. And at the last step, contrib package can be installed for additional extensions as below:
    yum localinstall /tmp/postgresql15-contrib-15.1-1PGDG.rhel8.x86_64.rpm 

      6. Once all rpm pacages are installed successfully, you can now safetly initialize PostgreSQL database using below command:

/usr/pgsql-15/bin/postgresql-15.1-setup initdb

     7. Next, start the PostgreSQL service and enable it to start at system reboot with the following command:

systemctl start postgresql-15.1

systemctl enable postgresql-15.1

    8. You can check the status of PostgreSQL with the following command:

systemctl start postgresql-15.1

    9. By default, PostgreSQL listens on port 5432. You can check it with the following command:

netstat -tulnp |grep 5432

Once installation is complete, you can access it using pgAdmin tool and any other GUI based tool like dbeaver.

For connecting it remotely, some configurations are required. Like changes in postgresql.conf file and pg_hba.conf files which by default can be found in "/var/lib/pgsql/15/data" directory.

Edit postgresql.conf file and comment listen_address directive and add new line as below:

listen_address='IP_ADDR_PG_SERVER"

Edit pg_hba.conf and add below lines:

host    all    postgres    CLIENT_IP_ADDR    trust

For making these changes effective, restart postgresql service as below:

systemctl restart postgresql-15.1

Now you can connect to your postgresql database using pgAdmin tool from your client machine


<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-6554968143327802"
     crossorigin="anonymous"></script>

Comments

Post a Comment

Popular posts from this blog

Ora2pg Mirgation Tool

Image
 Introduction Ora2pg tool is open source tool used for migration of oracle databases to PostgreSQL database. This tools works at schema level, meaning that it does not convert/ migrate whole oracle database to PostgreSQL, instead it converts/ migrates one schema at a time. Hence if you have a database having four different schema/ users, you have to run this tool for each schema separately.  Ora2pg can be used in variety of scenarios like severe engineering of oracle databases to migration of large scale databases, or migrating data of oracle tables to PostgreSQL. It is user friendly and does not require any expertise to migrate your oracle databases to PostgreSQL. It only requires some configurations in its two configuration files and then run couple of commands to migrate the oracle schema to PostgreSQL. Features Migrate schema which objects (tables, views etc). Export partitions and their sub-partitions. Export data of tables Support for exporting Oracle BLOB obje...
Read more

Oracle vs PostgreSQL Comparison

   The War has began Oracle Database is a commercial, proprietary multi-model database management system produced by Oracle Corporation, and the largest relational database management system (RDBMS) in the world. While Oracle remains the #1 database on the market, its popularity has steadily declined by over 18% since 2013. What’s causing this massive shift? This all is happening due to rise of open source databases. One database in particular is causing a huge dent in Oracle’s market share – open source PostgreSQL. When comparing the two solutions, things to consider are: How easier to use it is, How easily you can setup and administer database How much this database fulfills your requirements How much performance efficient it is How much you have to pay for it How much support is available over the internet How much availability it gives to you Is your data secure inside this database And many more….. Below table compares both databases feature wise and gives a good hint to ...
Read more