It seems that pgAdmin treats any schema that starts with "pg" as a
system schema and hides it by default. The docs mention avoiding the
prefix "pg_":
"Schema names beginning with pg_ are reserved for system purposes and
may not be created by users."
http://www.postgresql.org/docs/8.1/inte
On Wed, May 17, 2006 at 05:04:56PM +0800, Hank Hsiung wrote:
> Hi list,
>
> I am using Postgresql version 8.1. It has been announced that in this
> version, autovacuum is no longer a seperate process and is integrated into
> postgres. However, I can't tell if my database has autovacuumed. I've t
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Dave Page
> Sent: 17 May 2006 11:46
> To: [EMAIL PROTECTED]; pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] role with "CREATEDB" and
> "CREATEROLE" without effect on GUI
>
>
> >
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> Thomas Sondag
> Sent: 17 May 2006 10:20
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] role with "CREATEDB" and
> "CREATEROLE" without effect on GUI
>
> Hi,
>
> I would like
Hi,
I would like to create an admin account without "SUPERUSER" rights to
manage databases and users creations without risk.
SQL :
CREATE ROLE admin WITH NOSUPERUSER CREATEDB CREATEROLE INHERIT LOGIN
ENCRYPTED PASSWORD 'mot_de_passe';
SQL under "admin" with psql :
CREATE ROLE production WITH NO
Hi list,
I am using Postgresql version 8.1. It has been
announced that in this version, autovacuum is no longer a seperate process and
is integrated into postgres. However, I can't tell if my database has
autovacuumed. I've turned on the configurations in the autovacuum
section in postgres
