Re: Install problems for postgresql-8.4.1

On Nov 2, 2009, at 3:43 PM, Michael Wood wrote:

> 2009/11/2 Mark H. Nichols <info(at)markhnichols(dot)com>:
>>
>> On Nov 2, 2009, at 1:39 PM, Tom Lane wrote:
>>
>>> Don Fox <donfox1(at)mac(dot)com> writes:
>>>>
>>>> bash-3.2$ createdb -T template1 fromtemp0db
>>>> Bus error
>>>> bash-3.2$
>
> Yes, I'm not surprised.
>
>>> This appears to be the createdb program itself crashing, not the
>>> server.
>>> That cuts down the alternatives quite a lot, because createdb isn't
>>> much; it basically just tries to connect via libpq and send a CREATE
>>> DATABASE command to the server. My first thought is that you have a
>>> corrupt libpq.so, or one that is incompatible with your createdb
>>> executable. You could check some of the more obvious causes by
>>> seeing what "file" and "otool -L" have to say about createdb and
>>> libpq.so.
>>>
>>> regards, tom lane
>>
>> Would a potentially corrupt createdb program indicate that the
>> download of
>> Postrgres was somehow corrupt? Can you download the checksum and
>> verify that
>> your download is complete and undamaged?
>
> No, it's highly unlikely to have compiled if it was corrupt. It's
> more likely something like an old version of libpq being used by
> createdb as Tom seems to imply.
>
> Don, do any of the other commands work? e.g. psql? Or createuser?

> createuser seems ok but psql is not recognized. I did a 'find' to
> locate the libpg.so but couldn't locate it. Could someone tell me
> where it is.

Don

> --
> Michael Wood <esiotrot(at)gmail(dot)com>
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice