Postgres Pro
Downloads
Home   >   mailing lists

Re: Setting usesuper bit for user postgres. - Mailing list pgsql-admin

From Tom Lane
Subject Re: Setting usesuper bit for user postgres.
Date
Msg-id 18110.1184768792@sss.pgh.pa.us
Whole thread Raw
In response to Setting usesuper bit for user postgres.  (John Horvath <johnh@csse.unimelb.edu.au>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: n0g0013
Date:
Subject: Re: am i creating a performance bottleneck?
Next
From: Alvaro Herrera
Date:
Subject: Re: syslog: log line length?