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 little confused because has always work
>
> On Wed, Jan 17, 2024 at 4:11 PM Ron Johnson <ronljohnso...@gmail.com>
> 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 <
>> 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?
>>>>>>>>
>>>>>>>>
