Use a simple line if you take base backup on another machine (pg_basebackup -h 192.168.X.X -U replicauser -D p:\postgresql\X.X\data\ -Xs -v -P.
If you used in a directory used (pg_basebackup -h 127.0.0.1 -U replicauser -D E:\backup -v -P --format=tar --gzip)
On Thu, Sep 5, 2024 at 1:11 PM 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
pg_basebackup: removing contents of data directory "…………"
pg_basebackup: changes to tablespace directories will not be undone
Kind Regards
Samir
IMPORTANT NOTE: FUJIFILM Business Innovation Corp.'s and its affiliates' email transmission, including any attachments, is private and confidential and may contain legally privileged information. It is for the addressee's attention only. If you are not the intended recipient and have received this transmission, you must not use, edit, print, copy or disclose its contents to any person or disseminate the information contained herein or hereto attached, and you must notify sender immediately by return email and delete this transmission from your system. Any confidentiality, privilege or copyright is not waived or lost because this e-mail has been sent to you in error. We have used reasonable efforts to protect this transmission from computer viruses and other malicious software, but no warranty is made and the sender takes no responsibility for any loss or damage incurred from using this email or the information contained in this email.
