Re: [Phpgroupware-users] Database migration from mySQL to PostgreSQL

[Alex Borges (lex)]

Yes.... ive made this change....its very easy:

0.- PLAN FOR IT TO GO WRONG. Mine stabilized in about a week, but it was
old versions of phpgw, pgsql and mysql.

1.- Get the schema created in a clean database by normally installing
phpgw over pgsql

2.- Mysql Dump your stuff in something as close to plain SQL as you can.
This means try and make it all single quoted, clear, case sensitive
inserts.

3.- psql databse < dump

4.- Fix transitional errors

5.- Test like a mofo

6.- BEWARE.... pgsql 7.2 works fine as-is, pgsql 7.3 however has some
issues that can be resolved by patching phpgw. Im shure someone here
will let you know where the patches are (i use debian woody so im in
confortably old pgsql versions)

El lun, 17 de 02 de 2003 a las 08:35, Koller Daniel escribió:
> Hello,
> 
> Due to a planned change in our deployment environment, I'm thinking of 
> changing the database from mySQL to PostgreSQL.
> 
> My question is now, whether in the field of users there is some experience 
> present, regarding 
> - switching from mySQL to PostgreSQL, and more in general,
> - building up a phpgw-system from a database dump.
> 
> Kind regards,
> 
> Daniel
> 
> ----------------------------------------------------------------------------------------
> EuroGames 2004 in Munich
> 
> Daniel Koller
> 
> EuroBoard (Vorstand)              Tel.:  0163/ 6191979
> Logistik & IT                           eMail: address@hidden
> 
> 
> _______________________________________________
> Phpgroupware-users mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/phpgroupware-users
-- 
Alex Borges (lex) <address@hidden>
Step One Group