notes-infineon/_-Review/postgre-sql.md

type

type
note

PostgreSQL

• postgresql

apt install postgresql

• wsl-database

apt install postgresql postgresql-contrib -y
psql --version
service postgresql status
service postgresql start
# service postgresql stop
passwd postgres
sudo -u postgres psql

\q

su postgres
createdb immich_database
psql

\c immich_database
\q

• TODO: Fix

cat /mnt/d/8-Move/Backups/immich_database_2024-04-25T220025.sql | psql immich_database
gunzip -c /mnt/d/8-Move/Backups/immich_database_2024-04-25T220025.sql.xz | psql dbname



createdb dbname
gunzip -c filename.gz | psql dbname

psql -h 127.0.0.1 -d databasename -U username -f file.sql