Postgres Pro
Downloads
Home   >   mailing lists

Thread: Moving from MySQL

Moving from MySQL

From
"Simon Windsor"
Date:
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?
Which version of Postgres would people to recommend?
 
Many thanx
 
Simon Windsor
Email: simon.windsor@cornfield.org.uk
Tel: 01454 617689
Mob: 07720 447385

This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.

Re: Moving from MySQL

From
Chris Travers
Date:
What sort of needs do you have?

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?
> Which version of Postgres would people to recommend?
>
> Many thanx
>
> Simon Windsor
> Email: simon.windsor@cornfield.org.uk
> <mailto:simon.windsor@cornfield.org.uk>
> Tel: 01454 617689
> Mob: 07720 447385
>
> This message has been scanned for viruses and dangerous content by
> *MailScanner* <http://www.mailscanner.info/>, and is believed to be
> clean.

Re: Moving from MySQL

From
Wolfgang Kueter
Date:
Simon Windsor wrote:


> What facilities exist within Postgres to replicate data from one instance
> to another?

RTFF:
http://www.postgresql.org/docs/faqs/FAQ.html#4.27

wolfgang

Re: Moving from MySQL

From
Paul Thomas
Date:
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   |
+------------------------------+---------------------------------------------+