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
