4 ms·
On OSX there is the fantastic http://postgresapp.com/ http://postgresapp.com/ . It installs into /Applications so it is easy to remove, and comes with a start/s
by ProblemFactory 10y ago
On OSX there is the fantastic http://postgresapp.com/ http://postgresapp.com/ . It installs into /Applications so it is easy to remove, and comes with a start/stop GUI and taskbar icon. Great for local development.
But installing and configuring Postgres "properly" on a server is still something of a challenge. Do I need to modify random_page_cost on a SSD or not? What are good memory limits on modern big servers? What exactly needs to go into pg_hba.conf?
None of these seem too difficult after reading a few tutorials and wikis, but it would be nice if the server set itself up with reasonable defaults based on the machine its running on.