Postgresql
#Backups Data
pg_dump --port 5432 --username backups --role postgres --no-password --encoding UTF8 --verbose dbName | gzip > /backups/backupFile.dump.gz
#Restore Data
psql -U postgres -d dbName -f /baackups/backupFile.dump
#Command
CREATE USER dbUser WITH PASSWORD '123456';
ALTER ROLE dbUser SUPERUSER;
./psql -p 5432
./psql -p 5432 -d platform
./initdb -D /var/lib/pgsql/dbName --locale=th_TH.UTF-8 --encoding=UTF8
./pg_ctl -D /var/lib/pgsql/dbName restart
ALTER ROLE "postgres" NOLOGIN;
ALTER ROLE "admin" LOGIN PASSWORD '123456';
