simple replication

Started by Edoardoover 18 years ago5 messages
#1Edoardo
ridleys@gmail.com

Hi,

I am searching for a simple replication solution for postgres and I
found some webpages and forum threads like this one:

http://groups.google.com/group/pgsql.performance/browse_thread/thread/8e79c0b0136964e8/fa8692ca4f987722?lnk=st&q=skytools+postgres+replication&rnum=9#fa8692ca4f987722

basically we have

- slony 1,
- PGCluster
- Skytools
- Google Summer of Code effort by Florian Pflug

I would like to talk about the last one: I couldn't find any website /
explanation or further post.
The google link http://code.google.com/soc/postgres/appinfo.html?csaid=6545828A8197EBC6
is broken
does anybody knows something about it?

Thanks
Edoardo

#2Heikki Linnakangas
heikki@enterprisedb.com
In reply to: Edoardo (#1)
Re: simple replication

Edoardo wrote:

- Google Summer of Code effort by Florian Pflug

I would like to talk about the last one: I couldn't find any website /
explanation or further post.
The google link http://code.google.com/soc/postgres/appinfo.html?csaid=6545828A8197EBC6
is broken
does anybody knows something about it?

He's working on allowing you to perform read-only queries on a warm
standby server. Currently, the warm standby can't be used for queries
until you fail over to it.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

#3Edoardo
ridleys@gmail.com
In reply to: Heikki Linnakangas (#2)
Re: simple replication

On Aug 24, 4:27 pm, hei...@enterprisedb.com ("Heikki Linnakangas")
wrote:

Edoardo wrote:

- Google Summer of Code effort by Florian Pflug

I would like to talk about the last one: I couldn't find any website /
explanation or further post.
The google linkhttp://code.google.com/soc/postgres/appinfo.html?csaid=6545828A8197EBC6
is broken
does anybody knows something about it?

He's working on allowing you to perform read-only queries on a warm
standby server. Currently, the warm standby can't be used for queries
until you fail over to it.

Even like this is worth considering this solution in my scenario, do
you think I can have a look at his work?

#4Florian G. Pflug
fgp@phlo.org
In reply to: Edoardo (#3)
Re: simple replication

Edoardo wrote:

On Aug 24, 4:27 pm, hei...@enterprisedb.com ("Heikki Linnakangas")
wrote:

Edoardo wrote:

- Google Summer of Code effort by Florian Pflug
I would like to talk about the last one: I couldn't find any website /
explanation or further post.
The google linkhttp://code.google.com/soc/postgres/appinfo.html?csaid=6545828A8197EBC6
is broken
does anybody knows something about it?

He's working on allowing you to perform read-only queries on a warm
standby server. Currently, the warm standby can't be used for queries
until you fail over to it.

Even like this is worth considering this solution in my scenario, do
you think I can have a look at his work?

The archive of the pgsql-hackers list contains some discussion of my work.
I can also send you the latest version - though it's absolutely not ready
for production use at this point. It's more of a prototype, to find out where
the problems of lie, and how to overcome them.

Work on this won't stop with the end of GSoC, and I'm not the only one
interested in making this happen - so there is a realistic chance that
something like this will show up in postgres sooner or later - not promises,
though..

greetings, Florian Pflug

#5Edoardo
ridleys@gmail.com
In reply to: Florian G. Pflug (#4)
Re: simple replication

On Aug 24, 11:09 pm, f...@phlo.org ("Florian G. Pflug") wrote:

Edoardo wrote:

On Aug 24, 4:27 pm, hei...@enterprisedb.com ("Heikki Linnakangas")
wrote:

Edoardo wrote:

- Google Summer of Code effort by Florian Pflug
I would like to talk about the last one: I couldn't find any website /
explanation or further post.
The google linkhttp://code.google.com/soc/postgres/appinfo.html?csaid=6545828A8197EBC6
is broken
does anybody knows something about it?

He's working on allowing you to perform read-only queries on a warm
standby server. Currently, the warm standby can't be used for queries
until you fail over to it.

Even like this is worth considering this solution in my scenario, do
you think I can have a look at his work?

The archive of the pgsql-hackers list contains some discussion of my work.
I can also send you the latest version - though it's absolutely not ready
for production use at this point. It's more of a prototype, to find out where
the problems of lie, and how to overcome them.

Work on this won't stop with the end of GSoC, and I'm not the only one
interested in making this happen - so there is a realistic chance that
something like this will show up in postgres sooner or later - not promises,
though..

ok, looking forward to it then... thank you very much.
Edoardo