PostgreSQL: Backup and restore pg_dump with password on command line #sql

script.sh

# linux
PGPASSWORD="password" pg_dump -h host -p port -U username database > file.sql

# windows
PGPASSWORD=password&& pg_dump -h host -p port -U username database > file.sql

# alternative
pg_dump --dbname=postgresql://username:password@host:port/database > file.sql

# restore
psql -h localhost -U postgres -d database < file.sql


## Import dump
psql -h hostname -d databasename -U username -f file.sql

## Asign user to db
ALTER DATABASE dbname OWNER TO dbuser;