Using Postgresql Replication

This message is in MIME format.

--=_5v95viiei08
Content-Type: text/plain;
charset=UTF-8
Content-Description: Plaintext Version of Message
Content-Disposition: inline
Content-Transfer-Encoding: 7bit

Hi All,

I am very new to Postgres in that I have to setup replication. For Which I am very confused between Postgres's replication types.
I want a sychronized but a master-slave replication.
I have read about Slony-I replication method. But I am confused if I have to manually setup slony-I replication for all databases. As the interface which I have seen for slony-I setup, it has given replication tab under every database.
If I have to manually define replication master and slave node for any database I am creating then it is not a feasible option for me to use Slony-I.
SLONY-I = Is it possible that all the databases getting created on Master Node will be replicated to specified Slave node.

So, I thought of PGCluster. But it comes with multi-master replication.
PGCluster = Is it possible that I can configure Master-Slave replication in PGCluster.

Please let me know if I am unclear in any point. Any input will be a great help.

Thanks in advance.

--
Regards,
Manasi Save

--=_5v95viiei08
Content-Description: HTML Version of Message
Content-Type: text/html;
charset=UTF-8
Content-Disposition: inline
Content-Transfer-Encoding: 7bit
Content-ID: fvxex7ftuw8 [at] mail.artificialmachines.com

<div id="html-message">
<div id="html-message">
Hi All,
I am very new to Postgres in that I have to setup
replication. For Which I am very confused between Postgres's replication
types.I want a sychronized but a master-slave replication.I have
read about Slony-I replication method. But I am confused if I have to manually
setup slony-I replication for all databases. As the interface which I have seen
for slony-I setup, it has given replication tab under every database. If
I have to manually define replication master and slave node for any database I
am creating then it is not a feasible option for me to use
Slony-I.SLONY-I = Is it possible that all the databases getting created
on Master Node will be replicated to specified Slave node. So, I thought of PGCluster. But it comes with multi-master replication.
PGCluster = Is it possible that I can configure Master-Slave replication
in PGCluster.
Please let me know if I am unclear in any
point. Any input will be a great help.
Thanks in advance.

--

Regards,

Manasi Save

</div></div>

--=_5v95viiei08--

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

On Fri, 2010-02-19 at 05:49 -0500, Manasi Save wrote:
> I want a sychronized but a master-slave replication.
<snip>

> So, I thought of PGCluster.

Forget about it. Check pgcluster archives about recent discussions about
it. There is no stable sync replication solution for PostgreSQL right
now.

Regards,
--
Devrim G=C3=9CND=C3=9CZ, RHCE
PostgreSQL Dan=C4=B1=C5=9Fman=C4=B1/Consultant, Red Hat Certified Engineer
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz

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

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

iEYEABECAAYFAkt+gCQACgkQtl86P3SPfQ7qNACfXuGI+zfclQYf4ycufK/p FsJV
vw8An1lu/PwyCHjUVXbaaLtw+NMETvV6
=ftv7
-----END PGP SIGNATURE-----

--=-6DYTYbbfs83jsKRYWP7h--

On Fri, 2010-02-19 at 05:49 -0500, Manasi Save wrote:
> Hi All,
>
>
> I am very new to Postgres in that I have to setup replication. For
> Which I am very confused between Postgres's replication types.
>
> I want a sychronized but a master-slave replication.
>
> I have read about Slony-I replication method. But I am confused if I
> have to manually setup slony-I replication for all databases. As the
> interface which I have seen for slony-I setup, it has given
> replication tab under every database.

With Slony, you must set up every database, table, and sequence you want
to replicate yourself.

Slony is an asynchronous replication engine, btw.

> If I have to manually define replication master and slave node for any
> database I am creating then it is not a feasible option for me to use
> Slony-I.
>
> SLONY-I = Is it possible that all the databases getting created on
> Master Node will be replicated to specified Slave node.

Not possible.

>
> So, I thought of PGCluster. But it comes with multi-master
> replication.
>
> PGCluster = Is it possible that I can configure Master-Slave
> replication in PGCluster.
>
>
> Please let me know if I am unclear in any point. Any input will be a
> great help.

What do you need replication for? DR? Query offloading? Custom schema
or data transformations on a replica?

Can you justify the cost warm standby hardware?

--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.

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

On Friday 19 February 2010 06:27:10 Brad Nicholson wrote:
> On Fri, 2010-02-19 at 05:49 -0500, Manasi Save wrote:
> > Hi All,
> >
> >
> > I am very new to Postgres in that I have to setup replication. For
> > Which I am very confused between Postgres's replication types.
> >
> > I want a sychronized but a master-slave replication.
> >
> > I have read about Slony-I replication method. But I am confused if I
> > have to manually setup slony-I replication for all databases. As the
> > interface which I have seen for slony-I setup, it has given
> > replication tab under every database.
>
> With Slony, you must set up every database, table, and sequence you want
> to replicate yourself.
>
>
> Slony is an asynchronous replication engine, btw.
>
> > If I have to manually define replication master and slave node for any
> > database I am creating then it is not a feasible option for me to use
> > Slony-I.
> >
> > SLONY-I = Is it possible that all the databases getting created on
> > Master Node will be replicated to specified Slave node.

SLONY is database specific, not cluster specific, so you'll need to create a
SLONY replication cluster (which may or may not have multiple replication
sets) for each database that you want to replicate

It's pretty straight forward but it is a manual setup and there are some down
sides depending on what your use case is, for example if all your write
connections are hitting the master and you want to do a switch-over so you can
bring the current master node down for maintenance, things can become overly
complicated trying to coordinate the switchover commands for each
cluster/replication set.

The easy fix is to stop or pause application traffic during the switch, then it
becomes a non issue.

However if this is not an option you could end up with a tough issue in that
say one db switches over quickly and another takes more time at which point
you have the master for one db on node2 and the other still on node1 thus
until the other db finishes it's switch you have a scenario where writes for
db1 are only allowed on node2 and writes for db2 are only allowed on node1.

>
> Not possible.
>
> > So, I thought of PGCluster. But it comes with multi-master
> > replication.
> >
> > PGCluster = Is it possible that I can configure Master-Slave
> > replication in PGCluster.
> >
> >
> > Please let me know if I am unclear in any point. Any input will be a
> > great help.
>
> What do you need replication for? DR? Query offloading? Custom schema
> or data transformations on a replica?
>
> Can you justify the cost warm standby hardware?
>

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

This is a multi-part message in MIME format.

------=_NextPart_000_01BC_01CAB3D5.677A1360
Content-Type: text/plain;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable

PGcluster doesn=E2=80=99t work. One year ago we where trying to deploy a =
cluster
using pgcluster and we were unable to get it work without problems.

We finally selected slony. It works quite well and it=E2=80=99s quite eas=
y to deploy
by following tutorials. We worked with slony-I. However, slony only
replicate data. You have to replicate manually triggers, functions, index=
es,
etc if you use them.

We also tested pg pool and this one works very good. However you have to
deal with some minor issues if you use special functions that make use of=

timestamps or random, for example. If you don=E2=80=99t use this kind of =
functions,
you could test pg_pool.

Pg_pool is easier to deploy than slony and also provides load balancing f=
or
reading.

De: Manasi Save [mailto:manasi.save [at] artificialmachines.com]
Enviado el: viernes, 19 de febrero de 2010 11:49
Para: pgsql-admin [at] postgresql.org
Asunto: [ADMIN] Using Postgresql Replication

Hi All,

I am very new to Postgres in that I have to setup replication. For Which =
I
am very confused between Postgres's replication types.

I want a sychronized but a master-slave replication.

I have read about Slony-I replication method. But I am confused if I have=
to
manually setup slony-I replication for all databases. As the interface wh=
ich
I have seen for slony-I setup, it has given replication tab under every
database.

If I have to manually define replication master and slave node for any
database I am creating then it is not a feasible option for me to use
Slony-I.

SLONY-I =3D Is it possible that all the databases getting created on Mast=
er
Node will be replicated to specified Slave node.

So, I thought of PGCluster. But it comes with multi-master replication.

PGCluster =3D Is it possible that I can configure Master-Slave replicatio=
n in
PGCluster.

Please let me know if I am unclear in any point. Any input will be a grea=
t
help.

Thanks in advance.

--
Regards,
Manasi Save

------=_NextPart_000_01BC_01CAB3D5.677A1360
Content-Type: text/html;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-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=3DContent-Type content=3D"text/html; charset=3Dutf-8">
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<style>

</style>

</head>

<body lang=3DES link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

PGcluster doesn=E2=80=99t work. One year ago we where =
trying to deploy a
cluster using pgcluster and we were unable to get it work without =
problems.<o:p></o:p>

<o:p> </o:p>

We finally selected slony. It works quite well and =
it=E2=80=99s quite
easy to deploy by following tutorials. We worked with slony-I. However, =
slony
only replicate data. You have to replicate manually triggers, functions,
indexes, etc if you use them.<o:p></o:p>

<o:p> </o:p>

We also tested pg pool and this one works very good. =
However you
have to deal with some minor issues if you use special functions that =
make use of
timestamps or random, for example. If you don=E2=80=99t use this kind of =
functions, you
could test pg_pool.<o:p></o:p>

Pg_pool is easier to deploy than slony and also provides =
load
balancing for reading.<o:p></o:p>

<o:p> </o:p>

<o:p> </o:p>

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

De:</=
b> Manasi =
Save
[mailto:manasi.save [at] artificialmachines.com] 
Enviado el: viernes, 19 de febrero de 2010 11:49 
Para: pgsql-admin [at] postgresql.org 
Asunto: [ADMIN] Using Postgresql =
Replication<o:p></o:p>

</div>

<o:p> </o:p>

<div id=3Dhtml-message>

<div id=3Dhtml-message>

Hi All,<o:p></o:p>

<o:p> </o:p>

I am very new to Postgres in that I have to setup replication. For =
Which I
am very confused between Postgres's replication types.<o:p></o:p>

I want a sychronized but a master-slave replication.<o:p></o:p>

I have read about Slony-I replication method. But I am confused if I =
have to
manually setup slony-I replication for all databases. As the interface =
which I
have seen for slony-I setup, it has given replication tab under every =
database.
<o:p></o:p>

If I have to manually define replication master and slave node for =
any
database I am creating then it is not a feasible option for me to =
use
Slony-I.<o:p></o:p>

SLONY-I =3D Is it possible that all the databases getting created on =
Master Node
will be replicated to specified Slave node.<o:p></o:p>

<o:p> </o:p>

So, I thought of PGCluster. But it comes with multi-master =
replication. <o:p></o:p>

PGCluster =3D Is it possible that I can configure Master-Slave =
replication in
PGCluster.<o:p></o:p>

<o:p> </o:p>

Please let me know if I am unclear in any point. Any input will be a =
great
help.<o:p></o:p>

<o:p> </o:p>

Thanks in advance.<o:p></o:p>

 
-- 
Regards, 
Manasi Save <o:p></o:p>

</div>

</div>

</div>

</body>

</html>

------=_NextPart_000_01BC_01CAB3D5.677A1360--

Using Postgresql Replication

Re: Using Postgresql Replication

Re: Using Postgresql Replication

Re: Using Postgresql Replication

Re: Using Postgresql Replication