Re: systems 2007 ...

On Oct 30, 2007, at 8:48 AM, Stefan Kaltenbrunner wrote:

> Hans-Juergen Schoenig wrote:
>> On Oct 30, 2007, at 12:12 AM, Simon Riggs wrote:
>>> On Sat, 2007-10-27 at 08:47 +0200, Hans-Juergen Schoenig wrote:
>>>
>>>> - "what is the difference between MySQL and PostgreSQL?"
>>>> - "we use PostgreSQL; we are so happy; keep doing "
>>>> - "we use Oracle, is PostgreSQL as powerful as Oracle?"
>>>
>>> Sounds familiar. I also get "Does Postgres do replication?"
>>>
>> yeah, i definitely missed that one ...
>> the MySQL transaction log shipping is definitely something people
>> are asking for.
>> it would definitely make sense to implement the streaming stuff
>> Hannu has suggested along with the "slave read / only" feature.
>> it takes away a lot of pressure on the argumentation side.
>
> well slony already has a file based log shipping facility - but a
> WAL based solution in combination with being able to read from a
> cluster in recovery mode (ie the stuff Florian is working on) would
> be nice ...
>
>
> Stefan

i tried the Slony WAL shipping stuff some time ago. it was one of the
reasons why SkyTools have been implemented, I would think :).
the stuff Florian is working on is much more promising as we have a
binary copy of the master in this case.

many thanks,

hans

--
Cybertec Schönig & Schönig GmbH
Gröhrmühlgasse 26, 2700 Wiener Neustadt
Tel: +43/1/205 10 35 / 340
www.postgresql.at, www.cybertec.at