This is a cryptographically signed message in MIME format.

--------------ms000305000807040900040407
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: quoted-printable

Hello, admins

I'd like to ask what is general practice for doing backups? Currently
we are using cron (on Linux server). The question is what user should do =

backups. Is it good practice to use superuser for that? If not - is
there an easy way to let some backup user to access whole database
without setting permission on every database component (tables,
sequences, functions, etc)?

--
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050



--------------ms000305000807040900040407
Content-Type: application/pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
Content-Description: S/MIME Cryptographic Signature

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEH AQAAoIIGJjCC
Aw8wggJ4oAMCAQICCQCB1aFglJHbtzANBgkqhkiG9w0BAQQFADBNMQswCQYD VQQGEwJMVDEL
MAkGA1UECBMCTFQxDjAMBgNVBAoTBW5Tb2Z0MQ4wDAYDVQQLEwVuU29mdDER MA8GA1UEAxMI
blNvZnQgQ0EwHhcNMDkwNjI1MTgyNDUzWhcNMTAwNjI1MTgyNDUzWjBpMQsw CQYDVQQGEwJM
VDEQMA4GA1UEBxMHVmlsbml1czEOMAwGA1UEChMFblNvZnQxGDAWBgNVBAMT D0p1bGl1cyBU
dXNrZW5pczEeMBwGCSqGSIb3DQEJARYPanVsaXVzQG5zb2Z0Lmx0MIGfMA0G CSqGSIb3DQEB
AQUAA4GNADCBiQKBgQC73A+rjzOkfYrVAGaI/pYg0F8RzO7Dti2hhk+bctS4 Ibaz3uPCQi+7
siuWP6zx8wKF6ck3vNVBOMveZzvmjMFeAXnbbBaf0o2QFZ0L083vJawq7lic fLTI5QTTPqvP
jgC8KBWyvWpq6qy1Q7jp3or7A2FKE3fBo68eKr9l/yfE3wIDAQABo4HaMIHX MAkGA1UdEwQC
MAAwLAYJYIZIAYb4QgENBB8WHU9wZW5TU0wgR2VuZXJhdGVkIENlcnRpZmlj YXRlMB0GA1Ud
DgQWBBRtQ3sJDUF6zNynzZXcGFkSbQVCzTB9BgNVHSMEdjB0gBS/CyhXUMKf LMp4f10XvzPh
YV5vRKFRpE8wTTELMAkGA1UEBhMCTFQxCzAJBgNVBAgTAkxUMQ4wDAYDVQQK EwVuU29mdDEO
MAwGA1UECxMFblNvZnQxETAPBgNVBAMTCG5Tb2Z0IENBggkAgdWhYJSR27Iw DQYJKoZIhvcN
AQEEBQADgYEAeSEQ2HdWubGGZWZf+AUFFdsoiFTe4QL6V3z8X1tk7/nOZHOf HdViQRjoGoeg
MVEr5WEv072Pd6Q9IhE2euAB4gVHy3BM3MKGFgB94irjEpm4uHSpRWHF+yp9 up+51F75M8aG
4tZWtbqd7zU0NXwR1ibRWnprWrpmRwgSiN+xVqYwggMPMIICeKADAgECAgkA gdWhYJSR27cw
DQYJKoZIhvcNAQEEBQAwTTELMAkGA1UEBhMCTFQxCzAJBgNVBAgTAkxUMQ4w DAYDVQQKEwVu
U29mdDEOMAwGA1UECxMFblNvZnQxETAPBgNVBAMTCG5Tb2Z0IENBMB4XDTA5 MDYyNTE4MjQ1
M1oXDTEwMDYyNTE4MjQ1M1owaTELMAkGA1UEBhMCTFQxEDAOBgNVBAcTB1Zp bG5pdXMxDjAM
BgNVBAoTBW5Tb2Z0MRgwFgYDVQQDEw9KdWxpdXMgVHVza2VuaXMxHjAcBgkq hkiG9w0BCQEW
D2p1bGl1c0Buc29mdC5sdDCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEA u9wPq48zpH2K
1QBmiP6WINBfEczuw7YtoYZPm3LUuCG2s97jwkIvu7Irlj+s8fMChenJN7zV QTjL3mc75ozB
XgF522wWn9KNkBWdC9PN7yWsKu5YnHy0yOUE0z6rz44AvCgVsr1qauqstUO4 6d6K+wNhShN3
waOvHiq/Zf8nxN8CAwEAAaOB2jCB1zAJBgNVHRMEAjAAMCwGCWCGSAGG+EIB DQQfFh1PcGVu
U1NMIEdlbmVyYXRlZCBDZXJ0aWZpY2F0ZTAdBgNVHQ4EFgQUbUN7CQ1Beszc p82V3BhZEm0F
Qs0wfQYDVR0jBHYwdIAUvwsoV1DCnyzKeH9dF78z4WFeb0ShUaRPME0xCzAJ BgNVBAYTAkxU
MQswCQYDVQQIEwJMVDEOMAwGA1UEChMFblNvZnQxDjAMBgNVBAsTBW5Tb2Z0 MREwDwYDVQQD
EwhuU29mdCBDQYIJAIHVoWCUkduyMA0GCSqGSIb3DQEBBAUAA4GBAHkhENh3 VrmxhmVmX/gF
BRXbKIhU3uEC+ld8/F9bZO/5zmRznx3VYkEY6BqHoDFRK+VhL9O9j3ekPSIR NnrgAeIFR8tw
TNzChhYAfeIq4xKZuLh0qUVhxfsqfbqfudRe+TPGhuLWVrW6ne81NDV8EdYm 0Vp6a1q6ZkcI
EojfsVamMYICmjCCApYCAQEwWjBNMQswCQYDVQQGEwJMVDELMAkGA1UECBMC TFQxDjAMBgNV
BAoTBW5Tb2Z0MQ4wDAYDVQQLEwVuU29mdDERMA8GA1UEAxMIblNvZnQgQ0EC CQCB1aFglJHb
tzAJBgUrDgMCGgUAoIIBljAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcBMBwG CSqGSIb3DQEJ
BTEPFw0wOTExMTgwNzQ1NTJaMCMGCSqGSIb3DQEJBDEWBBTSNS6n6G/WJpMs Ie2qW+DcKYz8
kDBfBgkqhkiG9w0BCQ8xUjBQMAsGCWCGSAFlAwQBAjAKBggqhkiG9w0DBzAO BggqhkiG9w0D
AgICAIAwDQYIKoZIhvcNAwICAUAwBwYFKw4DAgcwDQYIKoZIhvcNAwICASgw aQYJKwYBBAGC
NxAEMVwwWjBNMQswCQYDVQQGEwJMVDELMAkGA1UECBMCTFQxDjAMBgNVBAoT BW5Tb2Z0MQ4w
DAYDVQQLEwVuU29mdDERMA8GA1UEAxMIblNvZnQgQ0ECCQCB1aFglJHbtzBr BgsqhkiG9w0B
CRACCzFcoFowTTELMAkGA1UEBhMCTFQxCzAJBgNVBAgTAkxUMQ4wDAYDVQQK EwVuU29mdDEO
MAwGA1UECxMFblNvZnQxETAPBgNVBAMTCG5Tb2Z0IENBAgkAgdWhYJSR27cw DQYJKoZIhvcN
AQEBBQAEgYACmrBLFtj5Ob3g7FGd0+cL9lTmLlI4B5lVjoyf2UKoxugnmegc 7PPP4XdnOsKe
dMSwp69TyUPkHpIOtREaeTTiaiUWwFX/9Z6x/lOiXYc4ygWWI/r5YIIyfLt8 js2YXHk3rrQe
LsmyUWPaXsuk8AFAkianHZVY75b5WUGcmrKMzgAAAAAAAA==
--------------ms000305000807040900040407--

On Nov 18, 2009, at 2:45 AM, Julius Tuskenis wrote:

> The question is what user should do backups. Is it good practice to
> use superuser for that?

If you're doing your backup with pg_dump (on an individual DB) you
need a DB user who has read access to everything in that DB.
If you're doing your backup with pg_dumpall (on the whole cluster) you
need a DB user with read access to everything in the cluster
(including roles/users), which pretty much demands a superuser...

In either case when I do dumps using pg_dump or pg_dumpall I use a
superuser account to make sure I don't miss anything.


> If not - is there an easy way to let some backup user to access
> whole database without setting permission on every database
> component (tables, sequences, functions, etc)?

None that I know of from within the database environment, but you can
grab a copy of the data directory off the filesystem. Note that this
requires stopping the DB server though, as a backup grabbed while the
DB is running may have issues.

Some rough suggestions on how to implement it with minimum impact on
your users:

From a Filesystem Snapshot:
Stop your DB, snapshot the filesystem (mksnap_ffs on FreeBSD, not sure
of a Linux equivalent), restart your DB.
Mount the snapshot somewhere & back up the data directory. (Obviously
get rid of the snapshot when you're done)
You're only down for a few seconds here -- the time for a DB restart
plus the time for a snapshot.


From a Slave of some kind:
Stop the slave, back up the data directory, restart the slave.
This is my current method. It works well, and the master server is
never down so users see zero service disruption. As a bonus, it means
you have a slave server ready to go if your master blows up.


Hope that's helpful :)

-MG

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Friends,

I am looking for Postgres replication solution for 8.3.x DB.

Any open source software available for replication?

Anybody has good step by step doc for warm standby setup?

Any other suggestion to achieve replication is appreciated.


Thanks
Palani

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Palaniappan Thiyagarajan <pthiyagarajan [at] cashedge.com> wrote:

> I am looking for Postgres replication solution for 8.3.x DB.
>
> Any open source software available for replication?
>
> Anybody has good step by step doc for warm standby setup?
>
> Any other suggestion to achieve replication is appreciated.

You might want to start with these pages:

http://wiki.postgresql.org/wiki/Replication%2C_Clustering%2C _and_Connection_Pooling

http://www.postgresql.org/docs/8.3/interactive/warm-standby. html

-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

--_f0a7bef9-cc00-4e47-a170-85ae9ade129c_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


check this
http://symmetricds.codehaus.org/

I just began playing with that one


> Date: Thu=2C 19 Nov 2009 12:39:04 -0600
> From: Kevin.Grittner [at] wicourts.gov
> To: pthiyagarajan [at] cashedge.com=3B pgsql-admin [at] postgresql.org
> Subject: Re: [ADMIN] Replication solution
>
> Palaniappan Thiyagarajan <pthiyagarajan [at] cashedge.com> wrote:
>
> > I am looking for Postgres replication solution for 8.3.x DB.
> >
> > Any open source software available for replication?
> >
> > Anybody has good step by step doc for warm standby setup?
> >
> > Any other suggestion to achieve replication is appreciated.
>
> You might want to start with these pages:
>
> http://wiki.postgresql.org/wiki/Replication%2C_Clustering%2C _and_Connecti=
on_Pooling
>
> http://www.postgresql.org/docs/8.3/interactive/warm-standby. html
>
> -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
=

--_f0a7bef9-cc00-4e47-a170-85ae9ade129c_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<style><!--
..hmmessage P
{
margin:0px=3B
padding:0px
}
body.hmmessage
{
font-size: 10pt=3B
font-family:Verdana
}
--></style>
</head>
<body class=3D'hmmessage'>
check this <br>http://symmetricds.codehaus.org/<br><br>I just began playing=
with that one<br><br><br>>=3B Date: Thu=2C 19 Nov 2009 12:39:04 -0600<br=
>>=3B From: Kevin.Grittner [at] wicourts.gov<br>>=3B To: pthiyagarajan [at] cashe=
dge.com=3B pgsql-admin [at] postgresql.org<br>>=3B Subject: Re: [ADMIN] Replic=
ation solution<br>>=3B <br>>=3B Palaniappan Thiyagarajan <=3Bpthiyaga=
rajan [at] cashedge.com>=3B wrote:<br>>=3B <br>>=3B >=3B I am looking f=
or Postgres replication solution for 8.3.x DB. <br>>=3B >=3B <br>>=3B=
>=3B Any open source software available for replication?<br>>=3B >=
=3B <br>>=3B >=3B Anybody has good step by step doc for warm standby se=
tup?<br>>=3B >=3B <br>>=3B >=3B Any other suggestion to achieve rep=
lication is appreciated.<br>>=3B <br>>=3B You might want to start with=
these pages:<br>>=3B <br>>=3B http://wiki.postgresql.org/wiki/Replica=
tion%2C_Clustering%2C_and_Connection_Pooling<br>>=3B <br>>=3B http://w=
ww.postgresql.org/docs/8.3/interactive/warm-standby.html<br>>=3B <br>>=
=3B -Kevin<br>>=3B <br>>=3B -- <br>>=3B Sent via pgsql-admin mailing =
list (pgsql-admin [at] postgresql.org)<br>>=3B To make changes to your subscri=
ption:<br>>=3B http://www.postgresql.org/mailpref/pgsql-admin<br> =
</body>
</html>=

--_f0a7bef9-cc00-4e47-a170-85ae9ade129c_--

On Thu, 2009-11-19 at 18:53 +0000, Julio Leyva wrote:
> check this
> http://symmetricds.codehaus.org/
>
> I just began playing with that one
>
>
> > Date: Thu, 19 Nov 2009 12:39:04 -0600
> > From: Kevin.Grittner [at] wicourts.gov
> > To: pthiyagarajan [at] cashedge.com; pgsql-admin [at] postgresql.org
> > Subject: Re: [ADMIN] Replication solution
> >
> > Palaniappan Thiyagarajan <pthiyagarajan [at] cashedge.com> wrote:
> >
> > > I am looking for Postgres replication solution for 8.3.x DB.

https://projects.commandprompt.com/public/replicator
http://www.slony.info
http://www.bucardo.org
http://pgfoundry.org/projects/skytools/

> >
> > > Any open source software available for replication?
> > >
> > > Anybody has good step by step doc for warm standby setup?
> > >
> > > Any other suggestion to achieve replication is appreciated.
> >
> > You might want to start with these pages:
> >
> > http://wiki.postgresql.org/wiki/Replication%2C_Clustering%
> 2C_and_Connection_Pooling
> >
> > http://www.postgresql.org/docs/8.3/interactive/warm-standby. html
> >
> > -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


--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
If the world pushes look it in the eye and GRR. Then push back harder. - Salamander


--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Michael Graziano wrote:
> On Nov 18, 2009, at 2:45 AM, Julius Tuskenis wrote:
>
>> The question is what user should do backups. Is it good practice to
>> use superuser for that?
>
> If you're doing your backup with pg_dump (on an individual DB) you need
> a DB user who has read access to everything in that DB.
> If you're doing your backup with pg_dumpall (on the whole cluster) you
> need a DB user with read access to everything in the cluster (including
> roles/users), which pretty much demands a superuser...
>
> In either case when I do dumps using pg_dump or pg_dumpall I use a
> superuser account to make sure I don't miss anything.
>
>
>> If not - is there an easy way to let some backup user to access whole
>> database without setting permission on every database component
>> (tables, sequences, functions, etc)?
>
> None that I know of from within the database environment, but you can
> grab a copy of the data directory off the filesystem. Note that this
> requires stopping the DB server though, as a backup grabbed while the DB
> is running may have issues.

Not if you have enabled PITR and tell the database that you do so:
http://www.postgresql.org/docs/8.4/static/continuous-archivi ng.html

Works excellent..

Jesper

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

--=-6VeIWbVKTTgbW6fsvO1R
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Thu, 2009-11-19 at 18:25 +0000, Palaniappan Thiyagarajan wrote:
>
> I am looking for Postgres replication solution for 8.3.x DB.
>
> Any open source software available for replication?

http://wiki.postgresql.org/wiki/Replication%2C_Clustering%
2C_and_Connection_Pooling

> Anybody has good step by step doc for warm standby setup?

https://projects.commandprompt.com/public/pitrtools

This BSD-licensed software includes a nice document for setting up a
warm standby.
--
Devrim G=C3=9CND=C3=9CZ, RHCE
Command Prompt - http://www.CommandPrompt.com
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz

--=-6VeIWbVKTTgbW6fsvO1R
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEABECAAYFAksFlkEACgkQtl86P3SPfQ5hQwCdEUDIHwz4EK8I+wqjNZEz ubTg
cToAoMDjazQc9hkfDHjJrLfFW/K1c/MV
=/grj
-----END PGP SIGNATURE-----

--=-6VeIWbVKTTgbW6fsvO1R--

On Nov 19, 2009, at 1:58 PM, Jesper Krogh wrote:

> Michael Graziano wrote:
>> None that I know of from within the database environment, but you can
>> grab a copy of the data directory off the filesystem. Note that this
>> requires stopping the DB server though, as a backup grabbed while
>> the DB
>> is running may have issues.
>
> Not if you have enabled PITR and tell the database that you do so:
> http://www.postgresql.org/docs/8.4/static/continuous-archivi ng.html
>
> Works excellent..

That's true - I forgot about pg_start_backup / pg_stop_backup (which
is sad considering I use them every time I roll a new slave...)

Doing the backup that way avoids the outage in my filesystem
snapshotting example and isn't dependent on OS-level capabilities so
it's definitely a better way to go.

-MG

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

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

Thanks for the information.

From: Julio Leyva [mailto:jcleyva [at] hotmail.com]
Sent: Thursday, November 19, 2009 10:53 AM
To: kevin.grittner [at] wicourts.gov; Palaniappan Thiyagarajan; pgsql-admin [at] post=
gresql.org
Subject: RE: [ADMIN] Replication solution

check this
http://symmetricds.codehaus.org/

I just began playing with that one


> Date: Thu, 19 Nov 2009 12:39:04 -0600
> From: Kevin.Grittner [at] wicourts.gov
> To: pthiyagarajan [at] cashedge.com; pgsql-admin [at] postgresql.org
> Subject: Re: [ADMIN] Replication solution
>
> Palaniappan Thiyagarajan <pthiyagarajan [at] cashedge.com> wrote:
>
> > I am looking for Postgres replication solution for 8.3.x DB.
> >
> > Any open source software available for replication?
> >
> > Anybody has good step by step doc for warm standby setup?
> >
> > Any other suggestion to achieve replication is appreciated.
>
> You might want to start with these pages:
>
> http://wiki.postgresql.org/wiki/Replication%2C_Clustering%2C _and_Connecti=
on_Pooling
>
> http://www.postgresql.org/docs/8.3/interactive/warm-standby. html
>
> -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

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

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3Dus-ascii"=
>
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
[at] font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
[at] font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
[at] font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
..MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
[at] page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

<p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family:"Calibri",=
"sans-serif";
color:#1F497D'>Thanks for the information.<o:p></o:p></span></p>

<p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family:"Calibri",=
"sans-serif";
color:#1F497D'><o:p> </o:p></span></p>

<div>

<div style=3D'border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in =
0in 0in'>

<p class=3DMsoNormal><b><span style=3D'font-size:10.0pt;font-family:"Tahoma=
","sans-serif"'>From:</span></b><span
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"' > Julio Leyva
[mailto:jcleyva [at] hotmail.com] <br>
<b>Sent:</b> Thursday, November 19, 2009 10:53 AM<br>
<b>To:</b> kevin.grittner [at] wicourts.gov; Palaniappan Thiyagarajan;
pgsql-admin [at] postgresql.org<br>
<b>Subject:</b> RE: [ADMIN] Replication solution<o:p></o:p></span></p>

</div>

</div>

<p class=3DMsoNormal><o:p> </o:p></p>

<p class=3DMsoNormal><span style=3D'font-size:10.0pt;font-family:"Verdana",=
"sans-serif"'>check
this <br>
http://symmetricds.codehaus.org/<br>
<br>
I just began playing with that one<br>
<br>
<br>
> Date: Thu, 19 Nov 2009 12:39:04 -0600<br>
> From: Kevin.Grittner [at] wicourts.gov<br>
> To: pthiyagarajan [at] cashedge.com; pgsql-admin [at] postgresql.org<br>
> Subject: Re: [ADMIN] Replication solution<br>
> <br>
> Palaniappan Thiyagarajan <pthiyagarajan [at] cashedge.com> wrote:<br>
> <br>
> > I am looking for Postgres replication solution for 8.3.x DB. <br>
> > <br>
> > Any open source software available for replication?<br>
> > <br>
> > Anybody has good step by step doc for warm standby setup?<br>
> > <br>
> > Any other suggestion to achieve replication is appreciated.<br>
> <br>
> You might want to start with these pages:<br>
> <br>
>
http://wiki.postgresql.org/wiki/Replication%2C_Clustering%2C _and_Connection=
_Pooling<br>
> <br>
> http://www.postgresql.org/docs/8.3/interactive/warm-standby. html<br>
> <br>
> -Kevin<br>
> <br>
> -- <br>
> Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)<br>
> To make changes to your subscription:<br>
> http://www.postgresql.org/mailpref/pgsql-admin<o:p></o:p></span></p>

</div>

</body>

</html>

--_000_3C9790592B997E43B4D5FC3DBAFD177B13532D2C0AMBX13EXCHPR OD_--

Thank you guys for advice. It's nice to have someone with experience around.

--
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050


--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

"Joshua D. Drake" <jd [at] commandprompt.com> writes:
> http://pgfoundry.org/projects/skytools/

See also: http://wiki.postgresql.org/wiki/Londiste_Tutorial

Regards,
--
dim

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

--0016367f933344079104798ed011
Content-Type: text/plain; charset=ISO-8859-1

We are currently using Slony for our client's database that has million of
rows on some tables and 12GB of raw data.

So far so good, we set it up as a service and using a watchdog script to
monitor and notify us in case the service fails.


On Fri, Nov 27, 2009 at 12:19 AM, Dimitri Fontaine
<dfontaine [at] hi-media.com>wrote:

> "Joshua D. Drake" <jd [at] commandprompt.com> writes:
> > http://pgfoundry.org/projects/skytools/
>
> See also: http://wiki.postgresql.org/wiki/Londiste_Tutorial
>
> Regards,
> --
> dim
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>



--
------------------------------------------------

"Every memorable act in the history of the world is a triumph of enthusiasm.
Nothing great was ever achieved without it because it gives any challenge or
any occupation, no matter how frightening or difficult, a new meaning.
Without enthusiasm you are doomed to a life of mediocrity but with it you
can accomplish miracles."

Og Mandino 1923-1996, Speaker and Author

------------------------------------------------

--0016367f933344079104798ed011
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

We are currently using Slony for our client's database that has million=
of rows on some tables and 12GB of raw data.<div><br></div><div>So far so =
good, we set it up as a service and using a watchdog=A0script to monitor an=
d notify us in case the service fails.</div>
<div><br></div><div><br><div class=3D"gmail_quote">On Fri, Nov 27, 2009 at =
12:19 AM, Dimitri Fontaine <span dir=3D"ltr"><<a href=3D"mailto:dfontain=
e [at] hi-media.com">dfontaine [at] hi-media.com</a>></span> wrote:<br><blockquote=
class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc soli=
d;padding-left:1ex;">
<div class=3D"im">"Joshua D. Drake" <<a href=3D"mailto:jd [at] comm=
andprompt.com">jd [at] commandprompt.com</a>> writes:<br>
> <a href=3D"http://pgfoundry.org/projects/skytools/" target=3D"_blank">=
http://pgfoundry.org/projects/skytools/</a><br>
<br>
</div>See also: <a href=3D"http://wiki.postgresql.org/wiki/Londiste_Tutoria=
l" target=3D"_blank">http://wiki.postgresql.org/wiki/Londiste_T utorial</a><=
br>
<br>
Regards,<br>
<font color=3D"#888888">--<br>
dim<br>
</font><div><div></div><div class=3D"h5"><br>
--<br>
Sent via pgsql-admin mailing list (<a href=3D"mailto:pgsql-admin [at] postgresql=
..org">pgsql-admin [at] postgresql.org</a>)<br>
To make changes to your subscription:<br>
<a href=3D"http://www.postgresql.org/mailpref/pgsql-admin" target=3D"_blank=
">http://www.postgresql.org/mailpref/pgsql-admin</a><br>
</div></div></blockquote></div><br><br clear=3D"all"><br>-- <br>-----------=
-------------------------------------<br><br>"Every memorable act in t=
he history of the world is a triumph of enthusiasm. Nothing great was ever =
achieved without it because it gives any challenge or any occupation, no ma=
tter how frightening or difficult, a new meaning. Without enthusiasm you ar=
e doomed to a life of mediocrity but with it you can accomplish miracles.&q=
uot;<br>
<br>Og Mandino 1923-1996, Speaker and Author<br><br>-----------------------=
-------------------------<br>
</div>

--0016367f933344079104798ed011--

As much of a pain as slony can be to setup and get working on a large
data set, it is pretty solid and reliable for us too. Our DB is about
100G or so.

On Sun, Nov 29, 2009 at 9:09 PM, Mark Guadalupe
<mark.guadalupe [at] gmail.com> wrote:
> We are currently using Slony for our client's database that has million of
> rows on some tables and 12GB of raw data.
> So far so good, we set it up as a service and using a watchdog=A0script to
> monitor and notify us in case the service fails.
>
> On Fri, Nov 27, 2009 at 12:19 AM, Dimitri Fontaine <dfontaine [at] hi-media.co=
m>
> wrote:
>>
>> "Joshua D. Drake" <jd [at] commandprompt.com> writes:
>> > http://pgfoundry.org/projects/skytools/
>>
>> See also: http://wiki.postgresql.org/wiki/Londiste_Tutorial
>>
>> Regards,
>> --
>> dim
>>
>> --
>> Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin
>
>
>
> --
> ------------------------------------------------
>
> "Every memorable act in the history of the world is a triumph of enthusia=
sm.
> Nothing great was ever achieved without it because it gives any challenge=
or
> any occupation, no matter how frightening or difficult, a new meaning.
> Without enthusiasm you are doomed to a life of mediocrity but with it you
> can accomplish miracles."
>
> Og Mandino 1923-1996, Speaker and Author
>
> ------------------------------------------------
>



--
When fascism comes to America, it will be intolerance sold as diversity.

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin