Re: Setting usesuper bit for user postgres.

John Horvath <johnh@csse.unimelb.edu.au> writes:
> The 'usesuper' bit for user "postgres" was set to 'f' by default in the
> pg_shadow table in my
> PostgreSQL 7.4.2 installation when I installed it on my OS X host.

I seriously, seriously doubt that there was no superuser by default.

> Any pointers on how to fix the usesuper bit issue for user postgres when
> this is the only DB "superuser"?

Standalone mode will make you a superuser.  See the postgres reference
page.

            regards, tom lane