public inbox for [email protected]  

help / color / mirror / Atom feed

From: ajit wangkhem <[email protected]>
To: Samir Mamun <[email protected]>
Cc: Pgsql-admin <[email protected]>
Subject: Re: pg_basebackup: error: could not create directory
Date: Thu, 5 Sep 2024 13:21:12 +0530
Message-ID: <CAMurXp2NJy69RBAnfJDFun7hAr18m5scXCX1LNmuGdZGq=7eKA@mail.gmail.com> (raw)
In-Reply-To: <SY0PR01MB9296C4A820754E1CB0CB0EADD29D2@SY0PR01MB9296.ausprd01.prod.outlook.com>
References: <SY0PR01MB9296C4A820754E1CB0CB0EADD29D2@SY0PR01MB9296.ausprd01.prod.outlook.com>

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 <[email protected]>
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.
>

view thread (5+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: pg_basebackup: error: could not create directory
  In-Reply-To: <CAMurXp2NJy69RBAnfJDFun7hAr18m5scXCX1LNmuGdZGq=7eKA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox