Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_basebackup: error: could not create directory - Mailing list pgsql-admin

From Ron Johnson
Subject Re: pg_basebackup: error: could not create directory
Date
Msg-id CANzqJaALNsvzraoMRKRaXoR6EvYomE_CTyY+FdAh9iT3-KgQfg@mail.gmail.com
Whole thread Raw
In response to pg_basebackup: error: could not create directory  (Samir Mamun <samir.mamun.sn@fujifilm.com>)
Responses Re: pg_basebackup: error: could not create directory
List pgsql-admin
Tree view
On Thu, Sep 5, 2024 at 3:41 AM Samir Mamun <samir.mamun.sn@fujifilm.com> 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!

pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: Re: Parallelize WAL Sender and WAL receiver
Next
From: rams nalabolu
Date:
Subject: Re: pg_basebackup: error: could not create directory