Postgres Pro
Downloads
Home   >   mailing lists

dump/restore and GRANTs - Mailing list pgsql-general

From Nigel J. Andrews
Subject dump/restore and GRANTs
Date
Msg-id Pine.LNX.4.21.0305062323030.13508-100000@ponder.fairway2k.co.uk
Whole thread Raw
List pgsql-general
Tree view 

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

pgsql-general by date:

Previous
From: Scott Chapman
Date:
Subject: How to hook up Access to Postgres?
Next
From: Arjen van der Meijden
Date:
Subject: Re: Server error