✎ postgresql [It's in The Wiki]

You've loaded an old revision of the document! If you save it, you will create a new version with this data.

===== 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>

Edit summary