pkgsrc-Users archive

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

Re: pg_dumpall restore question

David Brownlee <> writes:

> 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"

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

Home | Main Index | Thread Index | Old Index