Snapshot and pg_hotbackup

--_000_54E5385D47A89542BC678F5426799F390446750764OSTIEX01ost ig_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Does anyone use OS snapshot as the file system backup solution in the pg_ho=
tbackup instead of tar? Using tar for a small database is not a problem is=
when you have a database that will be close to a Terrabyte in size it can =
be a problem. I was wondering if changing the file system backup solution =
to a snapshot instead has been done. I have PostgreSQL databases on Red Ha=
t Linux and x86 64 bit Solaris. The larger database will be on the Solaris=
server.

Thanks,

Sandra Arnold
Sr DBA
DOE/OSTI
Oak Ridge, TN

--_000_54E5385D47A89542BC678F5426799F390446750764OSTIEX01ost ig_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Dus-ascii" http-equiv=3DContent-Type>
<META name=3DGENERATOR content=3D"MSHTML 8.00.6001.18783"></HEAD>
<BODY>
<DIV><SPAN class=3D214340416-01092009><FONT size=3D2 face=3DArial>Does anyo=
ne use OS
snapshot as the file system backup solution in the pg_hotbackup instead of=

tar?  Using tar for a small database is not a problem is when you have=
a
database that will be close to a Terrabyte in size it can be a problem.&nbs=
p; I
was wondering if changing the file system backup solution to a snapshot ins=
tead
has been done.  I have PostgreSQL databases on Red Hat Linux and x86 6=
4 bit
Solaris.  The larger database will be on the Solaris
server.</FONT></SPAN></DIV>
<DIV><SPAN class=3D214340416-01092009><FONT size=3D2
face=3DArial></FONT></SPAN> </DIV>
<DIV><SPAN class=3D214340416-01092009><FONT size=3D2
face=3DArial>Thanks,</FONT></SPAN></DIV>
<DIV><SPAN class=3D214340416-01092009><FONT size=3D2
face=3DArial></FONT></SPAN> </DIV>
<DIV><SPAN class=3D214340416-01092009><FONT size=3D2 face=3DArial>Sandra
Arnold</FONT></SPAN></DIV>
<DIV><SPAN class=3D214340416-01092009><FONT size=3D2 face=3DArial>Sr
DBA</FONT></SPAN></DIV>
<DIV><SPAN class=3D214340416-01092009><FONT size=3D2
face=3DArial>DOE/OSTI</FONT></SPAN></DIV>
<DIV><SPAN class=3D214340416-01092009><FONT size=3D2 face=3DArial>Oak Ridge=
,
TN</FONT></SPAN></DIV></BODY></HTML>

--_000_54E5385D47A89542BC678F5426799F390446750764OSTIEX01ost ig_--
ArnoldS [ Di, 01 September 2009 18:08 ] [ ID #2014243 ]

Re: Snapshot and pg_hotbackup

"Arnold, Sandra" <ArnoldS [at] osti.gov> wrote:

> Using tar for a small database is not a problem is when you have a
> database that will be close to a Terrabyte in size it can be a
> problem. I was wondering if changing the file system backup
> solution to a snapshot instead has been done.

If snapshots turn out not to work well for you, and any significant
portions of the data remain unchanged from one base backup to the
next, you might want to check out this thread and the one it
references:

http://archives.postgresql.org/pgsql-admin/2009-07/msg00071. php

-Kevin

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Kevin Grittner [ Di, 01 September 2009 20:17 ] [ ID #2014244 ]
Datenbanken » gmane.comp.db.postgresql.admin » Snapshot and pg_hotbackup

Vorheriges Thema: Looking for real configuration data
Nächstes Thema: purging debugger functions?