08704c9824
- Create init-master.sh that runs SQL and appends replication rules to pg_hba.conf - Switch docker-compose-prod template from init-master.sql to init-master.sh - Fixes "no pg_hba.conf entry for replication connection" error Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com>
13 lines
410 B
Bash
Executable File
13 lines
410 B
Bash
Executable File
#!/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"
|