Attention Mac OS Lion users

[Sn3aks]

I also tried the moderator fix and it also didn't work.

As stated above I tried that with no success...

[tarix]

Then please create a support request and we'll make sure we get everything sorted out for you.

[KelvinKe]

How do you mean by creating a user 'postgreg' under Users & Groups? You literally create a new user to the Macbook? Don't understand what to do next. Thank you

[WhiteRider]

This should be all you need to do, but if that doesn't work because of the way your setup is now then please create a support request as suggested above and we'll help you get set up directly.

[KelvinKe]

This should be all you need to do, but if that doesn't work because of the way your setup is now then please create a support request as suggested above and we'll help you get set up directly.

Thank you. The 2 lines of text from your hyperlink are:

sudo dscl . -append /Users/_postgres RecordName postgres
sudo dscl . -append /Groups/_postgres RecordName postgres

After copying and pasting both lines of text at the same time (without the bullet points from the link) - the terminal simply creates another line for me saying: "kelvins: - Kelvin$" and nothing happens. It doesn't prompt me for password at all. Any suggestions? Thank you

[I've fixed the above and managed to create a user called postgres, EDITED: 09:43]

- I have now copied and pasted the below in terminal:
cd /Library/PostgreSQL/9.0
mkdir data
chmod 700 data
chown postgres data
su postgres
./bin/initdb /Library/PostgreSQL/9.0/data

- And it asks me for password
- I type in password and hit Enter
- Now Terminals shows up this line of text: "bash-3.2$"
- I have tried copying and pasting either of those two lines of text next to bash-3.2$:
1) ./bin/postgres -D /Library/PostgreSQL/9.0/data
or
2)./bin/pg_ctl start -D /Library/PostgreSQL/9.0/data/
- And I get the following error message: "bash: ./bin/postgres: No such file or directory" for 1) and "bash: ./bin/pg_ctl: No such file or directory" for 2)

Any suggestions on where I should go from here? Thank you

[kraada]

After running su postgres, run cd /Library/PostgreSQL/9.0/bin then run ./initdb ../data/ and see if it completes.

[KelvinKe]

After running su postgres, run cd /Library/PostgreSQL/9.0/bin then run ./initdb ../data/ and see if it completes.

Just tried this and got the below message after I tried running cd/Library/PostgreSQL/9.0/bin:

'bash: cd: /Library/PostgreSQL/9.0/bin: No such file or directory'

Any ideas? :S

[kraada]

Then please create a support request and we'll make sure we get everything sorted out for you.

[tosr]

I solved this issue by installing postgres 9.2

[WhiteRider]

Please be aware that there are still problems in PostgreSQL 9.2 and we do not yet support versions higher than 9.0. These issues could cause corruption in your database.