Обсуждение: pg_basebackup Restore problem
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: /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
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
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
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.
Thank you
Johnathan T.
On Wed, Jan 17, 2024 at 11:11 AM Johnathan Tiamoh <johnathantiamoh@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 deniedThe files exist in the specified directory.
/tnt??? Or /mnt?
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 {}
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@gmail.com> wrote:
On Wed, Jan 17, 2024 at 11:11 AM Johnathan Tiamoh <johnathantiamoh@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 archivetar: /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 deniedWhat 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 deniedThe files exist in the specified directory./tnt??? Or /mnt?
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@gmail.com> wrote:
You need to tell us the PG version number and show us the full command you ran. ?Postgresql Version 14.10tar -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/currentThis is where the backup files are.On Wed, Jan 17, 2024 at 11:15 AM Ron Johnson <ronljohnsonjr@gmail.com> wrote:On Wed, Jan 17, 2024 at 11:11 AM Johnathan Tiamoh <johnathantiamoh@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 archivetar: /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 deniedWhat 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 deniedThe files exist in the specified directory./tnt??? Or /mnt?
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"
"${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 <ronljohnsonjr@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 <johnathantiamoh@gmail.com> wrote:You need to tell us the PG version number and show us the full command you ran. ?Postgresql Version 14.10tar -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/currentThis is where the backup files are.On Wed, Jan 17, 2024 at 11:15 AM Ron Johnson <ronljohnsonjr@gmail.com> wrote:On Wed, Jan 17, 2024 at 11:11 AM Johnathan Tiamoh <johnathantiamoh@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 archivetar: /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 deniedWhat 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 deniedThe files exist in the specified directory./tnt??? Or /mnt?
Wait a minute... tar is throwing the errors, not pg_basebackup, no?
On Wed, Jan 17, 2024 at 3:27 PM Johnathan Tiamoh <johnathantiamoh@gmail.com> wrote:
1. What's in $PATH_FOLDER?/tnt/backup/current2. 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 <ronljohnsonjr@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 <johnathantiamoh@gmail.com> wrote:You need to tell us the PG version number and show us the full command you ran. ?Postgresql Version 14.10tar -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/currentThis is where the backup files are.On Wed, Jan 17, 2024 at 11:15 AM Ron Johnson <ronljohnsonjr@gmail.com> wrote:On Wed, Jan 17, 2024 at 11:11 AM Johnathan Tiamoh <johnathantiamoh@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 archivetar: /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 deniedWhat 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 deniedThe files exist in the specified directory./tnt??? Or /mnt?
Yes.
I am trying to restore the backups on a standby
On Wed, Jan 17, 2024 at 4:04 PM Ron Johnson <ronljohnsonjr@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 <johnathantiamoh@gmail.com> wrote:1. What's in $PATH_FOLDER?/tnt/backup/current2. 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 <ronljohnsonjr@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 <johnathantiamoh@gmail.com> wrote:You need to tell us the PG version number and show us the full command you ran. ?Postgresql Version 14.10tar -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/currentThis is where the backup files are.On Wed, Jan 17, 2024 at 11:15 AM Ron Johnson <ronljohnsonjr@gmail.com> wrote:On Wed, Jan 17, 2024 at 11:11 AM Johnathan Tiamoh <johnathantiamoh@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 archivetar: /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 deniedWhat 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 deniedThe files exist in the specified directory./tnt??? Or /mnt?
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 {}
ls $PATH_FOLDER/*.tar.gz | xargs -I {} tar -h -zxvf {}
On Wed, Jan 17, 2024 at 4:07 PM Johnathan Tiamoh <johnathantiamoh@gmail.com> wrote:
Yes.I am trying to restore the backups on a standbyOn Wed, Jan 17, 2024 at 4:04 PM Ron Johnson <ronljohnsonjr@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 <johnathantiamoh@gmail.com> wrote:1. What's in $PATH_FOLDER?/tnt/backup/current2. 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 <ronljohnsonjr@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 <johnathantiamoh@gmail.com> wrote:You need to tell us the PG version number and show us the full command you ran. ?Postgresql Version 14.10tar -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/currentThis is where the backup files are.On Wed, Jan 17, 2024 at 11:15 AM Ron Johnson <ronljohnsonjr@gmail.com> wrote:On Wed, Jan 17, 2024 at 11:11 AM Johnathan Tiamoh <johnathantiamoh@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 archivetar: /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 deniedWhat 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 deniedThe files exist in the specified directory./tnt??? Or /mnt?
Ok.
I'm a little confused because has always work
On Wed, Jan 17, 2024 at 4:11 PM Ron Johnson <ronljohnsonjr@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 <johnathantiamoh@gmail.com> wrote:Yes.I am trying to restore the backups on a standbyOn Wed, Jan 17, 2024 at 4:04 PM Ron Johnson <ronljohnsonjr@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 <johnathantiamoh@gmail.com> wrote:1. What's in $PATH_FOLDER?/tnt/backup/current2. 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 <ronljohnsonjr@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 <johnathantiamoh@gmail.com> wrote:You need to tell us the PG version number and show us the full command you ran. ?Postgresql Version 14.10tar -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/currentThis is where the backup files are.On Wed, Jan 17, 2024 at 11:15 AM Ron Johnson <ronljohnsonjr@gmail.com> wrote:On Wed, Jan 17, 2024 at 11:11 AM Johnathan Tiamoh <johnathantiamoh@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 archivetar: /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 deniedWhat 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 deniedThe files exist in the specified directory./tnt??? Or /mnt?
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@gmail.com> wrote:
Ok.I'm a little confused because has always workOn Wed, Jan 17, 2024 at 4:11 PM Ron Johnson <ronljohnsonjr@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 <johnathantiamoh@gmail.com> wrote:Yes.I am trying to restore the backups on a standbyOn Wed, Jan 17, 2024 at 4:04 PM Ron Johnson <ronljohnsonjr@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 <johnathantiamoh@gmail.com> wrote:1. What's in $PATH_FOLDER?/tnt/backup/current2. 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 <ronljohnsonjr@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 <johnathantiamoh@gmail.com> wrote:You need to tell us the PG version number and show us the full command you ran. ?Postgresql Version 14.10tar -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/currentThis is where the backup files are.On Wed, Jan 17, 2024 at 11:15 AM Ron Johnson <ronljohnsonjr@gmail.com> wrote:On Wed, Jan 17, 2024 at 11:11 AM Johnathan Tiamoh <johnathantiamoh@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 archivetar: /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 deniedWhat 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 deniedThe files exist in the specified directory./tnt??? Or /mnt?
Thank You very much for your time.
On Wed, Jan 17, 2024 at 4:51 PM Ron Johnson <ronljohnsonjr@gmail.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@gmail.com> wrote:Ok.I'm a little confused because has always workOn Wed, Jan 17, 2024 at 4:11 PM Ron Johnson <ronljohnsonjr@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 <johnathantiamoh@gmail.com> wrote:Yes.I am trying to restore the backups on a standbyOn Wed, Jan 17, 2024 at 4:04 PM Ron Johnson <ronljohnsonjr@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 <johnathantiamoh@gmail.com> wrote:1. What's in $PATH_FOLDER?/tnt/backup/current2. 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 <ronljohnsonjr@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 <johnathantiamoh@gmail.com> wrote:You need to tell us the PG version number and show us the full command you ran. ?Postgresql Version 14.10tar -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/currentThis is where the backup files are.On Wed, Jan 17, 2024 at 11:15 AM Ron Johnson <ronljohnsonjr@gmail.com> wrote:On Wed, Jan 17, 2024 at 11:11 AM Johnathan Tiamoh <johnathantiamoh@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 archivetar: /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 deniedWhat 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 deniedThe files exist in the specified directory./tnt??? Or /mnt?