Then you've got a bug somewhere in: tar -h -zxvf $PATH_FOLDER/* .tar.gz ls $PATH_FOLDER/*.tar.gz | xargs -I {} tar -h -zxvf {}
On Wed, Jan 17, 2024 at 4:07 PM Johnathan Tiamoh <johnathantia...@gmail.com> wrote: > Yes. > > I am trying to restore the backups on a standby > > On Wed, Jan 17, 2024 at 4:04 PM Ron Johnson <ronljohnso...@gmail.com> > wrote: > >> Wait a minute... *tar* is throwing the errors, not pg_basebackup, no? >> >> On Wed, Jan 17, 2024 at 3:27 PM Johnathan Tiamoh < >> johnathantia...@gmail.com> wrote: >> >>> 1. What's in $PATH_FOLDER? >>> >>> /tnt/backup/current >>> >>> 2. What pg_basebackup command did you use? >>> >>> pg_basebackup -D "$baseback_dir" --format=tar \ >>> "${comp_opts[@]}" --wal-method=stream --no-password >>> --verbose "${PG_DUMP_OPTS[@]}" >>> >>> /bin/mv "$baseback_dir"/* "/enf/backup/current/" >>> /bin/rm -r "$baseback_dir" >>> >>> >>> 3. Why aren't you letting pg_basebackup maintain the WAL files it needs? >>> >>> >>> On Wed, Jan 17, 2024 at 11:46 AM Ron Johnson <ronljohnso...@gmail.com> >>> wrote: >>> >>>> 1. What's in $PATH_FOLDER? >>>> 2. What pg_basebackup command did you use? >>>> 3. Why aren't you letting pg_basebackup maintain the WAL files it needs? >>>> >>>> On Wed, Jan 17, 2024 at 11:27 AM Johnathan Tiamoh < >>>> johnathantia...@gmail.com> wrote: >>>> >>>>> 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 <ronljohnso...@gmail.com> >>>>> wrote: >>>>> >>>>>> On Wed, Jan 17, 2024 at 11:11 AM Johnathan Tiamoh < >>>>>> johnathantia...@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? >>>>>> >>>>>>