Stack Overflow
Stack Overflow

Questions tagged [postgres.app]

Postgres.app is an application for running PostgreSQL on the Mac.

34 questions
13
votes
3 answers

Could not access file "$libdir/plpgsql": No such file or directory

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 FUNCTION table_update() dchaston-# RETURNS TRIGGER AS…
CaffeinatedDave
  • 321
  • 1
  • 4
  • 8
11
votes
1 answer

How do I reload Postgres.app config without restarting?

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 the Postgres.app process, or one of the workers?),…
majackson
  • 2,823
  • 6
  • 22
  • 38
8
votes
2 answers

How to downgrade/have a previous version of Postgres DB in Postgres.app

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 9.3. The 9.4.4 version works, but sometimes there…
Grinch
  • 167
  • 1
  • 3
  • 11
7
votes
5 answers

Postgres.app configuration (port and other options)

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 ~/Library/Application\…
Igor Artamonov
  • 35,450
  • 10
  • 82
  • 113
5
votes
1 answer

What is the difference between pgAdmin and Postgres.app?

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 two different local postgres servers on different ports…
CapedHero
  • 597
  • 1
  • 9
  • 20
5
votes
1 answer

PostgreSQL on my Mac - did I install it? how do I uninstall it?

Sorry for this noob question, but I'm not sure what I just did regarding PostgreSQL. I downloaded and installed Postres.app from http://postgresapp.com/ Then I decided that I no longer wanted it and would rather just install PostgreSQL with…
tadasajon
  • 14,276
  • 29
  • 92
  • 144
3
votes
1 answer

How do I stop (postgres.app) postgres cluster from command line

How do I stop a particular Postgres.app cluster without using the gui. Instead of gui, I want to use bash/Terminal.app I should also point out that, Postgres app has a menu like this So if I do a kill, would the menu show an incorrect state?
american-ninja-warrior
  • 7,397
  • 11
  • 46
  • 80
3
votes
3 answers

How to make postgres.app db accessible to docker container?

I got postgres.app running locally on my Mac and would like my local docker container to be able to connect to it. How do I best do this? I found this post that suggests to pass the Docker host’s IP address to a container using the --add-host flag…
Malte
  • 337
  • 1
  • 11
3
votes
1 answer

Postgres.app won't start

I am running Yosemite and have had the Postgres.app running with no issues for months. I started the app today and got this error Could not initialize database cluster. initdb: could not create directory "I": Permission denied What could cause…
jhamm
  • 24,124
  • 39
  • 105
  • 179
3
votes
3 answers

Import PostgreSQL dump on OSX

I've only used MySQL before. Postgres is a little different for me. I'm trying to use the Postgres.app for OSX. I have a database dump from our development server, and I want to create the correct user roles and import the database to my local…
Steve
  • 325
  • 5
  • 13
3
votes
2 answers

Postgres.app upgrade, now Rails app won't start

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:in `require':…
memoht
  • 781
  • 5
  • 17
1
vote
2 answers

postgres.app can't find database with my username

When I click Open psql on the Welcome to Postgres window with the fancy blue elephant, it opens a terminal and I get this command and output: Tyler-Singer-Clarks-MacBook-Pro:~ Tyler$ '/Applications/Postgres.app/Contents/Version /9.3/bin'/psql…
tscizzle
  • 11,191
  • 15
  • 54
  • 88
1
vote
2 answers

How do you create and edit tables etc in a PostreSQL database on heroku if I'm running Snow Leopard?

If I had Apple's Lion (or higher) OS, I would simply: -follow heroku tutorial: https://devcenter.heroku.com/articles/heroku-postgresql#local-setup -install postgres.app on my OS -run "heroku pg:psql" (the above step is required for this command to…
dgldy
  • 83
  • 2
  • 7
1
vote
1 answer

PostgresApp giving me error on psql command

My PostgresApp was running perfectly ok but today I am trying to use from console it is giving me following error. dyld: Library not loaded: @executable_path/../lib/libedit.3.dylib Referenced from:…
Subrat Rout
  • 95
  • 2
  • 16
1
vote
1 answer

Postsql and Postgis

I'm trying to get postsql and postgis to work together, but keep running into the same issue. Using: PostgreSQL 9.2.3 (postgres.app) when I run: CREATE EXTENSION postgis; ERROR: could not access file "$libdir/postgis-2.0": No such file or…
ejm2095
  • 11
  • 1
1
2 3