EOF

psql -h you_dp_ip -U postgres -p 5432  << EOF
CREATE DATABASE "yourdbname";
CREATE USER yourusername WITH PASSWORD yourpassword;
GRANT ALL PRIVILEGES ON DATABASE "yourdbname" to yourusername;
GRANT ALL PRIVILEGES ON SCHEMA public to yourusername;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO yourdbname;
EOF

gunzip < your_latest_backup.gz | psql -h YOUR_DB_ENDPOINT -U your_user -d your_db

Related:

SET
CREATE SEQUENCE
ALTER SEQUENCE
COPY 23038138
CREATE INDEX
ALTER TABLE
ERROR:  role "NONEXITSROLE" does not exist
WARNING:  no privileges could be revoked for "public"
REVOKE
WARNING:  no privileges were granted for "public"
GRANT
ERROR:  role "your_sole" does not exist
set_config

Related

• eof

See also

• cat, tac, more, less, tail, mtail, echo, stdin, tr, column, paste, truncate, logrotate, xzcat pv, progress, sort, ncat, virt-cat, awk, join, col, fold, tee, sponge, nfs-cat, journalctl, ccat, icat, EOF, lolcat
• GRANT, \ddp, GRANT USAGE, GRANT ALL PRIVILEGES, GRANT SELECT, View GRANTs on Redshift, has_table_privilege, has_schema_privilege, HAS_DATABASE_PRIVILEGE, SCHEMA, Privileges, GRANT EXECUTE