How to install PostgreSQL and PhpPgAdmin on OpenSUSE leap 42.3

To install PostgreSQL and PhpPgAdmin on OpenSUSE leap 42.3

PostgreSQL is a powerful high-performance, object-relational database management system (ORDBMS). It is well suited for large databases and has quite large advanced features. It supports many OS that includes Linux, FreeBSD, Solaris and Microsoft Windows. And PhpPgAdmin is a PHP-based web application, used for managing PostgreSQL databases. It is easy to create a database, create a role and create tables in Postgres. In this tutorial, you will learn about the method to install PostgreSQL and PhpPgAdmin on OpenSUSE leap 42.3

Installing PostgreSQL

First, you need to install PostgreSQL by making use of the following command.

linuxhelp:~ # zypper in postgresql94 postgresql94-contrib postgresql94-server
Retrieving repository ' openSUSE-Leap-42.3-Update'  metadata .......................................................................................................................[done]
Building repository ' openSUSE-Leap-42.3-Update'  cache ............................................................................................................................[done]
Retrieving repository ' openSUSE-Leap-42.3-Update-Non-Oss'  metadata ...............................................................................................................[done]
Building repository ' openSUSE-Leap-42.3-Update-Non-Oss'  cache ....................................................................................................................[done]
Loading repository data...
Reading installed packages...
Resolving package dependencies...
The following 5 NEW packages are going to be installed:
  libpq5 postgresql-init postgresql94 postgresql94-contrib postgresql94-server
.
.
.
.
(2/5) Installing: libpq5-9.6.4-6.1.x86_64 ........................................................................................................................................[done]
(3/5) Installing: postgresql94-9.4.13-12.1.x86_64 ................................................................................................................................[done]
(4/5) Installing: postgresql94-server-9.4.13-12.1.x86_64 .........................................................................................................................[done]
(5/5) Installing: postgresql94-contrib-9.4.13-12.1.x86_64 ........................................................................................................................[done]

Once it is installed, you need to start and enable the PostgreSQL service.

linuxhelp:~ # systemctl start postgresql.service 

And then, you need to configure the default by making use of the following command.

linuxhelp:~ # su - postgres
postgres@www:~>  psql
psql (9.4.13)
Type " help"  for help.

Execute the following command to change the password for postgres.

 postgres=# passwd postgres
Invalid command passwd. Try ? for help.
postgres=# password postgres
Enter new password: 
Enter it again: 
postgres=# 
postgres=# q
Leave the postgres user to switch over as root user.
postgres@www:~>  exit
logout

Then create a new PostgreSQL User by making use of the following command.

linuxhelp:~ # su - postgres
postgres@www:~>  createuser -s nano
You can also create a database in the following manner. 
postgres@www:~>  createdb nano_db

Get into your PSQL terminal and give the password for the new user. Also, grant all the privileges.

postgres@www:~>  psql
psql (9.4.13)
Type " help"  for help.
postgres=# alter user nano with encrypted password ' 123'  
ALTER ROLE
postgres=# grant all privileges on database nano_db to nano 
GRANT
postgres=# q
postgres@www:~>  exit

Now, you need to check the configuration of PostgreSQL file. Open the .conf file as follows.

linuxhelp:~ # cd /var/lib/pgsql/
linuxhelp:/var/lib/pgsql # cd data/
linuxhelp:/var/lib/pgsql/data # vim postgresql.conf
Uncomment line 59, and make the following changes in the appropriate places. 
listen_addresses = ' *' 
port = 5432

Allow access by opening the pg_hba.conf file.

linuxhelp:/var/lib/pgsql/data # vim pg_hba.conf

Also once the changes are done, you shall restart the Postgresql service. And also check its status.

linuxhelp:/var/lib/pgsql/data # systemctl restart postgresql.service 
linuxhelp:/var/lib/pgsql/data # systemctl status postgresql.service 

Installing PHPPgAdmin

You shall now install phpPgAdmin by making use of the following command.

linuxhelp:/var/lib/pgsql/data # zypper in phpPgAdmin
Loading repository data...
Reading installed packages...
Resolving package dependencies...
The following 2 NEW packages are going to be installed:
  php7-pgsql phpPgAdmin
2 new packages to install.
Overall download size: 692.9 KiB. Already cached: 0 B. After the operation, additional 3.1 MiB will be
used.
Continue? [y/n/...? shows all options] (y): y
Retrieving package php7-pgsql-7.0.7-22.1.x86_64                    (1/2), 103.6 KiB (183.6 KiB unpacked)
Retrieving: php7-pgsql-7.0.7-22.1.x86_64.rpm .....................................................[done]
Retrieving package phpPgAdmin-5.1-10.1.noarch                      (2/2), 589.3 KiB (  2.9 MiB unpacked)
Retrieving: phpPgAdmin-5.1-10.1.noarch.rpm .......................................................[done]
Checking for file conflicts: .....................................................................[done]
(1/2) Installing: php7-pgsql-7.0.7-22.1.x86_64 ...................................................[done]
(2/2) Installing: phpPgAdmin-5.1-10.1.noarch .....................................................[done]

Once it is done, you shall open the phpPgAdmin configuration file.

linuxhelp:/var/lib/pgsql/data # cd /etc/phpPgAdmin/
linuxhelp:/etc/phpPgAdmin # vim config.inc.php 

You can now enable the PHP of your installed version.

linuxhelp:/etc/phpPgAdmin # a2enmod php7
linuxhelp:/etc/phpPgAdmin # a2enmod version

Again now, enable your PostgreSQL and Apache services.

linuxhelp:/etc/phpPgAdmin # systemctl restart postgresql
linuxhelp:/etc/phpPgAdmin # systemctl restart apache2

Now, go to the browser and give your domain as the URL. In the phpPgAdmin, choose the language and theme.

And then, enter the login credentials and proceed.

With this, the installation of both PostgreSQL and PhpPgAdmin on OpenSUSE leap 42.3 comes to an end.