EOF

cat > /etc/openvpn/server/development.conf <<EOF
your first line
your second line
EOF

cat <<\EOF /path/to/file.txt

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
• EOT
• blockinfile:
• read

See also

• EOF, EOT, shell redirection, --, read
• 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