Looking at the log file the problems start when the script attempts to change the owner of the postgreSQL folders. I am assuming that you are installing this with admin/root privleges so I would start by opening a terminal and making sure that the user "postgres" not "root" has ownership and read/write/execute privileges on the PostgreSQL folder and sub-folders. If not using sudo or the root account change the permissions and then attempt a reinstall. You also may want to look at downloading the latest version since they are up to 9.1.3 now. Hope this helps.
I decided to get rid of the Postgres installation.
So I started from scratch, installing the latest release now. Before I did that I change the sysctl.conf.
Now everything is working, except:
In the Terminal I still can't login with the postgres user. I have a new user on my mac though (name: PostgreSQL).
Is there a way to fix that?
Check to make sure that the user PostgreSQL has a short name of postgres and that there is a password set for that account. Then make sure that postgres is the owner of the /usr/local/pgsql directory. Once that is done you should be able to su - postgres.
First things first, if it's not broke don't fix it Leave the files exactly where they are. Next I think there may be a little confusion on the User account. Sorry I did not catch it before. The user "postgres" only lives in the database not your computer. From the command line in order to access the postgreSQL instance with the user postgres you would enter something like:
myUser$ mysql -u postres -p
-u sets the name of the user that you are logging into the Database Management System with and -p prompts for the password. If you have a password set for the user it will ask you for it. type it in and your command prompt should change to look like
Hope this helps clear it up and lets you use your command line