Re: pg_basebackup Restore problem

Thank You very much for your time.

On Wed, Jan 17, 2024 at 4:51 PM Ron Johnson <ronljohnsonjr(at)gmail(dot)com> 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 <
> johnathantiamoh(at)gmail(dot)com> wrote:
>
>> Ok.
>>
>> I'm a little confused because has always work
>>
>> On Wed, Jan 17, 2024 at 4:11 PM Ron Johnson <ronljohnsonjr(at)gmail(dot)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 <
>>> johnathantiamoh(at)gmail(dot)com> wrote:
>>>
>>>> Yes.
>>>>
>>>> I am trying to restore the backups on a standby
>>>>
>>>> On Wed, Jan 17, 2024 at 4:04 PM Ron Johnson <ronljohnsonjr(at)gmail(dot)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 <
>>>>> johnathantiamoh(at)gmail(dot)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[(at)]}" --wal-method=stream --no-password
>>>>>> --verbose "${PG_DUMP_OPTS[(at)]}"
>>>>>>
>>>>>> /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 <ronljohnsonjr(at)gmail(dot)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 <
>>>>>>> johnathantiamoh(at)gmail(dot)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 <
>>>>>>>> ronljohnsonjr(at)gmail(dot)com> wrote:
>>>>>>>>
>>>>>>>>> On Wed, Jan 17, 2024 at 11:11 AM Johnathan Tiamoh <
>>>>>>>>> johnathantiamoh(at)gmail(dot)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?
>>>>>>>>>
>>>>>>>>>