Tom Lane wrote:
Plan B is to leave the pgsql user alone and add another superuser named postgres. You can have more than one superuser ...
Yes, that's what my hosting provider (hub.org, which also hosts postgresql.org) seems to have done. This also avoids another minor problem: initdb on UNIX appears to create a 'postgres' database regardless of who runs the procedure (aside from template0 and template1; I don't have a 'postgres' database on Windows and since it's been a year I don't recall what the Windows initdb did). So when the 'pgsql' user invokes psql without specifying a database, there's no 'pgsql' database to be found.
Joe
