postgresql

#
rm -f ./Dockerfile
wget https://raw.githubusercontent.com/grafana/grafana/main/packaging/docker/custom/Dockerfile
printf "\nENV GF_SERVER_HTTP_PORT=3002\n" >> ./Dockerfile
printf "\nEXPOSE 3002\n" >> ./Dockerfile
#
docker build -t test-grafana:custom --build-arg "GF_INSTALL_PLUGINS=grafana-piechart-panel" -f Dockerfile .
#

====

https://hub.docker.com/_/postgres
https://stackoverflow.com/questions/37775702/changing-a-postgres-containers-server-port-in-docker-compose
https://stackoverflow.com/questions/37694987/connecting-to-postgresql-in-a-docker-container-from-outside

https://yum.postgresql.org/14/redhat/rhel-7-x86_64/repoview/postgresql14-libs.html

https://stackoverflow.com/questions/15100368/postgresql-port-confusion-5433-or-5432

===> POSTGRESQL:

ls -al
sudo rm -rf /etc/postgresql-dockdata/
sudo mkdir  /etc/postgresql-dockdata/
sudo chmod -R 777 /etc/postgresql-dockdata/
sync
docker run -v /etc/postgresql-dockdata/:/var/lib/postgresql/data/ --name logger -e POSTGRES_HOST=localhost -e POSTGRES_DB=logger -e POSTGRES_PORT=5433 -e POSTGRES_USER=logger -e POSTGRES_PASSWORD=logger -e PGPORT=5433 -d -p 5433:5433 postgres:alpine
ls -al

===> GRAFANA:

ls -al
sudo rm -rf /etc/grafana-dockdata/
sudo mkdir  /etc/grafana-dockdata/
sudo mkdir  /etc/grafana-dockdata/etc_grafana/
sudo touch  /etc/grafana-dockdata/etc_grafana/grafana.ini
sudo mkdir  /etc/grafana-dockdata/etc_grafana/provisioning/
sudo mkdir  /etc/grafana-dockdata/etc_grafana/provisioning/dashboards/
sudo mkdir  /etc/grafana-dockdata/etc_grafana/provisioning/datasources/
sudo mkdir  /etc/grafana-dockdata/etc_grafana/provisioning/plugins/
sudo mkdir  /etc/grafana-dockdata/etc_grafana/provisioning/notifiers/
sudo mkdir  /etc/grafana-dockdata/var_lib_grafana/
sudo mkdir  /etc/grafana-dockdata/var_log_grafana/
sudo mkdir  /etc/grafana-dockdata/var_lib_grafana-plugins/
sudo chmod -R 777 /etc/grafana-dockdata/
sync
docker run -v /etc/grafana-dockdata/etc_grafana/:/etc/grafana/ -v /etc/grafana-dockdata/var_lib_grafana/:/var/lib/grafana/ -v /etc/grafana-dockdata/var_log_grafana/:/var/log/grafana/ -v /etc/grafana-dockdata/var_lib_grafana-plugins/:/var/lib/grafana-plugins/ --name=grafana -e GF_INSTALL_PLUGINS=grafana-piechart-panel -e GF_SERVER_HTTP_PORT=3002 -d -p 3002:3002 grafana/grafana-oss:latest
ls -al

https://community.grafana.com/t/grafana-docker-and-data-persistence/33702

===

docker exec -it <container_id> bash

nano /var/lib/postgresql/data/postgresql.conf

port 5433

Ctrl+P , Ctrl+Q

docker stop <container_id>
docker start <container_id>

psql -U logger -h localhost -p 5433 -d logger
\connect logger # connect
\connect postgres # disconnect by connecting to another database
\list # list databases

grafana account:
admin - admin

=== CONNECT BOTH CONTAINERS TO EACH OTHER ===

docker network create myNetwork
docker network connect myNetwork grafana # or container ID
docker network connect myNetwork logger  # or container ID
docker network inspect myNetwork

===

EXPORT : pg_dump -U logger logger -f logger_date.sql
https://grafana.com/docs/grafana/latest/dashboards/export-import/
IMPORT : psql -h 127.0.0.1 -p 5433 -d logger -U logger -f logger_date.sql