how to connect to freshly installed postgresql@15

[tezza1971]

Output of brew config

HOMEBREW_VERSION: 4.1.10
ORIGIN: https://github.com/Homebrew/brew
HEAD: 12c8778af976269344f3c0b914243e178fc4ffbd
Last commit: 2 days ago
Core tap JSON: 09 Sep 02:31 UTC
HOMEBREW_PREFIX: /opt/homebrew
HOMEBREW_CASK_OPTS: []
HOMEBREW_MAKE_JOBS: 8
Homebrew Ruby: 2.6.10 => /System/Library/Frameworks/Ruby.framework/Versions/2.6/usr/bin/ruby
CPU: octa-core 64-bit arm_firestorm_icestorm
Clang: 15.0.0 build 1500
Git: 2.42.0 => /opt/homebrew/bin/git
Curl: 8.1.2 => /usr/bin/curl
macOS: 13.5.1-arm64
CLT: 15.0.0.0.1.1692336968
Xcode: 15.0
Rosetta 2: false

Output of brew doctor

Warning: Unbrewed dylibs were found in /usr/local/lib.
If you didn't put them there on purpose they could cause problems when
building Homebrew formulae, and may need to be deleted.

Unexpected dylibs:
  /usr/local/lib/libcpsrt.dylib
  /usr/local/lib/libjack.0.dylib
  /usr/local/lib/libjacknet.0.dylib
  /usr/local/lib/libjackserver.0.dylib
  /usr/local/lib/libndi.4.dylib
  /usr/local/lib/libndi.dylib

Warning: Unbrewed header files were found in /usr/local/include.
If you didn't put them there on purpose they could cause problems when
building Homebrew formulae, and may need to be deleted.

Unexpected header files:
  /usr/local/include/jack/control.h
  /usr/local/include/jack/intclient.h
  /usr/local/include/jack/jack.h
  /usr/local/include/jack/jslist.h
  /usr/local/include/jack/metadata.h
  /usr/local/include/jack/midiport.h
  /usr/local/include/jack/net.h
  /usr/local/include/jack/ringbuffer.h
  /usr/local/include/jack/session.h
  /usr/local/include/jack/statistics.h
  /usr/local/include/jack/systemdeps.h
  /usr/local/include/jack/thread.h
  /usr/local/include/jack/transport.h
  /usr/local/include/jack/types.h
  /usr/local/include/jack/uuid.h
  /usr/local/include/jack/weakjack.h
  /usr/local/include/jack/weakmacros.h

Warning: Unbrewed '.pc' files were found in /usr/local/lib/pkgconfig.
If you didn't put them there on purpose they could cause problems when
building Homebrew formulae, and may need to be deleted.

Unexpected '.pc' files:
  /usr/local/lib/pkgconfig/jack.pc

Description of issue

I have used postgresql in the past (not with brew) and the default credentials are user:postgres pass:postgres

How do I connect to it now with homebrew? (I'm using pgAdmin latest)

$ psql -U postgres psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: FATAL: role "postgres" does not exist

[ZhongRuoyu]

The default username is your own OS username (the output of whoami).

As suggested in the caveats (run brew info postgresql@15 to see), the default database cluster is created with initdb --locale=C -E UTF-8 $HOMEBREW_PREFIX/var/postgresql@15. The username is not speficied in the command, so it defaults to your OS username.

[tezza1971]

Oh I see. That explains a lot. All sorted.

[dobblehq]

The above work, i ran psql -U user -d postgres, user is my pc username, (run whoami to know user), then add -d postgres for the database

[carlrempel]

This is the magic key: -d postgres