Moving from MySQL

[Simon Windsor]

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: si***********@cornfield.org.uk
Tel: [phone]
Mob: [phone]
--

This message has been scanned for viruses and dangerous content by
MailScanner, http://www.mailscanner.info, and is believed to be clean.

[Chris Travers]

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: si***********@cornfield.org.uk
<mailto:si***********@cornfield.org.uk>
Tel: [phone]
Mob: [phone]

This message has been scanned for viruses and dangerous content by
*MailScanner* <http://www.mailscanner.info/>, and is believed to be
clean.

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

[Paul Thomas]

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 |
+------------------------------+---------------------------------------------+

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org