Q: postgreSQL broken fatally with Server 3.2.1
-
Sep 19, 2014 12:07 AMby mscott_mdm,It's difficult to say what might be wrong from your description. However, Server 3.2.1 upgraded PostgreSQL from 9.2.x to 9.3.x, and one of the configuration keys changed (from "unix_socket_directory" to "unix_socket_directories"). You might need to make sure and old configuration files are updated to use unix_socket_directories. You only need to change the key, the value can stay exactly the same.
-
Sep 19, 2014 6:40 AMby TonyPHX_623,I agree with the defect that you note, but one other observation I have made...
If you do a clean install of Mavericks and Server, they have dramatically changed the PostgreSQL directory structure. What we have seen from a migration standpoint is totally different than a clean install as far as form and function.
I built a system from scratch and found it easier to just deploy PostgreSQL myself rather than use the Apple provided(?) PostgreSQL. Seriously, try it and check it out, it is eye opening.
-
Sep 20, 2014 11:37 AMby Steven Major,This is very much why I installed MySQL for anything that doesn't depending on Apple PSQL.
1) In my experience, it is easier to find support for MySQL.
2) If you like there are some good GUI tools for it.
3) Most importantly, I control when the service is upgraded rather than it being included in a global service update.
