dump/restore and GRANTs

From: "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: dump/restore and GRANTs
Date: 2003-05-06 22:28:18
Message-ID: Pine.LNX.4.21.0305062323030.13508-100000@ponder.fairway2k.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Has anyone else noticed doing a:

pg_dump -C ...

and then a:

pg_restore -C ...

doesn't generate a:

GRANT CREATE ON DATABASE ...

after the CREATE DATABASE ... command?

It kinda screws things up when it then switches user and tries to create a
schema.

--
Nigel J. Andrews

Browse pgsql-general by date

  From Date Subject
Next Message Arjen van der Meijden 2003-05-06 22:35:42 Re: Server error
Previous Message Scott Chapman 2003-05-06 21:55:44 How to hook up Access to Postgres?