Stack Overflow
Stack Overflow

Questions tagged [postgresapp]

Postgres.app is the easiest way to get started with PostgreSQL on the Mac. Open the app, and you have a PostgreSQL server ready and awaiting new connections. Close the app, and the server shuts down.

Postgres.app is the easiest way to get started with PostgreSQL on the Mac. Open the app, and you have a PostgreSQL server ready and awaiting new connections. Close the app, and the server shuts down.

Postgres.app contains a full-featured PostgreSQL installation in a single package:

  1. PostgreSQL
  2. PostGIS
  3. Procedural languages: PL/pgSQL, PL/Perl, PL/Python, and PLV8 (Javascript)
  4. Popular extensions, including hstore and uuid-ossp, and more
  5. A number of command-line utilities for managing PostgreSQL and working with GIS data
16 questions
25
votes
3 answers

ARM64 architecture (M1 chip): Cannot install pg gem (using PostgresApp)

I've been trying to install a rails project on my computer (Macbook Pro 2020 with M1) running Big Sur. I have the PostgresApp installed. When running bundle install it fails to build the pg gem so I tried to install the gem manually (by doing gem…
Tiago
  • 673
  • 1
  • 8
  • 24
4
votes
0 answers

change database username and password in Postgres.app

I have just downloaded Postgres.app and set up a database to connect to with a Java program. By default, Postgres.app sets up a database server with a default username and no password. How can I secure my database with a password?
Ash
  • 61
  • 6
4
votes
4 answers

How can I run two copies of PostgreSQL on Mac OS X?

I need to run integration tests for a system that has both a local and a remote database server; I'd like on my dev Mac to have two PostgreSQL servers on different ports. I usually use Postgres.app - can this be somehow configured to run two…
Scott Wilson
  • 1,650
  • 1
  • 17
  • 14
3
votes
3 answers

Rails Postgres Schema Issue - One of the following schema(s) is invalid: "test" "public"

I've searched high and low for an answer to this but I'm coming up short. I'm trying to build a multi-tenant application with Rails 4, Devise, and Apartment based on Postgres schemas. For my local Postgres server I decided to use PostgresApp. I…
Michael Heath
  • 174
  • 2
  • 11
2
votes
0 answers

postgres.app: How Do I Install libpq-dev on the Mac?

I'm running the latest version of postgres using the postgres app. [mydir] (master) which psql /Applications/Postgres.app/Contents/Versions/latest/bin/psql I've been getting errors when I try to install the RubyGem pg. ERROR: Error installing pg: …
Pamela Cook - LightBe Corp
  • 3,912
  • 5
  • 50
  • 86
2
votes
2 answers

Change Postgresql version that Postgres.app uses

When I use Postgres.app, it uses version 9.6. I have version 10.5 installed as well (via Homebrew) on my computer and want to use that instead. When clicking on the + sign in the sidebar to "Create new server" I only get a dropdown with versions…
Fellow Stranger
  • 32,129
  • 35
  • 168
  • 232
1
vote
1 answer

How to install GDAL Python Bindings for Postgres.app

I installed the latest Postgre.app version Version 2.5.6 (139) Universal version for my new MacBook Pro M1. After setting up the CLI tools, I am able to access all gdal binaries that come bundled like gdalinfo. However I also need to install the…
Shaunak
  • 17,377
  • 5
  • 53
  • 84
1
vote
1 answer

Setting up a second Rails app locally with PG

I already have a Rails app, successfully working with Postgres.app. I don't even remember what I did to get the first database created and connected to Rails, but it works and this is what I have in database.yml development: adapter: postgresql …
Fellow Stranger
  • 32,129
  • 35
  • 168
  • 232
0
votes
0 answers

Command not found: psql

After following the installation guide here: https://postgresapp.com/, I ran the command in step 3 to configure my path and was presented with this: /Applications/Postgres.app/Contents/Versions/latest/bin However, after then typing which psql I get…
Maximoose
  • 121
  • 1
  • 5
0
votes
1 answer

how to login in to psql with your admin details

hi am following the following tutorial https://www.youtube.com/watch?v=qw--VYLpxG4&t=2224s and when i add psql into my path and then type it into the terminal it asks for my administrator datails of which i give then it shows this psql: error:…
aarush_s
  • 91
  • 1
  • 1
  • 7
0
votes
1 answer

Recreating a Rails database when using PostreSQL App

I'm really new to PostrgreSQL, and I've run into an issue I don't really know how to solve. I'm currently using the PostreSQL 10 app for OSX; and I'm trying to recreate a Rails app database using rails db:drop db:create db:migrate. I get the…
ldeld
  • 546
  • 3
  • 18
0
votes
0 answers

Postgres App: Configuring settings

I cannot seem to change the command being called when I open psql through the Postgres app. I can successfully open a connection by calling: postgres --config-file=/usr/local/var/postgres/postgresql.conf -D /usr/local/var/postgres but when I…
Jeremy Thomas
  • 6,240
  • 9
  • 47
  • 92
0
votes
1 answer

Correct PostgreSQL functionality

I have installed Postgres.app in Mac, and I have set the PATH variable to run the psql command. Now I would like to create a new user and new database for a project that I'm creating. Nevertheless, when I execute a new command in terminal, it…
Erik Barajas
  • 193
  • 2
  • 12
0
votes
2 answers

Wildfly and Postgres.app

I'm trying to make my Wildfly 9 connect to a PostgreSQL database. I installed Postgres.app (for Mac OS X), and created the database. I can connect from any app (psql, ruby, go), but wildfly always gets a connection timeout. My setup is like…
caarlos0
  • 20,020
  • 27
  • 85
  • 160
0
votes
1 answer

Using postgres thru ODBC in python 2.7

I have installed Postgres.app and started it. I have pip installed pypyodbc I have copied the hello world lines from the Pypyodbc docs, and received the error below. any ideas what the issue might be? Here is my code from __future__ import…
Dan Oblinger
  • 489
  • 3
  • 15
1
2