PostgreSQL Administration

Author

Replication

vespadict

2005-09-16, 7:23 am

Hello,

I need to replicate two databases in diferents servers . I'm reading
about some projects but i'm not sure what is the best option. I found
interesting dbmirror and pgcluster but I have doubts . Please , May you
help me ? .

Thanks

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly

Scott Marlowe

2005-09-16, 11:23 am

On Fri, 2005-09-16 at 03:35, vespadict wrote:
> Hello,
>
> I need to replicate two databases in diferents servers . I'm reading
> about some projects but i'm not sure what is the best option. I found
> interesting dbmirror and pgcluster but I have doubts . Please , May you
> help me ? .

Do you need automatic failover of some kind, async or sync replication,
one way or two way, etc...

My personal favorite two tools of late have been pgpool and slony.
dbmirror, if I remember correctly, has to be installed by modifying the
internals of postgresql, and I'm not sure how up to date it is.
Pgcluster seems to be a decent choice, but I've not played with it.

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

the vespadict

2005-09-19, 3:25 am

Hi ,

I want high Availability but I don't need load balance. I need sync
replication if is posible using two way.

Thak you.

2005/9/16, Scott Marlowe < smarlowe@g2switchwor
ks.com>:
> On Fri, 2005-09-16 at 03:35, vespadict wrote:
>
> Do you need automatic failover of some kind, async or sync replication,
> one way or two way, etc...
>
> My personal favorite two tools of late have been pgpool and slony.
> dbmirror, if I remember correctly, has to be installed by modifying the
> internals of postgresql, and I'm not sure how up to date it is.
> Pgcluster seems to be a decent choice, but I've not played with it.
>

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Scott Marlowe

2005-09-19, 8:24 pm

On Mon, 2005-09-19 at 02:02, the vespadict wrote:
> Hi ,
>
> I want high Availability but I don't need load balance. I need sync
> replication if is posible using two way.

If you need sync, then pgpool may be a good choice, or client side
replication like C-JDBC or something like that.

pgpool doesn't HAVE to do load balancing, it can do simple two way sync
replication if that's what you need.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly

Jim C. Nasby

2005-09-20, 1:24 pm

There's also pgcluster, but keep in mind that these are all
statement-level replication solutions which have some rather big
gotchas.

On Mon, Sep 19, 2005 at 03:24:31PM -0500, Scott Marlowe wrote:
> On Mon, 2005-09-19 at 02:02, the vespadict wrote:
>
> If you need sync, then pgpool may be a good choice, or client side
> replication like C-JDBC or something like that.
>
> pgpool doesn't HAVE to do load balancing, it can do simple two way sync
> replication if that's what you need.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql
.org so that your
> message can get through to the mailing list cleanly
>

--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Craig Servin

2005-09-20, 1:24 pm

Are there any non-statement level solution? Something that appends to the WAL
on the slave server?

On Tuesday 20 September 2005 12:28 pm, Jim C. Nasby wrote:[color=darkred
]
> There's also pgcluster, but keep in mind that these are all
> statement-level replication solutions which have some rather big
> gotchas.
>
> On Mon, Sep 19, 2005 at 03:24:31PM -0500, Scott Marlowe wrote:

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Aldor

2005-09-23, 7:23 am

>Are there any non-statement level solution? Something that appends to

the WAL

For this kind of solution I'm also looking for a while - but in the
meantime you can also take a look at "slony" - it can do really many
things. Don't give up at the beginning, after you've understood how it
works you will like it ;-)

Craig Servin wrote:[color=darkred
]
> Are there any non-statement level solution? Something that appends to the WAL
> on the slave server?
>
>
>
> On Tuesday 20 September 2005 12:28 pm, Jim C. Nasby wrote:
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Sponsored Links