Re: pg_basebackup Restore problem - Mailing list pgsql-general

From Johnathan Tiamoh
Subject Re: pg_basebackup Restore problem
Date
Msg-id CACoPQdarLORaW7DBf7Ai3h+PpKyrQy8DBpjmYhAPPNRPBvT86Q@mail.gmail.com
Whole thread Raw
In response to Re: pg_basebackup Restore problem  (Ron Johnson <ronljohnsonjr@gmail.com>)
Responses Re: pg_basebackup Restore problem
List pgsql-general
You need to tell us the PG version number and show us the full command you ran. ?

Postgresql Version 14.10

tar -h  -zxvf   $PATH_FOLDER/*  .tar.gz

ls $PATH_FOLDER/*.tar.gz | xargs -I  {} tar -h  -zxvf  {}

What user are you running pg_basebackup as?

I ran it as postgres and now I'm restoring as postgres

/tnt???  Or /mnt?
/tnt/backup/current

This is where the backup files are.





On Wed, Jan 17, 2024 at 11:15 AM Ron Johnson <ronljohnsonjr@gmail.com> wrote:
On Wed, Jan 17, 2024 at 11:11 AM Johnathan Tiamoh <johnathantiamoh@gmail.com> wrote:
Hello,

I am trying to restore a pg_basebackup and have the following errors.


You need to tell us the PG version number and show us the full command you ran.
 
nohup: ignoring input
tar: /tnt/backup/current/7400.tar.gz: Not found in archive
tar: /tnt/backup/current/7401.tar.gz: Not found in archive
tar: /tnt/backup/current/7402.tar.gz: Not found in archive
tar: /tnt/backup/current/base.tar.gz: Not found in archive
tar: /tnt/backup/current/pg_wal.tar.gz: Not found in archive
tar: Exiting with failure status due to previous errors
PG_14_202107181/
tar: PG_14_202107181: Cannot mkdir: Permission denied

What user are you running pg_basebackup as?
 
PG_14_202107181/137502/
tar: PG_14_202107181: Cannot mkdir: Permission denied
tar: PG_14_202107181/137502: Cannot mkdir: No such file or directory
PG_14_202107181/137502/3222926016
tar: PG_14_202107181: Cannot mkdir: Permission denied

The files exist in the specified directory. 

/tnt???  Or /mnt?

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Initiate backup from routine?
Next
From: Ron Johnson
Date:
Subject: Re: pg_basebackup Restore problem