problem setting up
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?
Regards
Wolfgang Hamann
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