Thread: dump/restore and GRANTs

dump/restore and GRANTs

From
"Nigel J. Andrews"
Date:

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