Drop database and then restore (Postgresql 10.4.0):

1. su as postgres

2. run psql at command prompt

3. First, find the activities that are taken place against the target database, you can query the pg_stat_activity view with the following query:

SELECT
 *
FROM
 pg_stat_activity
WHERE
 datname = 'target_database';

4. Second, terminate the active connections by issuing the following query:

SELECT
 pg_terminate_backend (pg_stat_activity.pid)
FROM
 pg_stat_activity
WHERE
 pg_stat_activity.datname = 'target_database';

5. Third, execute the DROP DATABASE statement:

DROP DATABASE target_database;

6. Create database:

CREATE DATABASE target_database;

7. Copy file from host to docker container:

docker cp src/. mycontainer:/target

8. Go into docker container and restore database:

docker container exec -it mycontainer bash
su postgres
psql target_database < infile

That's all folks!

After Jenkins successfully shutdown, my Gitlab CE is now using port 8080 so I need to shut it down also to make way for my WildFly Application Server.  Command issued to shutdown Gitlab CE are as follows:

1.  su as root

2. At command prompt: gitlab-ctl stop

Referred from here: https://docs.gitlab.com/omnibus/maintenance/

That's all folks!

My Jenkins Server automatically starts upon Centos 7 server starts, so I need to stop it to make way for my WildFly Application Server.  What I did to stop it are as follows:

1. On my Firefox browser, go to this url : http://localhost:8080/exit

2. It will ask me to login then i have to click some button to initiate the shutdown process

I saw someone also asking about the same thing at stackoverflow: https://stackoverflow.com/questions/10238604/how-to-shutdown-my-jenkins-safely/35922474

It's that easy folks!

Install PgAdmin4 on Centos 7

Install PgAdmin4 on Centos7

PgAdmin4 is GUI Tool to manage PostgreSQL database.  I have a problem installing the latest PgAdmin4 which is v3.2 in Windows 10 on my HP EliteBook x360 so I made the decision to install it on my VMware Virtualised Centos 7 server.
This is what I did to install PgAdmin4 on Centos 7:

1. Get the yum repository installed on my server

• Get the yum repo rpm
  
  wget -v https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-centos96-9.6-3.noarch.rpm
  
  Get the rpm location from https://yum.postgresql.org/repopackages.php

• Install the yum repo
  
  sudo rpm -ivh pgdg-centos96-9.6-3.noarch.rpm

• Install PgAdmin4
  
  sudo yum -y install pgadmin4

• Configure PgAdmin4
  
  cd /usr/pgadmin4/bin/
  
  su
  
  
  ./pgadmin4-web-setup.sh
  
  
  NOTE: Configuring authentication for SERVER mode.
  Enter the email address and password to use for the initial pgAdmin user account: Email address: edyzairani@gmail.com
  Password:
  Retype password:
  pgAdmin 4 - Application Initialisation
  ====================================== We can now configure the Apache Web server for you. This will create the pgAdmin4 conf file under /etc/httpd/conf.d/. Do you wish to continue?
  1) Yes
  2) No
  #? 1 pgAdmin4 Apache config file is created as /etc/httpd/conf.d/pgadmin4.conf
  Apache web server is not running. We can start the web server for you to finish pgAdmin4 installation. Would you like to continue?
  1) Yes
  2) No
  #? 1
  Apache successfully started. You can now start using pgAdmin4 in web mode

2. Install PgAdmin4 Desktop Gnome

    sudo yum -y install pgadmin4-desktop-gnome

That's all folks.
Fyi, I referred to https://people.planetpostgresql.org/devrim/index.php?/archives/96-Installing-pgAdmin4-3.X-on-RHEL-CentOS-7-and-Fedora-27.html for this.