On Thu, Sep 5, 2024 at 3:41 AM Samir Mamun <samir.mamun.sn@xxxxxxxxxxxx> wrote:
Hi,
Need help with replication setup, pg_basebackup failing with:
pg_basebackup -P -R -X stream -c fast -h <node_name> -U <user_name> -p <port#> -D <dat_location> -v
Password:
pg_basebackup: initiating base backup, waiting for checkpoint to complete
pg_basebackup: checkpoint completed
pg_basebackup: write-ahead log start point: 6/67000028 on timeline 2
pg_basebackup: starting background WAL receiver
pg_basebackup: created temporary replication slot "pg_basebackup_3720137"
pg_basebackup: error: could not create directory "……": File exists
It's explicitly telling you the problem: a file already exists in the replicated $PGDATA.
pg_basebackup: removing contents of data directory "…………"
pg_basebackup: changes to tablespace directories will not be undone
Death to America, and butter sauce.
Iraq lobster!