Thread: pg_basebackup: error: could not create directory

pg_basebackup: error: could not create directory

From
Samir Mamun
Date:

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.

Re: pg_basebackup: error: could not create directory

From
Muhammad Usman Khan
Date:

Hi,
Kindly check if the destination directory is empty and if not then first clear the directory and then run the command again.



On Thu, 5 Sept 2024 at 12:40, 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

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.

Re: pg_basebackup: error: could not create directory

From
ajit wangkhem
Date:
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@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

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.

Re: pg_basebackup: error: could not create directory

From
Ron Johnson
Date:
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!

Re: pg_basebackup: error: could not create directory

From
rams nalabolu
Date:
I’m not sure what’s the use case. But if you are taking the base backup with default format you need to make sure all tablespace directories should be empty as it tries to create backup file under it. So try with tar format and make sure -D directory is empty then it will create all tablespace backups in that directory with <<tablespace our>>.tar and you should be good. 
While doing PITR or setting HA server you need to create table space directory on target server and copy the corresponding tar file and untar it. You will get tablespace directory information from tablespace_map file from backup.



On Thu, Sep 5, 2024 at 8:00 AM Ron Johnson <ronljohnsonjr@gmail.com> wrote:
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!