Re: Install problems for postgresql-8.4.1

2009/11/2 Don Fox <donfox1@mac.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@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