14:41:17 test$ bash setup_pg17_replication.sh recreate [pg17-lab] Stopping replica waiting for server to shut down.... done server stopped [pg17-lab] Removing replica data directory: /Users/ridvan.korkmaz/adjust/test/r [pg17-lab] Removing primary data directory: /Users/ridvan.korkmaz/adjust/test/m [pg17-lab] Cleanup complete [pg17-lab] Initializing primary with 16 MB WAL segments and checksums disabled The files belonging to this database system will be owned by user "ridvan.korkmaz". This user must also own the server process. The database cluster will be initialized with locale "en_US.UTF-8". The default database encoding has accordingly been set to "UTF8". The default text search configuration will be set to "english". Data page checksums are disabled. creating directory /Users/ridvan.korkmaz/adjust/test/m ... ok creating subdirectories ... ok selecting dynamic shared memory implementation ... posix selecting default "max_connections" ... 100 selecting default "shared_buffers" ... 128MB selecting default time zone ... Europe/Istanbul creating configuration files ... ok running bootstrap script ... ok performing post-bootstrap initialization ... ok syncing data to disk ... ok Success. You can now start the database server using: /opt/homebrew/bin/pg_ctl -D /Users/ridvan.korkmaz/adjust/test/m -l logfile start [pg17-lab] Starting primary on port 15432 waiting for server to start.... done server started [pg17-lab] Creating physical replication slot 'rs' pg_create_physical_replication_slot ------------------------------------- (rs,) (1 row) [pg17-lab] Creating replica with pg_basebackup 23498/23498 kB (100%), 1/1 tablespace [pg17-lab] Starting replica on port 25432 waiting for server to start.... done server started [pg17-lab] Primary checks port | max_wal_size | min_wal_size | wal_level | in_recovery -------+--------------+--------------+-----------+------------- 15432 | 4GB | 2GB | replica | f (1 row) slot_name | slot_type | active -----------+-----------+-------- rs | physical | t (1 row) application_name | client_addr | state | sync_state ------------------+-------------+-----------+------------ walreceiver | 127.0.0.1 | streaming | async (1 row) [pg17-lab] Replica checks port | max_wal_size | min_wal_size | wal_level | in_recovery -------+--------------+--------------+-----------+------------- 25432 | 4GB | 2GB | replica | t (1 row) status | sender_host | sender_port | slot_name -----------+-------------+-------------+----------- streaming | 127.0.0.1 | 15432 | rs (1 row) [pg17-lab] Ready: primary=127.0.0.1:15432 replica=127.0.0.1:25432 slot=rs [pg17-lab] WAL segment size verified as 16 MB; data checksums verified off