[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] does pg_dump get delayed if I have a loop that does continuous insertions
From:       Guillaume Lelarge <guillaume () lelarge ! info>
Date:       2015-10-31 19:18:33
Message-ID: CAECtzeX+f4i2P6YwQoXmqihZnO86uEpXUP=6P3gSjmJE5nE6nA () mail ! gmail ! com
[Download RAW message or body]

2015-10-28 21:09 GMT+01:00 anj patnaik <patna73@gmail.com>:

> I was trying to achieve smallest file possible so tried the xz. Right now
> the db size returned from SELECT
> pg_size_pretty(pg_database_size('postgres') is 1.4 GB and the size of the
> dump with xz is 2.2 GB.
>
> Is there a limit to the size of the database that pg_dump will run on?
>

No limit..


> Will it work when db is in TBs?
>
>
... though this would big a rather bad idea. It will work, but it will be
damn slow. And its restoration will last way too much. Much better to do
PITR backups with databases bigger than 100GB.


> Also, I want to know if anyone has found any handy cron scripts for
> automated backups to run on a daily/weekly basis? i found some on google,
> but interested to know if there are better ones.
>
>
I really like pg_back (though, as a disclaimer, I should say this is
written by one of my co-workers, Nicolas Thauvin). Anyway, it's on
https://github.com/orgrim/pg_back if you want to take a look.


-- 
Guillaume.
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com

[Attachment #3 (text/html)]

<div dir="ltr"><div class="gmail_extra"><div class="gmail_quote">2015-10-28 21:09 \
GMT+01:00 anj patnaik <span dir="ltr">&lt;<a href="mailto:patna73@gmail.com" \
target="_blank">patna73@gmail.com</a>&gt;</span>:<br><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">I was trying to achieve smallest \
file possible so tried the xz. Right now the db size returned from  SELECT \
pg_size_pretty(pg_database_size(&#39;postgres&#39;) is 1.4 GB and the size of the \
dump with xz is 2.2 GB.  <div><br></div><div>Is there a limit to the size of the \
database that pg_dump will run on?</div></div></blockquote><div><br></div><div>No \
limit..<br>  <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> \
Will it work when db is in \
TBs?</div><div><br></div></div></blockquote><div><br></div><div>... though this would \
big a rather bad idea. It will work, but it will be damn slow. And its restoration \
will last way too much. Much better to do PITR backups with databases bigger than \
100GB.<br>  <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></div><div>Also, I want to know if anyone has found any handy cron \
scripts for automated backups to run on a daily/weekly basis? i found some on google, \
but interested to know if there are better \
ones.</div><div><br></div></div></blockquote><br></div><div class="gmail_quote">I \
really like pg_back (though, as a disclaimer, I should say this is written by one of \
my co-workers, Nicolas Thauvin). Anyway, it&#39;s on <a \
href="https://github.com/orgrim/pg_back">https://github.com/orgrim/pg_back</a> if you \
want to take a look.<br></div><br clear="all"><br>-- <br><div \
class="gmail_signature"><div dir="ltr"><div>Guillaume.<br></div><div>   <a \
href="http://blog.guillaume.lelarge.info" \
target="_blank">http://blog.guillaume.lelarge.info</a><br></div>   <a \
href="http://www.dalibo.com" \
target="_blank">http://www.dalibo.com</a><br></div></div> </div></div>



[prev in list] [next in list] [prev in thread] [next in thread]