On Thu, Feb 26, 2009 at 3:35 PM, Adrian Klaver <aklaver@xxxxxxxxxxx> wrote: > On Thursday 26 February 2009 1:51:10 pm Scott Marlowe wrote: >> On Thu, Feb 26, 2009 at 2:03 PM, Adrian Klaver <aklaver@xxxxxxxxxxx> wrote: >> > ----- "najmuddin hassan" <najios1@xxxxxxxxx> wrote: >> >> Hi, >> >> >> >> I just installed a program called moteview by crossbow technologies. >> >> It uses >> >> postgreSQL 8.0.0-rc1 for its database. There is something wrong as >> >> when I >> > >> > Yes 8.0 is an old version, but in this instance I would use >> > what is bundled with the program. There have been a lot of >> > changes between 8.0 and 8.3 and chances are the application >> > will have problems with them. So first get rid of 8.3 and >> > reinstall the bundled app/db. Try to connect and if not >> > successful post the error messages here. >> >> No way. I might run 8.0.x where x is the latest version of 8.0, but I >> would not run any system I depended on on 8.0.0.rc. >> >> It looks like the OPs problems have to do with client authentication >> and what not. > > I would agree with your recommendation to run the latest 8.0.x in all cases > except this one. The issue is that Moteview is an app bundled with Postgres and > seems to have some setup scripts included to get things started. I am trying to > get the OP back to the baseline setup and establish that the app works out of > the box as designed by the app developers. Once that happens then it is > possible to move forward. My guess that what is happening is cross > contamination between the set up from the original install and the manual > upgrade to 8.3. Starting from the beginning narrows the variables. I seriously doubt it's anything more than postgresql.conf and pg_hba.conf settings that's keep him out. While it's possible they've built a custom database with all kinds of fancy UDFs and all, I kinda doubt anyone with the brains to do that would be bundling 8.0.0-rc1. But anything's possible. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
