I'm using Postgres.app for Mac. I've used it in the past on other machines but it's giving me some trouble when installing on my MacBook. I've installed the application and I ran: psql -h localhost...

I just installed Postgres.app on my Mac, and I need to make some specific configuration to server. For example I want to use different port, not 5432. I found that it have postgresql.conf at ~/Lib...

I'm at a loss, I'm having issues creating a stored proc in my local Postgres server (postgres.app, Mac OS X 10.7), as so $ psql psql (9.3.0) Type "help" for help. dchaston=# CREATE OR REPLACE FUN...

After reading official websites as well as conducting Google research I still do not clearly understand how pgAdmin and Postgres.app relate to one another? For example, I can simultaneously run tw...

I have installed Postgres.app from here (http://postgresapp.com) a couple of days ago. It comes with Postgres 9.4.4. Today I realised that the software I am using officially supports only Postgres...

With a regular postgres install, I would do this either by sending SIGHUP to the postgres process, or by running pg_ctl reload. With Postgres.app, however, I'm unsure about where to send SIGHUP (to...

I just upgraded my Postgres.app to latest version (9.2.4.1) am now unable to start my Rails app using Foreman or Rails server. /Users/memoht/Sites/myapp/.gem/ruby/1.9.3/gems/pg-0.15.1/lib/pg.rb:4:...