Re: pg_basebackup Restore problem

2024-01-17 Thread Johnathan Tiamoh
Thank You very much for your time. On Wed, Jan 17, 2024 at 4:51 PM Ron Johnson wrote: > Perfectly understandable, but tar *did* fail. Time to start debugging > your shell script. > > On Wed, Jan 17, 2024 at 4:26 PM Johnathan Tiamoh < > johnathantia...@gmail.com> wrote: > >> Ok. >> >> I'm a

Re: pg_basebackup Restore problem

2024-01-17 Thread Ron Johnson
Perfectly understandable, but tar *did* fail. Time to start debugging your shell script. On Wed, Jan 17, 2024 at 4:26 PM Johnathan Tiamoh wrote: > Ok. > > I'm a little confused because has always work > > On Wed, Jan 17, 2024 at 4:11 PM Ron Johnson > wrote: > >> Then you've got a bug

Re: pg_basebackup Restore problem

2024-01-17 Thread Johnathan Tiamoh
Ok. I'm a little confused because has always work On Wed, Jan 17, 2024 at 4:11 PM Ron Johnson wrote: > 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

Re: pg_basebackup Restore problem

2024-01-17 Thread Ron Johnson
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 wrote: > Yes. > > I am trying to restore the backups on a standby > > On Wed, Jan 17, 2024 at 4:04 PM Ron

Re: pg_basebackup Restore problem

2024-01-17 Thread Johnathan Tiamoh
Yes. I am trying to restore the backups on a standby On Wed, Jan 17, 2024 at 4:04 PM Ron Johnson 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

Re: pg_basebackup Restore problem

2024-01-17 Thread Ron Johnson
Wait a minute... *tar* is throwing the errors, not pg_basebackup, no? On Wed, Jan 17, 2024 at 3:27 PM Johnathan Tiamoh 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 \ >

Re: pg_basebackup Restore problem

2024-01-17 Thread Johnathan Tiamoh
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"/*

Re: pg_basebackup Restore problem

2024-01-17 Thread Ron Johnson
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 wrote: > You need to tell us the PG version number *and* show us the full command > you ran. ? > >

Re: pg_basebackup Restore problem

2024-01-17 Thread Johnathan Tiamoh
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

Re: pg_basebackup Restore problem

2024-01-17 Thread Ron Johnson
On Wed, Jan 17, 2024 at 11:11 AM Johnathan Tiamoh 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

pg_basebackup Restore problem

2024-01-17 Thread Johnathan Tiamoh
Hello, I am trying to restore a pg_basebackup and have the following errors. 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: