Re: pg_dumpall restore question

[Thomas Klausner <wiz%NetBSD.org@localhost>]

On Tue, Oct 12, 2021 at 11:32:33AM +0200, Adam Ciarciński wrote:
> > Hi!
> > 
> > I'm doing postgresql backups with pg_dumpall.
> > When I restore them, all the guides on the net say to just use
> > 
> >     psql -f backupfile
> > 
> > but when I do that as pgsql user on NetBSD, I get
> > 
> >     psql: error: FATAL:  database "pgsql" does not exist
> > 
> > and my workaround was to do
> > 
> >     psql -d postgres -f backupfile
> > 
> > instead. Why is that necessary?
> > Thomas
> 
> `psql` has to connect to a database; the database name defaults to username and that doesn't exists in your case, so you have to provide an existing database name.

Thanks. And why does it seem to exist in other setups?
Is there something we do differently in pkgsrc to other packaging systems?
Should we have a 'postgres' user instead of the 'pgsql' one?
 Thomas