> > > I currently maintain a website which is deployed on LAMP, > but it is > > > developed on Windows (WAMP?). I'm considering moving both to use > > > PostgreSQL. I'm curious as to whether others are following a > > > similar development/deployment model and if so, what > > > pitfalls/gotchas they have found. For example, I refresh > production > > > tables on a weekly basis from the development database. > Linux MySQL > > > is case-sensitive about table names but Windows isn't, so > I have to > > > modify table names like 'whatsnew' on Windows to > 'WhatsNew' before I > > > can run the reload script on Linux. > > > > [snip replication - can't answer that] > > Regarding replication, the Slony-I guys state that their > project is not yet ported to Windows, but giving that there > is a pthread library for Windows (which is about the only > thing it lacks, apparently) then it should be possible to > port it rather easily. I'm sure they'd welcome it if > somebody were to do the legwork. I know of several people > who would be very glad to have Win32 Slony-I. Dave, Andreas, me and Hiroshi are working on this. It's not at top-speed right now due to the main projects feature freeze, but work is in progress, and it's definitly doable. (Hey, I knew that. Should've answered from the beginning :P) //Magnus ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly