Search Postgresql Archives

Re: pg_basebackup Restore problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Ok. 

I'm a little confused because has always work

On Wed, Jan 17, 2024 at 4:11 PM Ron Johnson <ronljohnsonjr@xxxxxxxxx> 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@xxxxxxxxx> wrote:
Yes.

I am trying to restore the backups on a standby

On Wed, Jan 17, 2024 at 4:04 PM Ron Johnson <ronljohnsonjr@xxxxxxxxx> 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@xxxxxxxxx> 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 <ronljohnsonjr@xxxxxxxxx> 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@xxxxxxxxx> 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@xxxxxxxxx> wrote:
On Wed, Jan 17, 2024 at 11:11 AM Johnathan Tiamoh <johnathantiamoh@xxxxxxxxx> 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?


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux