Re: [GENERAL] Notes on converting from MySQL 5.0.x to PostgreSQL 8.1.4

2006-07-03 Thread Robert Treat
On Friday 30 June 2006 09:17, Jason McManus wrote: > On Converting from MySQL 5.0.x to PostgreSQL 8.1.x > * There is a conversion utility called 'mysql2pgsql' that will convert > dump files from the mysqldump format, to a format that psql can > understand. It is available at: > - http://gbor

Techdocs error (WAS: RE: [GENERAL] Notes on converting from MySQL 5.0.x to PostgreSQL 8.1.4)

2006-07-02 Thread Dave Page
Hmm, not good - I've forwarded this to the techdocs author. Regards, Dave -Original Message- From: "Jason McManus" <[EMAIL PROTECTED]> To: "Dave Page" Cc: "pgsql-general@postgresql.org" Sent: 02/07/06 05:00 Subject: Re: [GENERAL] Notes on conver

Re: [GENERAL] Notes on converting from MySQL 5.0.x to PostgreSQL 8.1.4

2006-07-01 Thread Jason McManus
Hi Dave, Documentation such as this can be added to the new techdocs area on the main site at http://www.postgresql.org/docs/techdocs under the relevant section (probably http://www.postgresql.org/docs/techdocs.3 in this case). Please note that the editting interface is still new and may still

Re: [GENERAL] Notes on converting from MySQL 5.0.x to PostgreSQL 8.1.4

2006-06-30 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane > Sent: 30 June 2006 15:47 > To: Jason McManus > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Notes on converting from MySQL 5.0.x > to PostgreSQL 8.

Re: [GENERAL] Notes on converting from MySQL 5.0.x to PostgreSQL 8.1.4

2006-06-30 Thread Tom Lane
"Jason McManus" <[EMAIL PROTECTED]> writes: >> Perhaps they should go on the project website somewhere? > I was thinking so as well, but I'm not sure where, or who to submit to > if there is no wiki or other external editing method. Any pointers > for who to contact/where to submit? Not my depar

Re: [GENERAL] Notes on converting from MySQL 5.0.x to PostgreSQL 8.1.4

2006-06-30 Thread Jason McManus
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 ... Ah, great. Thank you for the cl

Re: [GENERAL] Notes on converting from MySQL 5.0.x to PostgreSQL 8.1.4

2006-06-30 Thread Tom Lane
"Jason McManus" <[EMAIL PROTECTED]> 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:

[GENERAL] Notes on converting from MySQL 5.0.x to PostgreSQL 8.1.4

2006-06-30 Thread Jason McManus
On Converting from MySQL 5.0.x to PostgreSQL 8.1.x -- 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 i