David Brownlee <abs%absd.org@localhost> writes: > On Tue, 12 Oct 2021 at 14:02, Joerg Sonnenberger <joerg%bec.de@localhost> wrote: >> >> On Tue, Oct 12, 2021 at 11:50:43AM +0200, Thomas Klausner wrote: >> > Should we have a 'postgres' user instead of the 'pgsql' one? >> >> There is no consensus even in the Linux world on this, so I don't think >> our choice is better or worse. It just depends on the popularity of the >> Linux distro the SO poster used :) > > There is one advantage - postgres defaults to creating a postgres > database, so having the default user match that avoids a NetBSD > specific "oh, you have to add a database name to every psql command" Except that pgsql is super user, and really should be used only for doing database admin things, and then almost everything is done under some other user.
Attachment:
signature.asc
Description: PGP signature