Search Postgresql Archives

Re: pg_basebackup cannot compress to STDOUNT

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

 



On 5/8/20 1:42 PM, Support wrote:


On 5/8/2020 1:24 PM, Adrian Klaver wrote:
On 5/8/20 12:31 PM, Support wrote:

On 5/8/2020 12:18 PM, Adrian Klaver wrote:
On 5/8/20 12:14 PM, Support wrote:
Hi,

Despite of the --help saying that it's possible to gzip to STDOUT and pipe it for another process
pg_basebackup fails saying that it's not possible to gzip to STDOUT.

1) Postgres version?

2) Command run?

3) Error reported?


Who to believe then?


1) Postgres version?
12.2 selt compiled with
./configure --with-perl --enable-integer-datetimes --enable-depend --with-pam --with-systemd --enable-nls --with-libxslt --with-libxml --with-llvm --with-python --with-icu --with-gssapi --with-openssl

2) Command run?
ssh postgres@nodeXXX "pg_basebackup -h /run/postgresql -Ft -D- | pigz -c -p2 " | pigz -cd -p2 | tar -xf- -C /usr/local/pgsql/data

3) Error reported?
pg_basebackup: error: cannot stream write-ahead logs in tar mode to stdout

https://www.postgresql.org/docs/12/app-pgbasebackup.html
"t
tar

    Write the output as tar files in the target directory. The main data directory will be written to a file named base.tar, and all other tablespaces will be named after the tablespace OID.

    If the value - (dash) is specified as target directory, the tar contents will be written to standard output, suitable for piping to for example gzip. This is only possible if the cluster has no additional tablespaces and WAL streaming is not used.
                ^^^^^^^^^^^^^^^^^^^^^^^^^^
"

So use -X fetch or X none


Try "pg_basebackup --help" or more information.
tar: This does not look like a tar archive
tar: Exiting with failure status due to previous errors

Thanks!



Good catch thank you!

It was not much of a catch, the error message supplied the info:

"pg_basebackup: error: cannot stream write-ahead logs in tar mode to stdout "






--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx





[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 Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux