prefetcher,
@prefetcher@miku.place avatar

i genuinely wonder how the akkoma db schema looks like, that it gets bloated so easily

prefetcher,
@prefetcher@miku.place avatar

i wanna log into psql but it keeps throwing this error back at me

psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: Peer authentication failed for user "akkoma"

subtype,
@subtype@insufferable.tools avatar

@prefetcher hmm I had it set up so both the user (which runs akkoma) and database name is the same and then running psql as this user works, I'm not sure which is relevant here.

prefetcher,
@prefetcher@miku.place avatar

@subtype yeah, it just doesn't for me for some reason

bl00d,
@bl00d@yourwalls.today avatar

@prefetcher @subtype had the same problem, brb maybe I will find solution in shell's history

bl00d,
@bl00d@yourwalls.today avatar

@prefetcher @subtype
sudo -u postgres psql postgres

Ukko,
@Ukko@akko.disqordia.space avatar

@prefetcher @subtype try sudo -u akkoma in front maybe

Ukko,
@Ukko@akko.disqordia.space avatar

@prefetcher @subtype or the doas equivalent

prefetcher,
@prefetcher@miku.place avatar

@Ukko @subtype this worked, thank you so much!!!

Ukko,
@Ukko@akko.disqordia.space avatar

@prefetcher @subtype anything for the glorious miku nation

  • All
  • Subscribed
  • Moderated
  • Favorites
  • random
  • Hentai
  • doujinshi
  • announcements
  • general
  • All magazines