Postgres says my password is invalid
andyh at totallybrilliant.com
Sun Jan 30 18:19:42 UTC 2022
Typically generic logs live in /var/log
If there is no specific Postgres log file I believe it will typically add to the ‘system.log’ file (you can view this using the Applications —> Utilities —> Console application)
You may have noticed that in the postgrsql.conf file that is where you can set (way down at the bottom in the REPORTING AND LOGGING section) to create its log files in various default places
Totally Brilliant Software Inc
Phone (US) : (863) 409 4870
Phone (UK) : 0207 193 8582
Web : www.totallybrilliant.com
Helpdesk : http://totallybrilliant.kayako.com
Email : andyh at totallybrilliant.com
On Jan 30, 2022, 1:07 PM -0500, Das Goravani <goravanis at gmail.com>, wrote:
> > On Jan 30, 2022, at 12:57 PM, Alex Clay via omnisdev-en <omnisdev-en at lists.omnis-dev.com> wrote:
> > Hi Das,
> > Yes, those are the same location.
> > After switching to the postgres user, try this:
> > > pg_ctl start -D /Library/PostgreSQL/14/data
> > That should start PostgreSQL. If not, you'll either get a helpful error message back from pg_ctl, or an error message in your PostgreSQL log files that will help you further troubleshoot.
> Well now we are getting somewhere. Here is the relevant snippet from Terminal.. I did the above, logged in as the postgreSQL user, and tried to start Postgres, and got this message, which says it cannot start.. refers me to the log file.
> Dass-Mac-mini:~ postgres$ /Library/PostgreSQL/14/bin/pg_ctl start -D /Library/PostgreSQL/14/data
> waiting for server to start....2022-01-30 13:02:53.690 EST  LOG: redirecting log output to logging collector process
> 2022-01-30 13:02:53.690 EST  HINT: Future log output will appear in directory "log".
> stopped waiting
> pg_ctl: could not start server
> Examine the log output.
> It says to examine the log output. Where do I find this log? I will look for a directory named log. I will look for this log file. If you know where it is do tell me please.
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
More information about the omnisdev-en