On Sat, 28 Jan 2006, Roderick A. Anderson wrote:
Hi Rich. Seems once again we're meeting in the same places. The Internet sure seems small sometimes.
Hello, again, Rod.
I saw all the other posts but you might look at dbwrench (a Java application). Does a lot more than what you need (plus after 30 days costs approx. $150) but our lead programmer is using it to reverse engineer a MySQL database he shoe-horned into PostgreSQL. He loves it.
There has been someone else working on this effort to move XRMS from strictly MySQL to PostgreSQL, and he's been at it longer. But, it's almost there now. The install script generated an error message with every create statement, but the tables were created anyway. But, the indices are wrong and the dates have screwy values. I printed the web page as a .ps file and sent that to the developers. They told me what the most likely cause was, so I'll go through the install.xml file and make their recommended changes, then re-run the install script. So this is very close to working and it's a one-shot deal for me. At OSCON last summer I spoke with the SugarCRM sales folks. They said that they received many requiests to add PostgreSQL support, but management wants to stick with MySQL. You'll recall from the other mail list that I had a time getting MySQL properly installed and configured just to run this one application. After trying it for a while I discovered that I really didn't like it. I think XRMS will do much better. On the other side of this thread, the command line pg_dump worked with the proper syntax. I think it was the two original replies (one with a command line solution, the other with a psql solution) that confused me. Why none of the psql commands are working for me I don't know. But, pg_dump works just fine. Thanks to everyone. Rich -- Richard B. Shepard, Ph.D. | Author of "Quantifying Environmental Applied Ecosystem Services, Inc. (TM) | Impact Assessments Using Fuzzy Logic" <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org