Re: Install problems for postgresql-8.4.1

2009/11/2 Mark H. Nichols <info@markhnichols.com>:

On Nov 2, 2009, at 1:39 PM, Tom Lane wrote:

Don Fox <donfox1@mac.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.

--
Michael Wood <esiotrot@gmail.com>

--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice