Re: PostgreSQL support

On Jan 06, 2004, at 13:21, Moritz Bunkus wrote:

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

I wonder why it came out as 13?  It's definitely stored as 14.

>> 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).

I must have missed that.  I'll have to check it out.

> 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);'.

Yeah, I had to do that too.

> 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.

I tried doing it with a 350-bug database.  I gave up.  =)

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

If you have the time, it would be greatly appreciated.

BTW, all the gettext stuff you sent (except for the theme stuff) has 
been committed.  Still debating whether or not I want to do the theme 
stuff now or after 0.3.0 is out the door.

I've also just got postgresql installed (not yet configured) on my 
powerbook so I hope to be able to get back into the postgresql testing 
by the weekend.  Want to give it a fresh start, play around, and make 
sure nothing odd happens.  If that succeeds, then beta1 will be coming 
(or test2 if I decide to do the templating stuff now).

---
MandrakeSoft Security; http://www.mandrakesecure.net/
Online Security Resource Book; http://linsec.ca/
"lynx -source http://linsec.ca/vdanen.asc | gpg --import"
{FE6F2AFD : 88D8 0D23 8D4B 3407 5BD7  66F9 2043 D0E5 FE6F 2AFD}

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