Difference between revisions of "EOF"
Jump to navigation
Jump to search
| (21 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| + | [[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 | [[psql -h]] you_dp_ip [[-U postgres]] [[-p 5432]] << EOF | ||
| Line 9: | Line 15: | ||
[[GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA]] [[public]] TO yourdbname; | [[GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA]] [[public]] TO yourdbname; | ||
EOF | 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 == | == Related == | ||
* <code>[[eof]]</code> | * <code>[[eof]]</code> | ||
| + | * <code>[[sudo -u postgres]]</code> | ||
| + | * <code>[[EOT]]</code> | ||
| + | * <code>[[blockinfile:]]</code> | ||
| + | * <code>[[read]]</code> | ||
| + | * <code>[[datadog_monitor_json]]</code> | ||
== See also == | == See also == | ||
| − | * {{ | + | * {{EOF}} |
* {{GRANT}} | * {{GRANT}} | ||
[[Category:Computing]] | [[Category:Computing]] | ||
Latest revision as of 07:14, 9 July 2024
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
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[edit]
See also[edit]
Advertising:
