120
votes
How to restart PostgreSQL installed by Brew in OSX?
Brew has that covered:
brew services restart postgresql
- 1,302
53
votes
Accepted
How do you install an older version of Postgres (9.6) using homebrew?
You can find available versions to install using brew search:
$ brew search postgresql
==> Searching local taps...
postgresql [email protected] [email protected] [email protected]
To ...
grg♦
- 207k
30
votes
Accepted
homebrew. Cant start service. get "Bootstrap failed: 5: Input/output error - Postgres - Mac
The issue is the previous install of postgres was postgres 13, and it created a database under:
/usr/local/var/postgres
which is now incompatible with the version of postgres you're installing, which ...
- 416
17
votes
homebrew. Cant start service. get "Bootstrap failed: 5: Input/output error - Postgres - Mac
The problem is really what @Petesh said. But, the resolution for me was simpler.
When you upgrade your postgresql with brew, it logs a success message. One thing registered will be:
To migrate ...
- 171
11
votes
homebrew. Cant start service. get "Bootstrap failed: 5: Input/output error - Postgres - Mac
I faced a similar problem with postgresql 11 and restarting the service did not help. The issue arose when my MacBook restarted abruptly.
After checking the ports and trying out all the possible ...
- 223
7
votes
Accepted
How to open pgAdmin 4?
I just closed pgAdmin 4 in the Activity Monitor and started it again. Then I see a new tab open up with pgAdmin 4. It apparently is running on a different port (63467) than shown in the screenshots.
- 819
5
votes
How to open pgAdmin 4?
Today is my second day using pgAdmin, I downloaded it yesterday and it worked fine, but today I couldn't find a way to start it up again.
Solution was this.. I found the downloaded .dmg file again (...
- 151
5
votes
Accepted
Remove PostgreSQL account from system
The first place to look for accounts is System Preferences > Users & Groups. If the account is listed there, you can delete it by selecting it and pressing the minus button (you may need to ...
- 15.8k
3
votes
Accepted
Brew postgresql@14 error on Mac M2
The error messages give information that needs to be investigated.
HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
So check if port 5432 is being ...
- 31.3k
3
votes
Error while installing PostgreSQL 12.9 on Apple Silicon (M1 Max) via asdf
The error is as in the first line and the error is in asdf (wrapped so can read without scrolling):
/Users/kushal/.asdf/plugins/postgres/bin/install: line 45: uconv: command not found
Looking at ...
- 31.3k
3
votes
Load a locale from /usr/local/share/locale in OS X
This worked for me (macos 10.14):
sudo localedef -i /usr/share/locale/en_US.UTF-8 /usr/local/share/locale/en_US.utf8
sudo cp /usr/share/locale/en_US.UTF-8/LC_COLLATE /usr/local/share/locale/en_US....
- 31
2
votes
How to open pgAdmin 4?
I am having a similar issue. I installed PostgreSQL11 and Pgadmin4 on my Mac and both worked absolutely fine. However next day when I started my system, PgAdmin was missing. I couldn't find it ...
- 21
2
votes
How to open pgAdmin 4?
Since I like shortcuts then I prepared a solution which opens pgAdmin 4 with a quick Alfred/Spotlight shortcut called db without problems for me:
Assuming you have pgAdmin 4.app inside Applications ...
- 121
2
votes
How to restart PostgreSQL installed by Brew in OSX?
I'm on a brew install [email protected] for legacy reasons, and actually needed to:
# First, close all connections, e.g. application servers and psql connections, then
brew services stop postgres
...
- 121
2
votes
homebrew. Cant start service. get "Bootstrap failed: 5: Input/output error - Postgres - Mac
I had this for Apache. To fix it, I unloaded the plist file. In your case
launchctl unload /Users/edac/Library/LaunchAgents/homebrew.mxcl.postgresql.plist
launchctl load /Users/edac/Library/...
- 121
2
votes
homebrew. Cant start service. get "Bootstrap failed: 5: Input/output error - Postgres - Mac
It seems that the postgresql is already started before running the start command.
So do restart it instead of starting, by the following command:
brew services restart postgresql
- 121
2
votes
Accepted
How to conveniently restart pgAdmin 4?
pgAdmin 4 (/Applications/PostgreSQL 12/pgAdmin 4.app) is a simple launcher for /Library/PostgreSQL/12/pgAdmin 4.app which itself is some kind of a service wrapper.
Besides launching a small web ...
- 67.2k
2
votes
Error while installing PostgreSQL 12.9 on Apple Silicon (M1 Max) via asdf
Extrapolating from @mmmmmm's response above: the asdf-postgres GitHub page contains the Mac instructions for installing the necessary dependencies. I was able to use these steps to install Postgres on ...
- 121
2
votes
homebrew. Cant start service. get "Bootstrap failed: 5: Input/output error - Postgres - Mac
I can't believe people suggest to rm all DB data... for me, the data is the KING.
I had a similar issue. After determining that it wasn't system resources hit the ceiling, I opted to ditch brew as my ...
- 11
2
votes
Brew postgresql@14 error on Mac M2
Postgres uses a file to tell if an instance is already running. The file should be deleted when the postgres process exits. In my case, postgres was no longer running but the file was still there, ...
- 129
2
votes
Accepted
Anybody still runs PostgreSQL server on OSX 10.11.6? And how do I get icu4c@76 to compile?
A work-around solution I am adopting for this compilation mess is to use MacPorts as package manager from this point on.
By default, MacPorts installs under /opt/local. Reinstallation of PostgreSQL14 ...
- 11
2
votes
brew says outdated when I upgrade to latest version
It's complaining that your macOS version is out of date; Homebrew currently supports macOS 12 and higher.
The second error message is unrelated. It's to do with linking a dependency. You can unlink ...
- 5,392
1
vote
Unable to launch PostgreSQL on Macbook Air
From the icon I conclude that you want to open pgAdmin.
Find pgAdmin on Finder, then go to Get Info, and check the box Open with Rosseta.
- 46
1
vote
homebrew. Cant start service. get "Bootstrap failed: 5: Input/output error - Postgres - Mac
I cannot tell you why but the only solution that solved the issue for me was to uninstall and install postgresql completely. (it stopped working after a reboot on my M1 mac running macOS 12.6 Monterey)...
- 131
1
vote
How to Start Postgres Service in MacOs?
Normally this should do the trick:
"pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start"
Without the " " of course.
- 680
1
vote
Accepted
AppleScript export variable to Numbers / Excel / SQL
Row Allocation for Data Entry
To get data added to a new row, you were on the right track with your first script where you wrote tell the selectedTable to add row below last row. You simply then had ...
- 5,622
1
vote
homebrew PostgreSQL upgraded to 10.1 but I need 9.6
Had the same problem and found this from https://jaketrent.com/post/downgrade-previously-installed-brew-formula/
brew install [email protected]
brew switch postgres 9.6.3
brew info postgres // prints ...
- 111
Only top scored, non community-wiki answers of a minimum length are eligible