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: 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.
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
What sort of needs do you have?
Simon Windsor wrote:
Show quoted text
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 447385This message has been scanned for viruses and dangerous content by
*MailScanner* <http://www.mailscanner.info/>, and is believed to be
clean.
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 |
+------------------------------+---------------------------------------------+