36 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
1
answer
185
views
Change to CAST syntax from "::" PostgreSQL [duplicate]
I am working through the book Practical SQL by Anthony DeBarros. I am on chapter 6 and came across this code:
SELECT county_name AS county,
state_name AS state,
area_water::numeric / (...
0
votes
1
answer
3k
views
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 ...
-1
votes
1
answer
968
views
Cannot start Postgres on port 5432
I just installed postgres.app, but when I try to start the server I get the following error:
After checking some answers in a similar thread I verified that my PATH is defined correctly and that no ...
0
votes
0
answers
452
views
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 --...
0
votes
0
answers
334
views
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 ...
0
votes
2
answers
81
views
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.
...
3
votes
1
answer
5k
views
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 ...
6
votes
1
answer
6k
views
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 ...
0
votes
0
answers
283
views
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 ...
3
votes
3
answers
2k
views
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 ...
0
votes
0
answers
232
views
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 ...
15
votes
1
answer
24k
views
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 ...
10
votes
2
answers
30k
views
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
votes
1
answer
1k
views
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 ...
3
votes
3
answers
11k
views
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 ...