changing the PostgreSQL default user

Matthias Fechner idefix at
Tue Oct 22 05:28:58 UTC 2019

Am 21.10.2019 um 08:22 schrieb David Newman:
> FreeBSD recently changed its default version of PostgreSQL from 9.5 to 11.
> However, attempts to run 'pg_upgrade' on the databases failed for me
> because my 9.5 install had a default user of 'pgsql' and version 11 goes
> with 'postgres' instead [1].

why not follow the UPDATING entry in /usr/ports/UPDATING?



"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs, and the universe trying to
produce bigger and better idiots. So far, the universe is winning." --
Rich Cook

More information about the freebsd-questions mailing list