# -  - #
# -  - #


# -  - #
# - List containers on server - #
sudo docker ps;
sudo docker container ls;

# - Include not running containers - #
sudo docker ps -a;


# -  - #
# - Show docker images - #
sudo docker images;


# -  - #
# - Pull PostgreSQL image - #
sudo docker pull postgres;


# -  - #
# - Client only - #
sudo apt-get update;
sudo apt-get install postgresql-client postgresql-contrib postgresql-client-common;


# -  - #
# - Create database directory - #  

sudo mkdir -p /home/Data/postgresql_101
sudo mkdir -p /home/Data/postgresql_102


# -  - #
# - Create & run PostgreSQL container - #
sudo docker run -d \
    --name PostgreSQL_101 \
    --network is_network \
    --restart always \
    -e POSTGRES_PASSWORD="Administrator2" \
    -v /home/Data/postgresql_101:/var/lib/postgresql/data  \
    -p 8310:5432 \
    postgres;


sudo docker run -d \
    --name PostgreSQL_102 \
    --network is_network \
    --restart always \
    -e POSTGRES_PASSWORD="Administrator2" \
    -v /home/Data/postgresql_102:/var/lib/postgresql/data  \
    -p 8313:5432 \
    postgres;


# -  - #
# - Checkout logs - #
sudo docker logs PostgreSQL_101;


# -  - #
# -  Find the IP of the container “IPAddress”- #
sudo docker inspect PostgreSQL_101;


sudo psql -U postgres -d postgres -h 192.168.1.101;
sudo -u postgres psql -d postgres -h 192.168.1.101;

sudo -u postgres psql -d postgres -h 192.168.1.101 -p 8310;



# -  - #
# - Create admin user - #
CREATE ROLE is_derayo WITH LOGIN PASSWORD 'Administrator2' SUPERUSER CREATEROLE CREATEDB REPLICATION BYPASSRLS;
ALTER USER is_derayo WITH SUPERUSER CREATEROLE CREATEDB REPLICATION BYPASSRLS;
GRANT ALL PRIVILEGES ON DATABASE postgres TO is_derayo;
GRANT ALL ON ALL TABLES IN SCHEMA public TO is_derayo;
\q



# -  - #
# - Show databases - #
postgresql: \l

# -  - #
# - Show tables - #
postgresql: \d

# -  - #
# - Show columns - #
postgresql: \d table
postgresql: SELECT column_name FROM information_schema.columns WHERE table_name ='table';

# -  - #
# - Show columns - #
postgresql: \d+ table
postgresql: SELECT column_name FROM information_schema.columns WHERE table_name ='table';

CREATE DATABASE testdb;
CREATE DATABASE Accounting;


# -  - #
# - Preliminary tests - #
# - Connect to DB nextcloud - #
CREATE DATABASE db_test;
/c db_test;

CREATE SCHEMA friends;
CREATE TABLE friends.test( firstname CHAR(15), lastname CHAR(20) );
SELECT * from friends.test;
DROP TABLE friends.test;
DROP SCHEMA friends;

CREATE DATABASE db_test;
\c db_test;
CREATE SCHEMA friends;
CREATE TABLE friends.test( firstname CHAR(15), lastname CHAR(20) );


# -  - #
# - Show tables on schema friends - #
\dt friends.


# -  - #
# - Describe table on schema friends - #
\d friends.test;


# -  - #
# - Exit postgres - #
\q



# - 192.168.1.101/phppgadmin - #
SELECT * FROM information_schema.columns WHERE table_name = 'test';

# - Insert data - #
INSERT INTO friends.test values( 'Mike', 'Smith' );
SELECT * FROM friends.test;

INSERT INTO friends.test values( 'Enrique', 'Rayo' );
INSERT INTO friends.test values( 'Mario', 'Rivas' );
SELECT * FROM friends.test;


# -  - #
# - Stop container - #
sudo docker stop PostgreSQL_100;


# -  - #
# - Restart container - #
sudo docker restart PostgreSQL_100;


# -  - #
# - Remove container - #
sudo docker rm PostgreSQL_100;


# -  - #
# - Install phppgadmin on docker - #
sudo docker pull dockage/phppgadmin:latest




# -  - #
# - Create phppgadmin container - #

sudo docker run -d \
    --name phppgadmin_101 \
    --network is_network \
    --restart always \
    -e "DB_HOST=PostgreSQL_101" \
    -p 8080:80 \
    zhajor/docker-phppgadmin;



sudo docker run \
    -p 8000:80 \
    -e "POSTGRES_HOST=192.168.1.101" \
    -e "POSTGRES_NAME=Intranet" \
    -e "DB_PORT=5432" \
    turgon37/phppgadmin

sudo docker run -d \
    -p 12345:80 
    -e "DB_HOST=192.168.99.100" \
    -e "DB_PORT=5432" \
    --name=postg \
    zhajor/docker-phppgadmin

sudo docker run -d \
    -p 12345:80 \
    --link postgres-db:postgres-db \
    -e "DB_HOST=postgres-db" \
    -e "DB_PORT=5432" \
    --name=postg \
    zhajor/docker-phppgadmin

sudo docker run -d \
    --name=phppgadmin \
    dockage/phppgadmin:latest




# -  - #
# - Create & Run pgadmin container - #

sudo docker pull dpage/pgadmin4;


# -  - #
# - Create pgamin4 folder - #
sudo mkdir -p /home/Data/pgadmin4


sudo docker run \
    --name pgadmin_101 \
    --network is_network \
    --restart always \
    -p 8312:80 \
    -v /home/Data/pgadmin4:/var/lib/pgadmin \
    -e 'PGADMIN_DEFAULT_EMAIL=is_derayo@hotmail.com' \
    -e 'PGADMIN_DEFAULT_PASSWORD=Administrator2' \
    -e 'PGADMIN_CONFIG_ENHANCED_COOKIE_PROTECTION=True' \
    -e 'PGADMIN_CONFIG_LOGIN_BANNER="Authorised users only!"' \
    -e 'PGADMIN_CONFIG_CONSOLE_LOG_LEVEL=10' \
    -d dpage/pgadmin4;


    -v /private/var/lib/pgadmin:/var/lib/pgadmin \










# -  - #
# - Install pgadmin4 uServer - #

sudo apt install curl ca-certificates gnupg;
curl https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -

# - Create pgdg.list - #
sudo vim /etc/apt/sources.list.d/pgdg.list

# - Add to file - #
deb http://apt.postgresql.org/pub/repos/apt/ buster-pgdg main

sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'
sudo apt update && sudo apt upgrade;
sudo apt install pgadmin4 pgadmin4-apache2;