When you create a db and restore use the same user who is registered for the connection.
# psql -U sql-ledger -c "create database gaia;" # psql -U sql-ledger gaia < mydump.sql -- Dieter Simader http://www.sql-ledger.com (780) 472-8161 DWS Systems Inc. Accounting Software Fax: 478-5281 ============ On a clear disk you can seek forever ========== On Wed, 27 Sep 2006, Mark Bucciarelli wrote: > 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 > ------------------------------------------------------------------------- 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
