Thanks Rolf. I'll give it a shot tonight and see what I can find. There's a version mismatch as well, which I believe is throwing another monkey wrench in the equation. I'm migrating from a 2.6x server to 2.8.35.
On Tue, Sep 27, 2011 at 5:50 PM, "Rolf Stöckli" <[email protected]> wrote: > I'd suggest you use SQL-Ledger to create a backup of your 3 databases and > restore them individually under the user name "admin". > > > > Rolf > > Matt Abernathy <[email protected]> hat am 27. September 2011 um 23:46 > geschrieben: > >> Thanks Rich. >> >> So in your case, for the nevada database, would you add a user, set >> the database as nevada and db user as rshepard? >> >> >> On Tue, Sep 27, 2011 at 5:15 PM, Rich Shepard <[email protected]> >> wrote: >> > On Tue, 27 Sep 2011, Matt Abernathy wrote: >> > >> >> Here is my confusion. Is the 'admin' Owner the database owner or is >> >> that >> >> the superuser on the system? ie. Is admin=root, or is admin the actual >> >> database owner? >> > >> > Matt, >> > >> > The database owner is 'admin'. That means you (as a user) might have >> > limited access to those databases but you don't control them. >> > >> > Here is what I have: >> > >> > [rshepard@salmo ~]$ psql -l >> > List of databases >> > Name | Owner | Encoding | Collation | Ctype | Access >> > privileges >> > >> > -----------+------------+-----------+-----------+-------+----------------------- >> > aesi | sql-ledger | SQL_ASCII | C | C | >> > cms | rshepard | SQL_ASCII | C | C | >> > jerritt | rshepard | SQL_ASCII | C | C | >> > jerrittwq | rshepard | SQL_ASCII | C | C | >> > nevada | rshepard | SQL_ASCII | C | C | >> > postgres | postgres | SQL_ASCII | C | C | >> > refdb | postgres | SQL_ASCII | C | C | >> > scirefs | rshepard | SQL_ASCII | C | C | >> > >> > plus the system templates. >> > >> > Rich >> > _______________________________________________ >> > SQL-Ledger mailing list >> > [email protected] >> > http://lists.ledger123.com/mailman/listinfo/sql-ledger >> > >> _______________________________________________ >> SQL-Ledger mailing list >> [email protected] >> http://lists.ledger123.com/mailman/listinfo/sql-ledger > _______________________________________________ > SQL-Ledger mailing list > [email protected] > http://lists.ledger123.com/mailman/listinfo/sql-ledger > > _______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
