All Questions
Tagged with postgresql macos
41 questions
1
vote
1
answer
341
views
Issue when creating a new user and group on macOS
I need to create a user and a group called postgres on my mac but I seem to have issues with that. The reason for needing this user is because I've installed postgresql@15 via brew and it created a ...
- 113
0
votes
0
answers
93
views
PostgreSQL doesn't run on MacOS after OS upgrade
I had a postgreSQL v10 installed and running locally, now after I upgraded my macOS from Big Sur to Monterey now it seems the service is not running and I can't get it running. Brew doesn't recognize ...
- 101
1
vote
0
answers
910
views
Postgres: Failed system call was shmget(key=3879116, size=56, 03600)
I recently upgraded from a 2013 Macbook Pro to an M1 iMac 2021. This was done using the data stored in Time Machine by my old Macbook. The old Macbook had no problems, ever, running Postgres. But then ...
- 121
0
votes
1
answer
235
views
Is postgresql installed by default on MacOS?
The Uninstall app isn't working and it's been so long that I don't remember if MacOS had Postgres installed for anything before I started. If I delete /Library/PostgreSQL will it brick my system?
I ...
- 178
2
votes
2
answers
8k
views
The program “postgres” is needed by pg_ctl but was not found
I tried to install postgresql on my macbook (mojave) through homebrew:
brew install postgresql
But when I try to start postgresql manually:
pg_ctl -D /usr/local/var/postgres start
I get this ...
- 21
0
votes
0
answers
159
views
I am trying to install postgres.app on my Mac but it won't work
I am currently trying to set up Postgres.app on my Mac running 10.14 Mojave. When reading the guide online, it says to open terminal and use the command:
sudo mkdir -p /etc/paths.d && echo /...
2
votes
3
answers
6k
views
Why does my terminal start up with "(eval):export:1: not valid in this context"?
When I open my terminal, it shows up with the error
(eval):export:1: not valid in this context: Fusion.app/Contents/Public:/Applications/Postgres.app/Contents/Versions/latest/bin
I can't figure out ...
- 51
2
votes
0
answers
2k
views
how can I get pgAdmin4 to open as a standalone desktop application on MacOS?
I recently installed Postgres and pgAdmin4 and in it's default it opens on the browser. On PC I was able to "force" it to open as desktop app by entering the path to Chrome in the configuration popup ...
0
votes
0
answers
590
views
Unable to start PostgreSQL in macOS. Getting “Role ‘apple’ does not exist.”
No matter what command I am trying, I always get this error:
role "apple" does not exist
I tried following commands:
psql
createdb -s postgres
And it gives me same error. Consider apple is my ...
- 1
3
votes
0
answers
654
views
Postgres files taking up lots of space
I have nearly 40G of files on my OSX, all under the following path :
/usr/local/var/postgres/base/9466989
36G total
1.0G 10107638.6
1.0G 10107638.5
1.0G 10107638.4
1.0G 10107638.3
1.0G ...
- 232
-2
votes
2
answers
25k
views
OSX: Snort: ERROR: /etc/snort/../rules/local.rules(0) Unable to open rules file "/etc/snort/../rules/local.rules": No such file or directory
I'm trying to setup and run Snort IDS on mac using this kinda tutorial:
https://discussions.apple.com/thread/3370709?start=0&tstart=0
OSX Yosemite (10.10.2);
PostgreSQL 9.4.1 (installed with ...
- 2,187
0
votes
1
answer
6k
views
OSX: Postgresql port 5432 is closed. How to open?
Mac OS X Yosemite (10.10.2)
Postgresql 9.4.1 (installed with Homebrew)
Snort 2.9.7.0 (installed with Homebrew)
I can't connect to psql - port 5432 seem to be closed:
$ psql postgres
psql: could ...
- 2,187
25
votes
2
answers
21k
views
Error while trying to start PostgreSQL installed via Homebrew: "Operation not permitted"
I have recently installed PostgreSQL on my Mac via Homebrew. (I may have already had it installed; it was not running.)
brew install postgres
ln -sfv /usr/local/opt/postgresql/*.plist ~/Library/...
- 15.3k
11
votes
1
answer
1k
views
Why is Postgres sending network traffic on OSx
I was looking through my Activity Monitor seeing if there was anything running that was hogging my network and noticed that Postgres has the largest amount of bytes sent.
Now the numbers aren't huge ...
- 729
0
votes
1
answer
1k
views
Delete PostgreSQL data and Library directories on Mac
I want to completely clean PostgreSQL off of my Mac. I ran the uninstaller and that removed everything but the data and Library directories. I want to get rid of these two directories as well, but ...
1
vote
1
answer
891
views
Is there a way to test Postgresql connection from VMware Fusion on a Mac?
I have some reasons to believe that VMware Fusion is not connecting to my postgresql database hosted on my Mac OS.
Is there a way to test this connection from my Windows portion through VMware?
- 729
4
votes
1
answer
25k
views
How can I completely uninstall pgAdmin3 from OS X?
My pgAdmin3 install has run into a problem (windowing glitch that renders it unusable), and I want to try completely removing it from my system and installing it freshly to see if that resolves the ...
user302183
0
votes
1
answer
748
views
OS X Mavericks / Squirrel SQL Client / PostgreSQL 9.1
I have just downloaded and installed the Squirrel SQL client v3.5.0 (as 3.5.1 didn't work for me).
I have also downloaded the PostgreSQL 9.1 jdbc client.
When attempting to add the jdbc client ...
- 178
2
votes
1
answer
2k
views
How to install hstore in Postgresql on Mac OSX?
I'm trying to install hstore in Postgres on Mac OSX 10.9, but I'm having major troubles with it. First I had some trouble getting psql to work after installing postgresql using brew, so I finally ...
- 1,432
0
votes
2
answers
7k
views
Unable to get Postgresql commands to work in terminal
After installing Postgresql by dragging folder into my applications folder I am unable to get commands to work in the terminal and unable to add the path so that is shows up using the command $ echo $...
- 3
0
votes
1
answer
2k
views
where do I put my `pg_hba.conf` file in EnterpriseDB for OS X
I have a pg_hba.conf.sample file, but no pg_hba.conf file. I want to make one and put it in the right place. Where do I put pg_hba.conf?
- 409
4
votes
2
answers
5k
views
Homebrew postgres won't start after uninstall, reinstall and reboot
I uninstalled and reinstalled postgresql via homebrew. It worked fine until I restarted my computer. Now I'm trying to run my tests and they're blowing up. I'm looking at the current processes and I ...
- 1,103
94
votes
8
answers
145k
views
"FATAL: lock file "postmaster.pid" already exists"
I just reinstalled postgres via brew install postgres
I ran initdb /usr/local/var/postgres -E utf8 but got this:
The files belonging to this database system will be owned by user "atal421".
This ...
- 1,103
2
votes
1
answer
714
views
PostgresSQL created a user account on OSX
Hello I installed PostgresSQL on my macbook but when I restarted my macbook later I saw that instead of the usual User account and the Guest account I now have also a Postgres user in my startup page ...
- 131
0
votes
0
answers
99
views
I don't understand how postgres is installed (OSX)
Im still having issues installing postgres and really do not understand all that is going on.
( https://stackoverflow.com/questions/12472988/postgres-could-not-connect-to-server-no-such-file-or-...
- 101
2
votes
2
answers
16k
views
How can I remove Postgres completely from my Mac?
I have been experiencing spooky behavior with Postgres after using the Mac installer for Postgres. There seems to be an existing half-baked Postgres installation that was already there and remains ...
- 963
3
votes
0
answers
878
views
Remove postgres from Mac that is installed in /usr/local/
I want to completely uninstall postgres and start from scratch - the version I have is refusing to work with PostGIS 2.0. I have read other answers on how to do this, but none of them seem to fit the ...
- 163
27
votes
1
answer
35k
views
PostgreSQL homebrew installation lacks config files
So I successfully installed PostgreSQL 9.1 on MacOSX Lion. Unlike people say, I didn't have to change the PATH and no other version of PostgreSQL was installed on the system ($ psql --version
shows ...
- 702
0
votes
1
answer
3k
views
Mac updated just now, postgres now broken
I run postgres 9.1 / ruby 1.9.2 / rails 3.1.0 on a maxbook air for local dev. It's all been running smoothly for months, (though this is the first time I've done development on a mac.)
It's a ...
- 143
0
votes
1
answer
1k
views
How can I fix this PostgreSQL installation error on Mac?
I am facing the following error upon PostgreSQL installation on MacOsX:
sh-3.2# sudo port install postgresql84-server
---> Computing dependencies for postgresql84-server
---> Staging ...
9
votes
2
answers
27k
views
Create a "postgres" user account on OSX?
I just made a mistake: I installed PostgreSQL on Mac OSX 10.6.7 and when I wanted to connect to it I did su postgres, then it asked me for a password and I did sudo passwd postgres to change the ...
- 193
1
vote
1
answer
616
views
Using PostgreSQL on Mac OS X Lion
I just got a new Mac with Lion installed on it. I then installed Xcode (4.1 through the App Store). Next, I installed Homebrew and I was about to do brew install postgresql like I had done on Snow ...
- 111
-1
votes
1
answer
3k
views
Setting up PostgreSQL on Mac OS 10.6.8 Snow Leopard?
I've installed PostgreSQL 9 on Mac OS. I need to change the configuration so that I can access Postgre with the blank password. Searching online yields lots of solutions for older versions of the ...
- 5,858
2
votes
1
answer
3k
views
How do I restore a Postgres database from file backups
I use Time Machine on my Mac to backup my system. I have just managed to clobber my Postgres database and would like to restore it using my Time Machine backups. The latest changes don't matter, so I ...
- 235
0
votes
2
answers
324
views
Mac with Rails & Postgres Installed - Overheats quickly?
Anyone else have this problem? I'm on a 15" Macbook running rails and postgres. Needless to say, shortly after powering up the mac and getting into development work, the mac gets very hot at the ...
AnApprentice
2
votes
3
answers
2k
views
PostgreSQL Admin Tool for mac os X [closed]
I'm looking for desktop admin tool similar to phpPgAdmin for POstgreSQL in Mac os X . Any recomendation?
- 647
2
votes
1
answer
655
views
Prevent PostgreSQL to start when Mac OS X boots
I installed PostgreSQL 8.4.4 in Mac OS X. I am pretty happy and I don't want to uninstall it since I do occasional development on it.
But I would definitely like to prevent OS X to run it every time ...
- 1,759
1
vote
2
answers
3k
views
How do I uninstall postgres on Mac OS? Can't kill data
I'd like to uninstall postgres on Mac OS 10.6 and start again with a completely fresh installation and empty databases.
I've killed all running postgres processes and tried to delete the postgres ...
- 175
1
vote
1
answer
3k
views
How do I uninstall postgres on Mac OS? [duplicate]
Possible Duplicate:
How do I uninstall postgres on Mac OS? Can’t kill data
I'd like to uninstall postgres on Mac OS 10.6 and start again with a completely fresh installation and empty ...
AP257
1
vote
1
answer
976
views
How do I give MacPorts privileges?
I tried to install PostgreSQL server development libraries using MacPorts and got the following:
Warning: MacPorts running without privileges. You may be unable to complete certain actions (e.g. ...
- 161
1
vote
2
answers
6k
views
Problem with security settings during OSX start up
I recently installed PostgreSQL and am now getting these errors when I start up:
“/Library/StartupItems/HWPortDetect” has not been started because it does not have the proper security settings.
“/...
- 161