Can't Start Server

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

Browse pgsql-novice by date

  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