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

• Restore DB:

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

sudo -u postgres -- bash -c "psql -c 'CREATE database tsdb'"
sudo -u postgres -- bash -c "psql tsdb -c 'CREATE EXTENSION IF NOT EXISTS timescaledb;'"

Related

• eof

sudo -u postgres

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