On Monday, February 27, 2012 6:21:56 am hamann.w@t-online.de wrote:
> Hi, I am just trying to build a duplicate of our database server.
> Like the main one, I compiled it from source, ran initdb, created a
> superuser, and then proceded to creating a database.
> However, db creation is denied to the superuser. Likewise,
> if I create the db as user postgres and then change ownership, I still
> do not have enough rights to, say, install a language.
> The pg_database.datdba as well as pg_user tables seem to have correct
> values. Where could I look next?
You say you are trying to duplicate a database.
The superuser you are creating, is it the same name in both servers?
Does this mean part of the process is a pg_dump and then a pg_restore to the new
database?
If so is that where you are getting the error, on using pg_restore to recreate
the database?
If you are not using pg_restore, how are you creating the database?
In any case what is the actual error message?
> Regards
> Wolfgang Hamann
--
Adrian Klaver
adrian.klaver@gmail.com