Re: Install problems for postgresql-8.4.1

I still get the bus error!

bash-3.2$ /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l
logfile start
server starting
bash-3.2$ createdb -T template1 fromtemp0db
Bus error
bash-3.2$

On Nov 2, 2009, at 10:54 AM, Michael Wood wrote:

> 2009/11/2 Don Fox <donfox1(at)mac(dot)com>:
>> I think the hitch is something on my machine( an old Intel Core Duo)
>> MacBook Pro. When I do a :
>> dscl . -list /Groups PrimaryGroupID | awk '{print $2 $1}' | sort -n
>> I get
>> -2nobody
>> -1nogroup
>> 0wheel
>> UsersPostgreSQL <------------- Looks strange to me! Should it be
>> removed?
>> THis is after previous installation is removed and I've just done
>> a new
>> 'sudo make install'.
> [...]
>
> The output would look much clearer if you left off the awk and the
> sort. If you really want it sorted you can do it without using awk
> first.
>
> e.g.:
>
> $ dscl . -list /Groups PrimaryGroupID | sort -nk2
>
> Your output implies that the Primary Group ID field for the PostgreSQL
> group is "Users" when it should be a number. Actually it could just
> be that the group name is "PostgreSQL Users" and the group ID isn't
> being shown because your command only outputs the first two fields,
> which are "PostgreSQL Users". So try this instead:
>
> $ dscl . -list /Groups PrimaryGroupID | grep -i postgres
>
>> When I use the
>>
>> sudo dseditgroup -o create -i 103 -r "PostgreSQL Users" postgres
>>
>> I get
>> Create called on existing record - do you want to overwrite, y or n :
>> In this case 103 should be avaliable as it's not in either Users
>> Unique ID
>> or in Groups Primary ID
>> No matter which avaliable number I choose I still get the same
>> response and
>> any createdb attempt results in a bus error!
>
> I suspect you will need to remove the "PostgreSQL" or "PostgreSQL
> Users" group and the "postgres" group if it exists and try to create
> the postgres group again.
>
> It seems unlikely that those are causing the bus error, though.
>
> Can you connect to the template1 database using psql?
>
> --
> 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