Show pageOld revisionsBacklinksAdd to bookExport to PDFBack to top You've loaded an old revision of the document! If you save it, you will create a new version with this data. Media Files===== DEV refresh ===== ==== Backup fuelwatcher on PROD ==== <code> docker exec -it FW_PostgreSQL /bin/bash cd /var/lib/postgresql/data/backups/ pg_dump -d fuelwatcher > fuelwatcher_all_`date +%Y-%m-%dT%H-%M-%S`.backup </code> Login to root: <code> sudo su - cd /var/lib/docker/volumes/fw_stack_postgres-data/_data/backups/ rsync -av /var/lib/docker/volumes/fw_stack_postgres-data/_data/backups/ /media/usb/backup/postgresql/backups/ </code> Copy backup to STONARD with MobaXterm Copy backup to Container with beyond Compare (backups <--> RPi-WiFi backups) ==== Restore on DEV ==== Login: <code> docker exec -it dev-container_devcontainer_db_1 /bin/bash su - postgres </code> DROP and CREATE DATABASE <code> DROP DATABASE fuelwatcher; CREATE DATABASE fuelwatcher WITH OWNER = postgres ENCODING = 'UTF8' LC_COLLATE = 'en_US.utf8' LC_CTYPE = 'en_US.utf8' TABLESPACE = pg_default CONNECTION LIMIT = -1; </code> Backup DEV then Restore PROD to DEV: <code> cd /var/lib/postgresql/data/backups/ pg_dump -d fuelwatcher > fuelwatcher_all_`date +%Y-%m-%dT%H-%M-%S`.backup psql -d fuelwatcher < fuelwatcher_all_2021-08-01T05-23-25.backup </code> TMP <code> pg_dumpall > dev-container_devcontainer_db_1_all_`date +%Y-%m-%dT%H-%M-%S`.backup cd /workspace/fuelwatcher/data/STONARD\ backups/ cd /workspace/fuelwatcher/data/RPi-WiFi\ backups/ </code> <code> </code> SavePreviewCancel Edit summary postgresql.1627797014.txt.gz Last modified: 2021/08/01 13:50by admin