Skip to main content

Questions tagged [postgresql]

PostgreSQL is an open-source, relational database management system (RDBMS). Please mention your version of Postgres when asking questions. This tag is for questions concerning installing and running Postgres on OS X. Questions concerning administration or advanced features are best directed to https://dba.stackexchange.com/tags/postgresql or https://stackoverflow.com/tags/postgresql.

Filter by
Sorted by
Tagged with
2 votes
1 answer
562 views

brew says outdated when I upgrade to latest version [duplicate]

% brew search postgresql ==> Formulae postgresql@10 postgresql@11 postgresql@12 postgresql@13 postgresql@14 postgresql@15 postgresql@16 qt-postgresql postgrest % brew install postgresql@16 ...
Joymaker's user avatar
  • 141
0 votes
1 answer
206 views

Unable to launch PostgreSQL on Macbook Air

I have downloaded the macOS version of PostgreSQL to my MacBook Air from postgresql.org, but I am unable to launch the downloaded program. Below is the error message I am getting:
Surya Deepak's user avatar
1 vote
0 answers
835 views

macOS Ventura has two copies of Postgres in Login Items

Just notice my Mac (running macOS Ventura 13.1) has two copies of postgres listed as Login Items in System Settings > General > Login Items. Clicking on the (i) button for EITHER one opens a ...
Meltemi's user avatar
  • 1,856
0 votes
0 answers
110 views

Disable Postgress App 2.5.12 Automatic Startup on Mac

I have installed postgress app 2.5.12 on my mac and it automatically starts with my system boot. I have checked System Settings > General > Login Items as well as /Library/LaunchDaemons and /...
Arash's user avatar
  • 11
4 votes
2 answers
10k views

Brew postgresql@14 error on Mac M2

I have installed postgresql@14 via brew on my Mac M2. Now, when I do brew services I get this output postgresql@14 error 256 headmaster ~/Library/LaunchAgents/[email protected] Can ...
Headmaster's user avatar
3 votes
1 answer
3k views

Remove PostgreSQL account from system

When I am accessing Fast User Switching, there is a PostgreSQL account: I have uninstalled PostgreSQL account a while back, looked out libraries and no trace of folder PostgreSQL. I am aware that I ...
Noz_Char's user avatar
0 votes
1 answer
220 views

Problems with PostgreSQL uninstallation

I decided to let go of postgreSQL today and ran the uninstaller as well as deleted rm /etc/postgres-reg.ini that the uninstaller says you have to remove manually. Now I cannot remember what the other ...
BeethovenKodar's user avatar
0 votes
1 answer
512 views

How can I delete the PostgreSQL user in my mac? because, there is no user in the preference [duplicate]

I forgot how I install postgresql before. and now I have removed it by following this steps https://stackoverflow.com/a/9240197/12381565 . But my postgresql user didn't gone from the taskbar, ...
Hakim's user avatar
  • 1
0 votes
1 answer
1k views

Error while installing PostgreSQL 12.9 on Apple Silicon (M1 Max) via asdf

I'm trying to install PostgreSQL via asdf-postgres plugin by running asdf install postgres 12.9 on 2021 MacBook Pro (with M1 Max, running Monterey 12.0.1) but getting the following error: 100 190 ...
Kushal's user avatar
  • 101
1 vote
0 answers
2k views

psql command will not work in cli MAC. ERR: connection to server on socket "/tmp/.s.PGSQL.5432" failed

I have installed home-brew v14 psql & psql app v14. It will not allow me to use port 5432 (I spent a week getting this to work and it hasnt), so I have made a server on 4321 which will start. when ...
edwrdcodeu's user avatar
24 votes
7 answers
64k views

homebrew. Cant start service. get "Bootstrap failed: 5: Input/output error - Postgres - Mac

I am trying to re-install Postgres via home-brew on Mac. I uninstalled Postgres, updated home-brew and ran the install command for brew install postgres when I run brew services start postgresql I get ...
edwrdcodeu's user avatar
0 votes
0 answers
2k views

pgadmin 4 won't quit on Macbook Pro

I need to restart my Macbook Pro for a new OS update. Somehow the pgAdmin 4 won't quit even I try to quit it from its menu multiple times. Is another way to quit it?
vic's user avatar
  • 101
1 vote
0 answers
611 views

Export Profile Manager database

Good morning, I have an old Apple server with macOS 10.12 and Server.app version 5.3 Now I need export the information about devices with DeviceName, SerialNumber and ICCID (for iPad) I found some ...
fvadmin's user avatar
  • 21
1 vote
0 answers
743 views

Command-line connection with VPN to remote PostgreSQL fails, other apps work

I am trying to connect to PostgreSQL database hosted on Azure programmatically. I am able to do so using apps like PgAdmin or Postico. However, the connection does not work with psql or python. I have ...
ldc's user avatar
  • 121
1 vote
0 answers
34 views

New user account PostgreSQL is created on its own

After downloading PgAdmin4 on my MacBook, a new user account "PostgreSQL" was created without my knowledge and with a password that I don't know. Is this normal?
Izzy's user avatar
  • 11
1 vote
0 answers
182 views

Postgres is running, but psql won't connect to it

I have Postgresql@11 installed and running. % brew services restart postgresql@11 Stopping `postgresql@11`... (might take a while) ==> Successfully stopped `postgresql@11` (label: homebrew.mxcl....
goja3318's user avatar
1 vote
1 answer
12k views

How to conveniently restart pgAdmin 4?

I have pgAdmin on my dock, and can open it when the process isn't already running (ie. after a restart, or if I manually kill it). If I open pgAdmin, close the window, then later try to open it from ...
Lord Elrond's user avatar
0 votes
0 answers
161 views

Rotated logs with newsyslog, but PostgreSQL doesn't write to new one until I restart it

I installed PostgreSQL on my mac using homebrew and it's been working great. I recently increased the amount of logging going on because I need to use pgbadger, so naturally I set up log rotation ...
Paul Tomblin's user avatar
1 vote
0 answers
91 views

Postgresql 11 on Lion

We may be receiving a 1,1 Xserve running OSX Lion 10.7.6 (newest for the hardware) and need to run Postgres on the system. Will the newest version (11.5_1 at the time of writing) work on Lion if ...
leetbacoon's user avatar
0 votes
1 answer
2k views

How to Start Postgres Service in MacOs?

I already install PostgreSQL using homebrew "brew install postgresql". But after that, I will start the service of the Postgres service its give me some error message. pg_ctl -D /usr/local/var/...
Harshit Trivedi's user avatar
8 votes
4 answers
55k views

How to open pgAdmin 4?

I've installed and am trying to open pgAdmin 4 on my Macbook Pro. However, if I right-click it and select "Open", nothing happens. Then again, if I try to re-download pgAdmin 4 and drag that into the ...
Kurt Peek's user avatar
  • 819
0 votes
2 answers
497 views

AppleScript export variable to Numbers / Excel / SQL

I would like AppleScript to add a new row on a number or excel sheet (or on a SQL database) I have my data saved on a .plist which I can retrieve with set myDateFromPlist to value of property list ...
Kevin's user avatar
  • 2,378
1 vote
1 answer
3k views

homebrew PostgreSQL upgraded to 10.1 but I need 9.6

I did brew update and brew upgrade Now my PostgreSQL is 10.1 On the server I have 9.6 and I want it to be the same. I can connect and read my data now still (as I assume the brew service didn't ...
dszakal's user avatar
  • 544
2 votes
1 answer
894 views

how install postgres 9.6 and a corresponding PostGIS [closed]

How do I install postgres 9.6 and a corresponding PostGIS on macOS Sierra using perhaps homebrew?
american-ninja-warrior's user avatar
34 votes
1 answer
56k views

How do you install an older version of Postgres (9.6) using homebrew?

Homebrew's current version of Postgres is 10 when installed with: brew install postgres How do I install an older version of postgres? Specifically 9.6
JK.'s user avatar
  • 493
0 votes
1 answer
5k views

How to install pgAdmin 4 in server/Desktop mode on Mac?

How to install pgAdmin 4 on Mac using python wheel. I found a help for Ubuntu https://askubuntu.com/questions/788457/how-to-install-pgadmin-4-in-server-mode-on-ubuntu-16-04 but I did n't find ...
Thirumal's user avatar
  • 1,049
2 votes
1 answer
8k views

PostgreSQL not in path after installation

I installed PostgreSQL using the interactive installer by EnterpriseDB following this link. It defaulted the installation directory to /Library/PostgreSQL/9.6. After successful install, psql is not in ...
Daniel Viglione's user avatar
1 vote
0 answers
283 views

postresql not installing with homebrew on El Capitain 10.11.5

brew doctor says 'Your system is ready to brew.' Upon installing with homebrew : brew uninstall postgres && brew install postgres I always get the following error : Data page checksums are ...
Michael's user avatar
  • 41
3 votes
1 answer
369 views

Using postgres with launchd without constant issues

I have postgres and passenger installed from homebrew, and use the os x built in apache. I have several rails apps that use postgres which are managed by passenger which in turn is managed by apache. ...
Camden Narzt's user avatar
2 votes
2 answers
6k views

Unable to run Postgres after Installation on OSX - El Capitan

I just used homebrew to install my postgres, and I am unable to start it after attempting to start it with the suggested command from postgres/brew. Can someone please advise?
Maanas Bukkuri's user avatar
3 votes
1 answer
2k views

PostgreSQL- Cannot connect to server

PREFACE: I just bought my first Mac laptop a week ago so that I could get some work done on my trip, but so far I've spent most of my time trying to solve an issue with PostgreSQL. Something went ...
Adam Starrh's user avatar
4 votes
2 answers
2k views

Load a locale from /usr/local/share/locale in OS X

While importing a PostgreSQL database in OS X 10.10, I got a error like "invalid locale name: en_US.utf8". I went to /usr/share/locale and copied the folder en_US.UTF-8 as en_US.utf8. Ok, problem ...
Jan K. S.'s user avatar
  • 151
0 votes
1 answer
2k views

Running Postgres as Launch Daemon

I am working on setting up a psql server and would therefore like postgres to run whenever the computer is on, regardless of whether I'm logged it. (The machine is running OS X Yosemite.) I set up a ...
jaia's user avatar
  • 103
48 votes
3 answers
101k views

How to restart PostgreSQL installed by Brew in OSX?

In Linux, it can be done by /etc/init.d/postgresql-9.2 restart. My OSX is not a server app. I think it it can be done by ALTER USER postgres with password '1234'; postgreQSL prompt but I am not ...
Léo Léopold Hertz 준영's user avatar
1 vote
1 answer
2k views

How to export Calibre's library for Database Support?

I have used Calibre but I would like get more freedom in exporting it elsewhere for edits. I would like to do quality assurance of my books, papers and literature. Calibre does not communicate with ...
Léo Léopold Hertz 준영's user avatar
0 votes
1 answer
192 views

Creating User to Run Postgres

I'm setting up a postgres server and want to create a separate postgres user to run the process, as recommended in the manual. How do I do this? I installed postgres via Homebrew and have experience ...
jaia's user avatar
  • 103
1 vote
0 answers
125 views

How to mass-update Apple Wiki server directly in Postgres [closed]

I migrate a wiki that had a lot of broken link to a domain that no longer exist. How can I massively update my database, instead of change any single link? My idea is to connect in postgres and ...
cristianof's user avatar
1 vote
0 answers
375 views

Problem reinstalling PostgreSQL after installing Parallels

I’m trying to reinstall postgresql on my mac (yosemite) after installing parallels seemed to mess up permissions to directories that psql and homebrew need. I was able to force-uninstall psql, but ...
Steph's user avatar
  • 111
0 votes
0 answers
110 views

How Do I Override the Addition of the folder for the Server app version of PostgreSQL?

I am currently using RVM for managing different gemsets for different versions of Ruby. RVM has made changes where the RVM folders must be listed first or else I have to manually set the gemset each ...
Pamela Cook - LightBe Corp's user avatar
7 votes
3 answers
10k views

/System/Library/LaunchDaemons/com.apple.servermgrd.plist Is Missing - Causing postgres to not start properly

I recently updated my Mac Mini Server to Yosemite and the Server app 4.0. When I tried to verify that Postgres is available by executing sudo serveradmin fullstatus postgres I get the following error:...
Pamela Cook - LightBe Corp's user avatar
3 votes
2 answers
4k views

I Cannot Access PostgreSQL At Times After Server App Upgrade

I am running the latest version of Mavericks 10.9.5 on my Mac Mini Server. Before the upgrade to the latest version of the Server App 3.2.1 I was able to access PostgreSQL in my Ruby on Rails ...
Pamela Cook - LightBe Corp's user avatar
1 vote
1 answer
903 views

How do I determine where a process is being started from, and disable it?

When I start OS X (Mavericks) and run ps aux | grep postgres from Terminal, I have a process that was automatically started: postgres 132 0.0 0.1 2526456 7936 ?? Ss 10:04PM 0:00....
B Robster's user avatar
  • 135
4 votes
5 answers
5k views

/Library/Server/Wiki/Database.xpg consuming huge amount (313GB!) of disk space

Over the last few days I've noticed the amount of free space on my HD has been plummeting. After a bit of investigation, I found it was due to the folder /Library/Server/Wiki/Database.xpg. It was ...
David Miani's user avatar
2 votes
1 answer
2k views

Using Mac OS X 10.9 lsof launches 5 to 10 processes at a time on its own taking all cpu

I am running a MacBook Air 13 (Latest) with 8GB / 512 Flash / Core Intel i7. Lately shortly after bootup I hear the fans winding at top speed. I checked the top processes and see several instances ...
user63339's user avatar
4 votes
2 answers
2k views

PostgreSQL causing slow shutdowns with OS X Server in Mavericks

I've found that on OS X Server in Mavericks, the PostgreSQL processes are causing shutdown delays. During a verbose shutdown, I get the following (shortened) output: com.apple.launchd ...
jstm88's user avatar
  • 933
5 votes
1 answer
3k views

Is there a reason why OS X Mavericks Server is running Postgresql?

I recently installed OS X Mavericks Server on my computer to use for Xcode continuous integration. I now see that the postgresql database is running via the Activity Monitor, and some investigation ...
Jason's user avatar
  • 1,116
7 votes
2 answers
41k views

What is postgres and why is it running on my system?

Upon every login to my computer, I notice in Activity Monitor I have several instances of a process called "postgres" running, under the user "postgres". What is this, and why does it launch every ...
DrKumar's user avatar
  • 365
3 votes
0 answers
2k views

shmmax and shmall values in /etc/sysctl.conf are not loaded on reboot

I'm running OSX 10.8.4 and I would like to add a factor of 10 to the default shmmax and shmall values. My /etc/sysctl.conf contains the following settings: kern.sysv.shmmax=41943040 kern.sysv.shmmin=...
kburns's user avatar
  • 131
1 vote
2 answers
2k views

Password problems changing users in Terminal

I'd like to switch between the default user in Terminal and the user 'postgres', created when I installed PostgreSQL 9.2. If I type su postgres, I'm prompted for a password that I don't know and don'...
GChorn's user avatar
  • 113
1 vote
1 answer
2k views

Homebrew installed PostgreSQL for use by multiple accounts

I'm using Homebrew to install PostgreSQL (PG) on a MacBook Air. admin user brew installed PostgreSQL. I'd like another (mobile account) user to be able to use the database for Rails development. ...
Meltemi's user avatar
  • 1,856