4 ms·
+1 using Postgres.app (for Mac): http://postgresapp.com/ http://postgresapp.com/ If you're on a Mac and don't want a menubar icon (I decided this recently), `b
by jclem 13y ago
+1 using Postgres.app (for Mac): http://postgresapp.com/ http://postgresapp.com/
If you're on a Mac and don't want a menubar icon (I decided this recently), `brew install postgres`, and then write yourself some functions to make starting and stopping easier:
https://github.com/jclem/dotfiles/blob/master/zsh/functions/pgstart https://github.com/jclem/dotfiles/blob/master/zsh/functions/...
https://github.com/jclem/dotfiles/blob/master/zsh/functions/pgstop https://github.com/jclem/dotfiles/blob/master/zsh/functions/...
- kylequest 13y agoEnterpriseDB has a nice set of PostgreSQL installers for all platforms. It also bundles PgAdmin 3 if you need a GUI. It's not as hip as PG Commander, but it's a real client that can do pretty much anything (vs PG Commander where you can't even create a new db instance). Postgres.app is nice when it works. When you install the latest version the psql tool it bundles and exposes in the menu assumes you have a db that matches your user name, which, of course, doesn't exist, so you can't connect to the Postgres :-) It also doesn't work that great if you already have another version setup running on the default port.
- pnathan 13y agoSo postgresapp.com's installer is great, but due to some xyz thingie, it limits at 27 or so connections for 9.2 (maybe still in 9.3? - haven't followed the GH issue). Startled me when I ran into that and motivated me to move to a regular install.
- jsmeaton 13y agoI've said it before numerous times, but `brew install lunchy` for a more sane service management syntax. `lunchy start postgres`