| From: | Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk> |
|---|---|
| To: | Simon Windsor <simon(dot)windsor(at)cornfield(dot)org(dot)uk> |
| Cc: | "pgsql-general (at) postgresql (dot) org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Moving from MySQL |
| Date: | 2003-08-11 08:38:08 |
| Message-ID: | 20030811093808.A24774@bacon |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 09/08/2003 01:41 Simon Windsor wrote:
> Hi
>
> I am sorry for mailing this list directly, but I am planning to migrate a
> web application from MySQL to Postgres. I am aware of a number of
> applications to help in this process, ie my2pg, etc. The biggest
> stumbling block I face is replication.
>
> What facilities exist within Postgres to replicate data from one instance
> to another?
There are several replication mechanisms available for PostgreSQL. The two
shipped with it are dbmirror and rserv. I believe that rserv will shortly
be replaced by erserv, which is based on rsev and uses Java instead of
perl.
> Which version of Postgres would people to recommend?
The latest production release is 7.3.4. I'd recoomend using that.
HTH
--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants |
http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oleg Bartunov | 2003-08-11 08:51:05 | Re: Tsearch limitations |
| Previous Message | Oleg Bartunov | 2003-08-11 08:33:19 | Re: PostgreSQL |