On Thu, Feb 26, 2009 at 3:35 PM, Adrian Klaver <aklaver@comcast.net> 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@comcast.net> wrote:
>> > ----- "najmuddin hassan" <najios1@gmail.com> 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.