Thread: Re: Notes on converting from MySQL 5.0.x to PostgreSQL

Re: Notes on converting from MySQL 5.0.x to PostgreSQL

From
Franz.Rasper@izb.de
Date:
Yes indeed if it would be possible, it should go to the website.
Good comparison without saying such things like this dbms has xx features
and this one has xx features.

Some addtitional information for setcion "Further information:"
phpPgAdmin http://phppgadmin.sourceforge.net/

Gborg http://gborg.postgresql.org/

Greetings,

-Franz


-----Ursprüngliche Nachricht-----
Von: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Gesendet: Freitag, 30. Juni 2006 16:17
An: Jason McManus
Cc: pgsql-general@postgresql.org
Betreff: Re: [GENERAL] Notes on converting from MySQL 5.0.x to PostgreSQL
8.1.4


"Jason McManus" <mcmanus.jason@gmail.com> writes:
> I am in the process of converting a couple of major sites from MySQL
5.0.22
> to PostgreSQL 8.1.4, and I thought I would share some of my observations
on
> this process and the two database systems in general.

Nice notes!  I see only one small error:

> * Pg's default character set (in 8.1.4) is UTF8.

I don't believe there is any fixed "default character set".  Each
installation will have a default locale and encoding, but these depend
on the locale under which initdb was run.  From the above comment I
surmise that you initdb'd under some UTF8-using locale ...

> Thank you, and I hope that these notes prove helpful to others!

Perhaps they should go on the project website somewhere?

            regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings