pkgsrc-Users archive

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index][Old Index]

Re: pg_dumpall restore question

On Tue, 12 Oct 2021 at 14:02, Joerg Sonnenberger <> 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"


Home | Main Index | Thread Index | Old Index