Lewati ke konten utama

PostgreSQL

Ubah Password​

ALTER USER casaos WITH PASSWORD 'new-password';

Docker Bash PostgreSQL​

sudo docker exec -it postgresql bash
  • Langsung ke container username postgres dan directory ~/data
sudo docker exec -it --user postgres postgresql bash -c "cd ~/data && exec bash"

CasaOS Default​

psql --username=casaos

Menampilkan Daftar Database​

  • Lengkap
\list
  • Singkatan:
\l

Keluar dari username sekarang​

\q

Backup Database​

pg_dump --host=127.0.0.1 --port=5432 --dbname=pondokmbodo --username=pondokmbodo --verbose --format=plain --file=pondokmbodo_backup.sql --password
pg_dump --host=90.90.90.90 --port=5432 --dbname=pondokmbodo --username=pondokmbodo --verbose --format=plain --file=pondokmbodo_backup.sql --password
pg_dump -h 90.90.90.90 -U pondokmbodo -d pondokmbodo -F c -b -v -f mydatabase.backup

Restore Database​

psql --username=casaos
DROP DATABASE IF EXISTS pondokmbodo_staging;
CREATE DATABASE pondokmbodo_staging OWNER pondokmbodo;
psql --host=127.0.0.1 --port=5432 --dbname=pondokmbodo_staging --username=pondokmbodo --file=pondokmbodo_backup.sql --password
psql --host=90.90.90.90 --port=5432 --dbname=pondokmbodo_restore --username=pondokmbodo --file=pondokmbodo_backup.sql --password
pg_restore -h 90.90.90.90 -U pondokmbodo -d pondokmbodo_restore -v mydatabase.backup