470,581 Members | 2,427 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,581 developers. It's quick & easy.

Moving from MySQL

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
2 1718
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

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.

Similar topics

reply views Thread by Creigh Shank | last post: by
3 posts views Thread by Jon Miller | last post: by
reply views Thread by Jon Miller | last post: by
4 posts views Thread by Stephen Ghelerter | last post: by
reply views Thread by Don Rozenberg | last post: by
2 posts views Thread by moller | last post: by
2 posts views Thread by fuzzybr80 | last post: by
1 post views Thread by livre | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.