13 lines
410 B
Bash
13 lines
410 B
Bash
|
#!/bin/bash
|
||
|
|
set -e
|
||
|
|
|
||
|
|
psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" <<-EOSQL
|
||
|
|
CREATE USER replicator WITH REPLICATION ENCRYPTED PASSWORD 'e-ticket';
|
||
|
|
SELECT pg_create_physical_replication_slot('slave_slot');
|
||
|
|
EOSQL
|
||
|
|
|
||
|
|
echo "host replication replicator 0.0.0.0/0 md5" >> "$PGDATA/pg_hba.conf"
|
||
|
|
echo "host all all 0.0.0.0/0 md5" >> "$PGDATA/pg_hba.conf"
|
||
|
|
|
||
|
|
pg_ctl reload -D "$PGDATA"
|