Hi All,
Migrating db to another server, and moved up to PostgreSql 8.1.
Creating sql-ledger user has different dialog that what is in
README. When I enter
createuser -d -r -P sql-ledger
it asks if sql-ledger should be a super user. (I said no.)
I then created the db via admin.pl and imported my dump as the
user pgsql.
# su - pgsql
# psql gaia < mydump.sql
Now, when I try to login I get the message:
Error!
SELECT version FROM defaults
ERROR: permission denied for relation defaults
Does the PostgreSql sql-ledger need to be superuser?
Or do I need to import the dump as sql-ledger user?
Or ??
Thanks,
m
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
sql-ledger-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
