Re: PostgreSQL support

Heya,

> Ummm... that's odd.  They should be 14 digits.

Definitely, yes.

> Actually, would you care to give me a step-by-step on doing a
> mysql->postgres conversion?  I tried and had all kinds of issues.
> Might have been due to the sequence issues tho, not sure.

Well, I can try to re-create what I've done, but it was right after
Christmas ;) Anyway, I started with a mysqldump of the anthill database
and then used the script Russell Valentine posted a link to a couple of
days earlier (http://www.xach.com/aolserver/mysql2psql.pl).

The next thing I tried was creating the DB structure with
etc/pgsql.dump. Afterwards I imported the converted dump and tried to do
something with Anthill. Right away it backfired because of the
sequences, so I figured out the names PEAR wanted to use and set up the
sequences myself. I also altered pgsql.dump, sent a mail with the new
one to this ml, then manually set the sequence IDs with 'select
setval('bla_id', 4);'.

I know that I encountered a couple of problems, but I cannot remember
them in full detail. It definitely wasn't easy, and this is not
something I'd happily do with a big database. Luckily my Anthill DB was
pretty small (only 25 bugs or so with a couple of attachments and as
many users), so the process was not too time consuming.

If you really want me to I could re-do all those steps and take notes
along the way.

Mosu


-- 
If Darl McBride was in charge, he'd probably make marriage
unconstitutional too, since clearly it de-emphasizes the commercial
nature of normal human interaction, and probably is a major impediment
to the commercial growth of prostitution. - Linus Torvalds

_______________________________________________
Anthill-workers mailing list
Anthill-workers-+mQDA36h6dWw5LPnMra/[email protected]
http://vmlinuz.ca/mailman/listinfo/anthill-workers

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQE/+xjnTJ9OsraNuaERAh/kAJ4/4+d9VTX8v8xlmO1qA68LsKcLvwCcCXtC
oRArZtN9Abvt6kDKX9FAP4E=
=HYZt
-----END PGP SIGNATURE-----