[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-admin
Subject: Re: postgres backup (pg_basebackup) is failed.
From: Shreeyansh Dba <shreeyansh2014 () gmail ! com>
Date: 2019-05-03 17:55:55
Message-ID: CAGDYbUPd6PtkJoM3-CkESPskHuyQKDCqOvj_fu=NztN6DGYAhg () mail ! gmail ! com
[Download RAW message or body]
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.dba27@gmail.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@pglinux1:/oraworkspace/pg_scripts ] $ psql -V
> psql (PostgreSQL) 11.2
>
> pg_basebackup version:
> [postgres@pglinux1:/oraworkspace/pg_scripts ] $ pg_basebackup -V
> pg_basebackup (PostgreSQL) 11.2
>
>
> os version
>
> [postgres@pglinux1:/oraworkspace/pg_scripts ] $ cat /etc/redhat-release
> Red Hat Enterprise Linux Server release 7.3 (Maipo)
>
>
> backup command
> [postgres@pglinux1:/oraworkspace/pg_scripts ] $
> [postgres@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@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 *
>
>
[Attachment #3 (text/html)]
<div dir="ltr"><div dir="ltr"><div class="gmail_default" style="font-size:small">Hi \
Pavan,</div><div class="gmail_default" style="font-size:small"><br></div><div \
class="gmail_default">It looks like your database has tablespace so you can use \
--tablespace-mapping to modify the destination for storing the tablespaces \
backup.<br></div><div class="gmail_default"><br></div><div><div dir="ltr" \
class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div \
dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div \
dir="ltr"><div dir="ltr"><div dir="ltr"><div><div>Thanks & \
Regards,<br><b>Shreeyansh DBA Team</b><br><font size="1"><a \
href="http://www.shreeyansh.com" \
target="_blank">www.shreeyansh.com</a></font></div></div></div></div></div></div></div \
></div></div></div></div></div></div></div></div></div></div><br></div></div><br><div \
> class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, May 3, 2019 at 10:56 \
> PM Pavan Kumar <<a \
> href="mailto:pavan.dba27@gmail.com">pavan.dba27@gmail.com</a>> \
> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px \
> 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div \
> dir="ltr">Hello Experts,<div><br></div><div>i am running postgres online backup \
> with pg_basebasckup. and backup is failed for some reason. kindly help me on this \
> .</div><div><br></div><div><br></div><div><div><div>here are the details: \
> </div><div>postgres version : \
> 11.2</div><div><br></div><div>[postgres@pglinux1:/oraworkspace/pg_scripts ] $ psql \
> -V</div><div>psql (PostgreSQL) 11.2</div><div><br></div><div>pg_basebackup version: \
> </div><div>[postgres@pglinux1:/oraworkspace/pg_scripts ] $ pg_basebackup \
> -V</div><div>pg_basebackup (PostgreSQL) \
> 11.2</div><div><br></div><div><br></div><div>os version \
> </div><div><br></div><div>[postgres@pglinux1:/oraworkspace/pg_scripts ] $ cat \
> /etc/redhat-release</div><div>Red Hat Enterprise Linux Server release 7.3 \
> (Maipo)</div><div><br></div><div><br></div><div>backup command \
> </div><div>[postgres@pglinux1:/oraworkspace/pg_scripts ] \
> $</div><div>[postgres@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</div><div>pg_basebackup: initiating base backup, waiting for checkpoint to \
> complete</div><div>pg_basebackup: checkpoint completed</div><div>pg_basebackup: \
> write-ahead log start point: 9/5B000028 on timeline 1</div><div>pg_basebackup: \
> directory "/oradbaudit/pg_data_tbsp" exists but is not \
> empty</div><div>pg_basebackup: removing contents of data directory \
> "/oraworkspace/pgbackup/5400backup"</div><div>pg_basebackup: removing \
> contents of WAL directory \
> "/oraworkspace/pgbackup/bkpwal_log"</div><div>[postgres@pglinux1:/oraworkspace/pg_scripts \
> ] $ timed out waiting for input: \
> auto-logout</div><div><br></div><div><br></div><div>postgres alert log \
> </div><div><br></div><div>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</div><div>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</div><div>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</div><div>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</div><div>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</div><div>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</div><div>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</div><div>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</div><div>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</div></div><div><br></div><div><br clear="all"><div><br></div>-- \
> <br><div dir="ltr" class="gmail-m_-4869109993681541714gmail_signature"><font \
> color="#990000"><b><font face="'trebuchet ms', \
> sans-serif">Regards,<br><br>#! Pavan \
> Kumar<br>----------------------------------------------</font></b>-<br><b><font \
> face="'trebuchet ms', sans-serif">Sr. Database \
> Administrator..!</font></b></font><br><span \
> style="border-collapse:collapse;color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;line-height:19px"><b><span \
> style="font-size:7.5pt;font-family:Georgia,serif;color:white;background-color:red">NEXT \
> GENERATION PROFESSIONALS, LLC</span></b></span><br><font face="'trebuchet \
> ms', sans-serif" color="#990000"><b>Cell # 267-799-3182 # pavan.dba27 \
> (Gtalk) </b></font><div><font face="'trebuchet ms', sans-serif" \
> color="#990000"><b>India # 9000459083</b></font><br><br><blockquote \
> style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
> rgb(204,204,204);padding-left:1ex"><b><font face="'trebuchet ms', \
> sans-serif" color="#000099">Take Risks; if you win, you will be very happy. If you \
> lose you will be Wise \
> </font></b></blockquote></div></div></div></div></div></div>
</blockquote></div>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic