postgresql

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
postgresql [2023/11/28 23:00] – [References] adminpostgresql [2026/03/08 18:07] (current) – admin
Line 3: Line 3:
 ==== Backup fuelwatcher on PROD ==== ==== Backup fuelwatcher on PROD ====
 <code bash> <code bash>
-docker exec -it FW_PostgreSQL /bin/bash+docker exec -it FT_PostgreSQL /bin/bash
 cd /var/lib/postgresql/data/backups/ cd /var/lib/postgresql/data/backups/
 pg_dump -d fuelwatcher > fuelwatcher_RPi64_`date +%Y-%m-%dT%H-%M-%S`.backup pg_dump -d fuelwatcher > fuelwatcher_RPi64_`date +%Y-%m-%dT%H-%M-%S`.backup
Line 10: Line 10:
 <code bash> <code bash>
 sudo su - sudo su -
-rsync -av /var/lib/docker/volumes/fw_stack_postgres-data/_data/backups/ /media/usb/backup/postgresql/backups/+rsync -av /var/lib/docker/volumes/fueltracker_postgres-data/_data/backups/ /media/usb/backup/postgresql/backups/
 </code> </code>
  
Line 17: Line 17:
 Login: Login:
 <code bash> <code bash>
-docker exec -it FW_PostgreSQL /bin/bash+docker exec -it FT_PostgreSQL /bin/bash
 su - postgres su - postgres
  
Line 28: Line 28:
 DROP DATABASE fuelwatcher; DROP DATABASE fuelwatcher;
  
-CREATE DATABASE fuelwatcher+CREATE DATABASE fueltracker
     WITH     WITH
     OWNER = postgres     OWNER = postgres
Line 40: Line 40:
 <code> <code>
 cd /var/lib/postgresql/data/backups/ cd /var/lib/postgresql/data/backups/
-pg_dump -d fuelwatcher > fuelwatcher_STONARD_`date +%Y-%m-%dT%H-%M-%S`.backup +pg_dump -d fueltracker > fueltracker_FALKREATH_`date +%Y-%m-%dT%H-%M-%S`.backup 
-psql -d fuelwatcher < fuelwatcher_RPi64_2021-08-01T05-23-25.backup+psql -d fuelwatcher < fueltracker_RPi64_2021-08-01T05-23-25.backup
 </code> </code>
  
Line 47: Line 47:
 <code bash> <code bash>
 pg_dumpall > dev-container_devcontainer_db_1_all_`date +%Y-%m-%dT%H-%M-%S`.backup pg_dumpall > dev-container_devcontainer_db_1_all_`date +%Y-%m-%dT%H-%M-%S`.backup
-cd /workspace/fuelwatcher/data/STONARD\ backups/ +cd /workspace/FuelTracker/data/STONARD\ backups/ 
-cd /workspace/fuelwatcher/data/RPi-WiFi\ backups/+cd /workspace/FuelTracker/data/RPi-WiFi\ backups/
 </code> </code>
 ===== Data Dictionary export ===== ===== Data Dictionary export =====
 For comparison between PROD and DEV. Perform on both: For comparison between PROD and DEV. Perform on both:
 <code bash> <code bash>
-pg_dump -Cs fuelwatcher > /workspace/FuelWatcher/backups/fuelwatcher_STONARD_`date +%Y-%m-%dT%H-%M-%S`.bak+pg_dump -Cs fueltracker > /workspace/FuelTracker/backups/fueltracker_FALKREATH_`date +%Y-%m-%dT%H-%M-%S`.bak
 </code> </code>
 ===== Version upgrade ===== ===== Version upgrade =====
  • postgresql.1701183627.txt.gz
  • Last modified: 2023/11/28 23:00
  • by admin