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. -- Adrian Klaver aklaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general