By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,781 Members | 1,255 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,781 IT Pros & Developers. It's quick & easy.

Moving from MySQL

P: n/a
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: 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.
Nov 11 '05 #1
Share this Question
Share on Google+
2 Replies

P: n/a
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: 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.



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

Nov 11 '05 #2

P: n/a

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

Nov 11 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.