Pgwatch2: erinevus redaktsioonide vahel
Allikas: Imre kasutab arvutit
Mine navigeerimisribaleMine otsikasti
Resümee puudub |
Resümee puudub |
||
6. rida: | 6. rida: | ||
TODO |
TODO |
||
+ | |||
+ | ====pgwatch paigaldamine==== |
||
<pre> |
<pre> |
||
46. rida: | 48. rida: | ||
# docker compose up -d |
# docker compose up -d |
||
+ | |||
+ | ====nginx paigaldamine==== |
||
+ | |||
+ | <pre> |
||
+ | # cat docker-compose.yml |
||
+ | version: '2' |
||
+ | |||
+ | services: |
||
+ | svc_nginx: |
||
+ | image: nginx |
||
+ | ports: |
||
+ | - "443:443" |
||
+ | |||
+ | container_name: dc_nginx |
||
+ | |||
+ | networks: |
||
+ | - nw_nginx |
||
+ | |||
+ | volumes: |
||
+ | - '/srv/nginx/volumes/etc/nginx/nginx.conf:/etc/nginx/nginx.conf' |
||
+ | - '/srv/nginx/volumes/etc/nginx/conf.d/default.conf:/etc/nginx/conf.d/default.conf' |
||
+ | - '/srv/nginx/volumes/etc/ssl/localcerts/cert.pem:/etc/ssl/localcers/cert.pem' |
||
+ | - '/srv/nginx/volumes/etc/ssl/localcerts/key.pem:/etc/ssl/localcers/key.pem' |
||
+ | |||
+ | networks: |
||
+ | nw_nginx: |
||
+ | </pre> |
||
+ | |||
+ | ====Paketifiltriga ligipääsu piiramine==== |
||
+ | |||
+ | <pre> |
||
+ | root@vis3-pgw-01:/srv/nginx/dc# iptables -I DOCKER-USER -p tcp -s 0.0.0.0/0 --dport 3000 -j REJECT |
||
+ | root@vis3-pgw-01:/srv/nginx/dc# iptables -I DOCKER-USER -p tcp -s 0.0.0.0/0 --dport 8080 -j REJECT |
||
+ | </pre> |
||
====Uuendamine==== |
====Uuendamine==== |
Redaktsioon: 19. veebruar 2023, kell 01:05
Sissejuhatus
TODO
Tööpõhimõte
TODO
pgwatch paigaldamine
# cd /srv/pgwatch2 # cat dc/docker-compose.yml version: '2' services: service_pgwatch2: image: cybertec/pgwatch2-postgres:latest ports: - "3000:3000" - "8080:8080" - "8081:8081" container_name: dc_pgwatch2 networks: - nw_pgwatch2 volumes: - '/srv/pgwatch2/volumes/pgwatch2/persistent-config:/pgwatch2/persistent-config' - '/srv/pgwatch2/volumes/var/lib/postgresql:/var/lib/postgresql' - '/srv/pgwatch2/volumes/var/lib/grafana:/var/lib/grafana' - '/srv/pgwatch2/volumes/etc/grafana/grafana.ini:/etc/grafana/grafana.ini' networks: nw_pgwatch2:
Enne käivitamist tuleb tekitada volume ressusidele vastavad kataloogi dockerhost failisüsteemi
# cd /srv/pgwatch2/volumes # mkdir -p pgwatch2/persistent-config var/lib/postgresql var/lib/grafana etc/grafana # chmod 0777 pgwatch2/persistent-config var/lib/postgresql var/lib/grafana etc/grafana
Esmaseks käivitamiseks sobib öelda
# docker compose up -d
nginx paigaldamine
# cat docker-compose.yml version: '2' services: svc_nginx: image: nginx ports: - "443:443" container_name: dc_nginx networks: - nw_nginx volumes: - '/srv/nginx/volumes/etc/nginx/nginx.conf:/etc/nginx/nginx.conf' - '/srv/nginx/volumes/etc/nginx/conf.d/default.conf:/etc/nginx/conf.d/default.conf' - '/srv/nginx/volumes/etc/ssl/localcerts/cert.pem:/etc/ssl/localcers/cert.pem' - '/srv/nginx/volumes/etc/ssl/localcerts/key.pem:/etc/ssl/localcers/key.pem' networks: nw_nginx:
Paketifiltriga ligipääsu piiramine
root@vis3-pgw-01:/srv/nginx/dc# iptables -I DOCKER-USER -p tcp -s 0.0.0.0/0 --dport 3000 -j REJECT root@vis3-pgw-01:/srv/nginx/dc# iptables -I DOCKER-USER -p tcp -s 0.0.0.0/0 --dport 8080 -j REJECT
Uuendamine
TODO
Paigaldamine
TODO
Kasutamine - andmebaasi ettevalmistamine jälgimiseks
TODO
Kasutamine - kogutud andmetega töötamine
TODO
Kasulikud lisamaterjalid
- TODO