Re: systems 2007 ...

[Hans-Juergen Schoenig <hs ( at ) cybertec ( dot ) at>]

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