Stack Overflow
Stack Overflow

Questions tagged [postgres.app]

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

34 questions
1
vote
2 answers

Postgres - could not connect to server after trying rake db:create:all

I'm trying to get Postgres up and running on OS X Lion - homebrew - rvm. http://railscasts.com/episodes/342-migrating-to-postgresql After following the above instructions, I ran into the same problem described here: Repairing Postgresql after…
cpursley
  • 182
  • 1
  • 7
  • 18
1
vote
1 answer

Postgres not available as adapter on Induction

I'm using Postgres.app and the latest build of Induction ( Version 0.1.0 (28) ) and I cannot choose "Postgres" as an adapter. I only have the options for mongodb, redis, and sqlite. If I attempt to type it in manually (i.e. "postgres://locahost"),…
krnjn
  • 125
  • 1
  • 3
  • 8
0
votes
1 answer

Postgres database not starting on port 5432 despite no interfering process, but works on other ports

Problem When I tried to turn on Postgres 15 database via Postgres.app on Port 5432 specifically, it doesn't work and won't turn on. I've tried everything in my power to resolve this but I can't seem to figure this out. This is the fail pop-up that…
Vikram Nithyanandam
  • 3
  • 2
0
votes
0 answers

initdb in Postgres.app does not create postgres &template1 database

I installed postgres.app 2.4.2 on macos(big sur 11.4). I wanted to initdb with locale=C, so run the command initdb -D "/Users/xxx/Library/Application Support/Postgres/var-131" -U postgres --encoding=UTF-8 --locale=C --auth-local=trust and the…
Jack Tang
  • 59
  • 5
0
votes
0 answers

Mystery: All postgres databases disapeared

I'm developing a Rails application with a postgresql database. MacOS 10.15.3 ruby 2.6.3p62 postgres 12.3 I took a break and when I came back my laptop was slow to wake up. After pressing the on/off fingerprint button a few times, it eventually…
emersonthis
  • 32,822
  • 59
  • 210
  • 375
0
votes
2 answers

Ruby app no longer able to access remote Heroku Postgres - AFTER installing Postgres.app locally

For months now, a ruby (sinatra) app "foo.rb" on my dev't Mac has been using a remote Heroku-hosted Postgres database. The app does not use ANY local database, neither in development nor production. For another project, I installed Postgress.app…
jpw
  • 18,697
  • 25
  • 111
  • 187
0
votes
0 answers

UNIX: psql: could not connect to server: No such file or directory

When I type 'psql' into terminal, or when I try to connect to the server using Postgres.app I get "/Applications/Postgres.app/Contents/Versions/9.6/bin/psql" -p5432 -d "postgres" psql: could not connect to server: No such file or directory". Is the…
dimitri
  • 11
  • 1
  • 3
0
votes
0 answers

Postgres.App + Django and proper path to libgeos_c.dylib on OSX?

I have succesfully installed Postgres.App. It works just fine if I have this in settings.py: GEOS_LIBRARY_PATH="/Applications/Postgres.app/Contents/Versions/latest/lib/libgeos_c.dylib" If I remove the above line and execute manage.py loaddata…
Paapaa
  • 244
  • 4
  • 9
0
votes
1 answer

Should be able to run psql without host Postgres.app

Postgres.app documentation says this, verbatim: Once your path is correctly set up, you should be able to run psql without a host. (If not, check that the correct version is being loaded in the PATH by doing which psql) This is not so for…
user3138341
  • 219
  • 2
  • 3
  • 12
0
votes
1 answer

Multiple PSQL gems causing problems

I have a rails 3.2.8 site that was configured to use Postgres.App. The gem it was using was pg (0.12.2) It was working fine. I wanted to build another app and so set everything up as with the other app but I was getting this…
Finnjon
  • 651
  • 4
  • 19
0
votes
1 answer

Cannot backup postgres with pg_dump on os x 10.9 due to version mismatch

I am getting pg_dump: server version: 9.3.0; pg_dump version: 9.1.4 pg_dump: aborting because of server version mismatch In my .bash_profile I have export PATH=/Applications/Postgres.app/Contents/MacOS/bin:$PATH In my .profile I…
user3061986
  • 75
  • 1
  • 9
0
votes
1 answer

Errors when connecting to local Postgres.app from Navicat or Induction

Ok, so I have Postgres.app on my mac. It's running locally insofar as I know. (the little elephant icon in top bar) Created a very basic rails application, and it worked fine, ie, it showed up in browser. Trying to connect it to Navicat Lite…
user273072545345
  • 1,536
  • 2
  • 27
  • 57
0
votes
1 answer

Getting started with postgres.app for Django application development

I'm a newbie trying to get started with postgres.app. I want to make sure I'm laying the proper foundation for the eventual deployment of a Django application to Heroku. I've followed the steps in the postgres.app documentation but have a few…
tino
  • 4,780
  • 5
  • 24
  • 30
0
votes
0 answers

Using postgres.app with rails

I recently re-installed postgres using postgres.app and now my rails app is not able to find the database. I am getting the following error: dlopen(/Users/username/.rvm/gems/ruby-2.0.0-p0/gems/pg-0.15.1/lib/pg_ext.bundle, 9): Library not loaded:…
user2136807
  • 251
  • 1
  • 3
  • 12
0
votes
2 answers

Postgres starting issue

I'm having an issue with PostgreSQL anytime I run psql -h localhost I get psql: could not connect to server: Connection refused Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432?
Kirk Strobeck
  • 17,984
  • 20
  • 75
  • 114
1
2
3