public inbox for [email protected]  

help / color / mirror / Atom feed

From: bee.lists <[email protected]>
To: Submit Postgresql Novice <[email protected]>
Subject: Can't Start Server
Date: Mon, 15 Mar 2021 08:19:04 -0400
Message-ID: <[email protected]> (raw)

Hi folks. 

I just installed postgresql@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@12 stable ❯ pg_ctl -D  opt/homebrew/opt/postgresql@12/bin/postgres start
pg_ctl: could not open PID file "/opt/homebrew/opt/postgresql@12/bin/postgres/postmaster.pid": Not a directory

/opt/homebrew/var/postgresql@12 stable ❯ brew services list
Name          Status  User Plist
postgresql@12 error   rich /Users/rich/Library/LaunchAgents/[email protected]

~ ❯ sudo su - postgres
su: unknown login: postgres   

~ ❯ brew services start postgresql@12
Service `postgresql@12` already started, use `brew services restart postgresql@12` to restart.
~ ❯ brew services restart postgresql@12
Stopping `postgresql@12`... (might take a while)
==> Successfully stopped `postgresql@12` (label: homebrew.mxcl.postgresql@12)
==> Successfully started `postgresql@12` (label: homebrew.mxcl.postgresql@12)
~ ❯ sudo su - postgres
su: unknown login: postgres



Cheers, Bee

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: Can't Start Server
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox