Обсуждение: pg_basebackup Failed
Hi All,
I do not know why I am having this problem. My pg_basebackup which I took using this command "pg_basebackup -h xxxxxx -p 5432 -U postgres_repuser -D /data/postgres -R" is failing with this error message "pg_basebackup: error: could not create directory "/data/postgres/pg_log": File exists"
I cleaned up that directory using rm -rf /data/postgres/ .*/ and I still end up with the above error message.
Any suggestions will be highly appreciated.
Yong
Check the complete path on your primary replica.
Refer the below example
Example: pg_basebackup -h <hostip> -U <>repuser -Xs -P -R -D /var/lib/pgsql/11/ -p 5490
This command will copy the complete data in /data directory from the primary node to /var/lib/pgsql/11/ on the replica node.
On replica node you can go to /var/lib/pgsql/11/ and find that /data directory of primary replica gets copied here.
On Thu, Apr 25, 2024 at 4:35 PM Yongye Serkfem <yserkfem@gmail.com> wrote:
Hi All,I do not know why I am having this problem. My pg_basebackup which I took using this command "pg_basebackup -h xxxxxx -p 5432 -U postgres_repuser -D /data/postgres -R" is failing with this error message "pg_basebackup: error: could not create directory "/data/postgres/pg_log": File exists"I cleaned up that directory using rm -rf /data/postgres/ .*/ and I still end up with the above error message.Any suggestions will be highly appreciated.Yong
Hi
To debug the issue, try to take the backup to a location where user taking the backup has Access, provide the location with -D option.
This way it will be confirmed if the issue is due to permissions.
Thanks
Kashif Zeeshan
Bitnine Global
On Thu, Apr 25, 2024 at 5:35 PM Yongye Serkfem <yserkfem@gmail.com> wrote:
Hi All,I do not know why I am having this problem. My pg_basebackup which I took using this command "pg_basebackup -h xxxxxx -p 5432 -U postgres_repuser -D /data/postgres -R" is failing with this error message "pg_basebackup: error: could not create directory "/data/postgres/pg_log": File exists"I cleaned up that directory using rm -rf /data/postgres/ .*/ and I still end up with the above error message.Any suggestions will be highly appreciated.Yong
Em 25/04/2024 09:34, Yongye Serkfem escreveu:
Hi All,I do not know why I am having this problem. My pg_basebackup which I took using this command "pg_basebackup -h xxxxxx -p 5432 -U postgres_repuser -D /data/postgres -R" is failing with this error message "pg_basebackup: error: could not create directory "/data/postgres/pg_log": File exists"I cleaned up that directory using rm -rf /data/postgres/ .*/ and I still end up with the above error message.Any suggestions will be highly appreciated.Yong
I think the command "rm -rf /data/postgres/.*/ " may not remove all content.. try "rm -rf /data/postgres/*"