postgresql

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
postgresql [2023/11/28 12:43] – 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 =====
Line 89: Line 89:
  
 ===== References ===== ===== References =====
-How to Upgrade Your PostgreSQL Passwords to SCRAM - https://blog.crunchydata.com/blog/how-to-upgrade-postgresql-passwords-to-scram+[[https://www.postgresqltutorial.com/postgresql-administration/postgresql-restore-database/|PostgreSQL Restore Database]]
  
-Postgres dump database schema with or without data - https://www.chrisnewland.com/postgres-dump-database-schema-with-or-without-data-61+[[https://blog.crunchydata.com/blog/how-to-upgrade-postgresql-passwords-to-scram|How to Upgrade Your PostgreSQL Passwords to SCRAM ]] 
 + 
 +[[https://www.chrisnewland.com/postgres-dump-database-schema-with-or-without-data-61|Postgres dump database schema with or without data]]
  
 [[https://www.commandprompt.com/education/postgresql-basic-psql-commands/|PostgreSQL: Basic psql Commands]] [[https://www.commandprompt.com/education/postgresql-basic-psql-commands/|PostgreSQL: Basic psql Commands]]
 +
 +[[https://www.kostolansky.sk/posts/upgrading-to-postgresql-15/|How to upgrade PostgreSQL from 14 to 15]]
  • postgresql.1701146627.txt.gz
  • Last modified: 2023/11/28 12:43
  • by admin