Consistent EC2 Snapshots with Postgres

This is a multi-part message in MIME format.

------=_NextPart_000_0000_01CA5A40.F065CA50
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hi all,

I am fairly new to postgres admin so please bear with me.

I am looking for a way to create a consitent EC2 snapshot of a postgres
DB that is running in a Debian Lenny instance, XFS file system on a EBS
.. I was following Eric Hammons posts http://ec2ebs-mysql.notlong.com/
http://alestic.com/2009/09/ec2-consistent-snapshot on creating Snapshost
for MySQL and would like to port his efforts to Postgres.


I am really looking just for some documentation of this whole area since
I am sitting here a bit in the blue ;) (e.g. I heard of LVM but do not
know it and not sure if this is the way to go)

Thanks a bunch! Ben

------=_NextPart_000_0000_01CA5A40.F065CA50
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
6.0.4630.0">
<TITLE>Consistent EC2 Snapshots with Postgres</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->

<P><SPAN LANG=3D"de-ch"><FONT SIZE=3D2 FACE=3D"Arial">Hi =
all,</FONT></SPAN>
</P>

<P><SPAN LANG=3D"de-ch"><FONT SIZE=3D2 FACE=3D"Arial">I am fairly new to =
postgres admin so please bear with me. </FONT></SPAN>
</P>

<P><SPAN LANG=3D"de-ch"><FONT SIZE=3D2 FACE=3D"Arial">I am looking for a =
way to create a consitent EC2 snapshot of a postgres DB that is running =
in a Debian Lenny instance, XFS file system on a EBS . I was following =
Eric Hammons posts </FONT></SPAN><A =
HREF=3D"http://ec2ebs-mysql.notlong.com/"><SPAN LANG=3D"de-ch"><U><FONT =
COLOR=3D"#0000FF" SIZE=3D2 =
FACE=3D"Arial">http://ec2ebs-mysql.notlong.com/</FONT></U></SPAN></A><SPA=
N LANG=3D"de-ch"><FONT SIZE=3D2 FACE=3D"Arial">  </FONT></SPAN><A =
HREF=3D"http://alestic.com/2009/09/ec2-consistent-snapshot"><SPAN =
LANG=3D"de-ch"><U><FONT COLOR=3D"#0000FF" SIZE=3D2 =
FACE=3D"Arial">http://alestic.com/2009/09/ec2-consistent-sna pshot</FONT><=
/U></SPAN></A><SPAN LANG=3D"de-ch"><FONT SIZE=3D2 FACE=3D"Arial"> on =
creating Snapshost for MySQL and would like to port his efforts to =
Postgres.</FONT></SPAN></P>
<BR>

<P><SPAN LANG=3D"de-ch"><FONT SIZE=3D2 FACE=3D"Arial">I am really =
looking just for some documentation of this whole area since I am =
sitting here a bit in the blue ;) (e.g. I heard of LVM but do not know =
it and not sure if this is the way to go)</FONT></SPAN></P>

<P><SPAN LANG=3D"de-ch"><FONT SIZE=3D2 FACE=3D"Arial">Thanks a bunch! =
Ben</FONT></SPAN><SPAN LANG=3D"en-us"></SPAN>
</P>

</BODY>
</HTML>
------=_NextPart_000_0000_01CA5A40.F065CA50--
saturon [ Sa, 31 Oktober 2009 15:43 ] [ ID #2021148 ]
Datenbanken » gmane.comp.db.postgresql.admin » Consistent EC2 Snapshots with Postgres

Vorheriges Thema: dupes for PK and other UNIQUE indexes
Nächstes Thema: Enabling Server Instrumentation on 8.4.1