From: | "bee(dot)lists" <bee(dot)lists(at)gmail(dot)com> |
---|---|
To: | Submit Postgresql Novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Can't Start Server |
Date: | 2021-03-15 12:19:04 |
Message-ID: | 4A71A879-8FF0-4178-A1A1-F8D53841E9DC@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi folks.
I just installed postgresql(at)12 onto MacOS Big Sur. It won’t start. The postgres user is not created, and the setup is new to me with regards to homebrew’s relocation into its own opt/ directory. I’ve set up postgresql.conf and pg_hba.conf like my old setup, so things should be good. I just can’t get it to start up.
Anybody have any insight into this? I appreciate any leadership.
/opt/homebrew/var/postgresql(at)12 stable ❯ pg_ctl -D opt/homebrew/opt/postgresql(at)12/bin/postgres start
pg_ctl: could not open PID file "/opt/homebrew/opt/postgresql(at)12/bin/postgres/postmaster.pid": Not a directory
/opt/homebrew/var/postgresql(at)12 stable ❯ brew services list
Name Status User Plist
postgresql(at)12 error rich /Users/rich/Library/LaunchAgents/homebrew(dot)mxcl(dot)postgresql(at)12(dot)plist
~ ❯ sudo su - postgres
su: unknown login: postgres
~ ❯ brew services start postgresql(at)12
Service `postgresql(at)12` already started, use `brew services restart postgresql(at)12` to restart.
~ ❯ brew services restart postgresql(at)12
Stopping `postgresql(at)12`(dot)(dot)(dot) (might take a while)
==> Successfully stopped `postgresql(at)12` (label: homebrew(dot)mxcl(dot)postgresql(at)12)
==> Successfully started `postgresql(at)12` (label: homebrew(dot)mxcl(dot)postgresql(at)12)
~ ❯ sudo su - postgres
su: unknown login: postgres
Cheers, Bee
From | Date | Subject | |
---|---|---|---|
Next Message | vinay kumar | 2021-03-17 04:44:34 | Understanding recovery conflict due to bufferpin |
Previous Message | Simon Connah | 2021-03-14 09:47:53 | Re: Database migrations |