Re: postgres backup (pg_basebackup) is failed.

Hi Pavan,

It looks like your database has tablespace so you can use
--tablespace-mapping to modify the destination for storing the tablespaces
backup.

Thanks & Regards,
*Shreeyansh DBA Team*
www.shreeyansh.com

On Fri, May 3, 2019 at 10:56 PM Pavan Kumar <pavan(dot)dba27(at)gmail(dot)com> wrote:

> Hello Experts,
>
> i am running postgres online backup with pg_basebasckup. and backup is
> failed for some reason. kindly help me on this .
>
>
> here are the details:
> postgres version : 11.2
>
> [postgres(at)pglinux1:/oraworkspace/pg_scripts ] $ psql -V
> psql (PostgreSQL) 11.2
>
> pg_basebackup version:
> [postgres(at)pglinux1:/oraworkspace/pg_scripts ] $ pg_basebackup -V
> pg_basebackup (PostgreSQL) 11.2
>
>
> os version
>
> [postgres(at)pglinux1:/oraworkspace/pg_scripts ] $ cat /etc/redhat-release
> Red Hat Enterprise Linux Server release 7.3 (Maipo)
>
>
> backup command
> [postgres(at)pglinux1:/oraworkspace/pg_scripts ] $
> [postgres(at)pglinux1:/oraworkspace/pg_scripts ] $ pg_basebackup -h
> localhost -p 5400 -D /oraworkspace/pgbackup/5400backup
> --waldir=/oraworkspace/pgbackup/bkpwal_log --checkpoint=fast
> --wal-method=stream -v
> pg_basebackup: initiating base backup, waiting for checkpoint to complete
> pg_basebackup: checkpoint completed
> pg_basebackup: write-ahead log start point: 9/5B000028 on timeline 1
> pg_basebackup: directory "/oradbaudit/pg_data_tbsp" exists but is not empty
> pg_basebackup: removing contents of data directory
> "/oraworkspace/pgbackup/5400backup"
> pg_basebackup: removing contents of WAL directory
> "/oraworkspace/pgbackup/bkpwal_log"
> [postgres(at)pglinux1:/oraworkspace/pg_scripts ] $ timed out waiting for
> input: auto-logout
>
>
> postgres alert log
>
> 2019-05-03 17:16:00.204 GMT [6646] [unknown] [unknown] [unknown]
> localhost(53866) 00000 5ccc7750.19f6 0 2019-05-03 17:16:00 GMT LOG:
> connection received: host=localhost port=53866
> 2019-05-03 17:16:00.206 GMT [6646] [unknown] postgres [unknown]
> localhost(53866) 00000 5ccc7750.19f6 0 2019-05-03 17:16:00 GMT LOG:
> replication connection authorized: user=postgres
> 2019-05-03 17:16:00.245 GMT [6474] 00000 5ccc7743.194a 0 2019-05-03
> 17:15:47 GMT LOG: checkpoint starting: immediate force wait
> 2019-05-03 17:16:00.260 GMT [6474] 00000 5ccc7743.194a 0 2019-05-03
> 17:15:47 GMT LOG: checkpoint complete: wrote 0 buffers (0.0%); 0 WAL
> file(s) added, 1 removed, 0 recycled; write=0.003 s, sync=0.000 s,
> total=0.014 s; sync files=0, longest=0.000 s, average=0.000 s;
> distance=16384 kB, estimate=16384 kB
> 2019-05-03 17:16:00.348 GMT [6646] pg_basebackup postgres [unknown]
> localhost(53866) 08006 5ccc7750.19f6 0 2019-05-03 17:16:00 GMT LOG: could
> not send data to client: Connection reset by peer
> 2019-05-03 17:16:00.348 GMT [6646] pg_basebackup postgres [unknown]
> localhost(53866) XX000 5ccc7750.19f6 0 2019-05-03 17:16:00 GMT ERROR: base
> backup could not send data, aborting backup
> 2019-05-03 17:16:00.349 GMT [6646] pg_basebackup postgres [unknown]
> localhost(53866) 08006 5ccc7750.19f6 0 2019-05-03 17:16:00 GMT LOG: could
> not send data to client: Broken pipe
> 2019-05-03 17:16:00.349 GMT [6646] pg_basebackup postgres [unknown]
> localhost(53866) 08006 5ccc7750.19f6 0 2019-05-03 17:16:00 GMT FATAL:
> connection to client lost
> 2019-05-03 17:16:00.349 GMT [6646] pg_basebackup postgres [unknown]
> localhost(53866) 00000 5ccc7750.19f6 0 2019-05-03 17:16:00 GMT LOG:
> disconnection: session time: 0:00:00.145 user=postgres database=
> host=localhost port=53866
>
>
>
> --
>
>
>
> *Regards,#! Pavan Kumar----------------------------------------------*-
> *Sr. Database Administrator..!*
> *NEXT GENERATION PROFESSIONALS, LLC*
> *Cell # 267-799-3182 # pavan.dba27 (Gtalk) *
> *India # 9000459083*
>
> *Take Risks; if you win, you will be very happy. If you lose you will be
> Wise *
>
>