ky0

melkij=> set temp_buffers to '8192GB';
ERROR:  1073741824 8kB is outside the valid range for parameter "temp_buffers" (100 .. 1073741823)
melkij=> set temp_buffers to '8191GB';
SET

#!/bin/bash
for DBNAME in $( psql -q -c "\t" -c "\a" -c "SELECT datname FROM pg_database WHERE NOT (datistemplate AND datname <> 'postgres');" )
do
    dropdb -f $DBNAME
done

psql -q -c "\t" -c "\a" -c "SELECT datname FROM pg_database WHERE NOT (datistemplate AND datname <> 'postgres');" | xargs -l1 dropdb -f

location /foobar/ {
        proxy_pass https://buz.org/
        proxy_bind $server_addr;
        proxy_set_header Host $host;
        proxy_http_version 1.1;
        proxy_set_header Connection "";
        proxy_connect_timeout 3s;
        proxy_read_timeout 120s;
        proxy_send_timeout 10s;
        proxy_buffering on;
        proxy_max_temp_file_size 0;
        proxy_cache off;
        proxy_ssl_server_name on;
    }

The schema definitions are not replicated, and the published tables must exist on the subscriber.

| psql