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? >>>>> >>>>>