John Horvath <johnh(at)csse(dot)unimelb(dot)edu(dot)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
regards, tom lane
In response to
pgsql-admin by date
|Next:||From: km4hr||Date: 2007-07-18 14:42:54|
|Subject: Re: What user privileges do I need to CREATE FUNCTION's?|
|Previous:||From: Abraham, Danny||Date: 2007-07-18 13:42:38|
|Subject: "CREATE TABLESPACE" cannot run within a Stored Procedure - "Inside a transaction bloc"|