Thread: simple replication
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
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
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?
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
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