Re: pg_dumpall restore question

[David Brownlee <abs%absd.org@localhost>]

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"

David