| From: | Kevin Bailey <kbailey(at)freewayprojects(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Further question RE dumping and reloading whole database server |
| Date: | 2009-04-10 09:58:44 |
| Message-ID: | 49DF1854.9050106@freewayprojects.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Further to an earlier question..
I've tried
pg_dumpall --inserts --clean -h $REMOTE -U admin | psql -U postgres
template1
To extract a whole database from a remote server and to reload it into a
local DB but this produces tons of errors.
ERROR: role "admin" cannot be dropped because some objects depend on it
DETAIL: owner of database test1
owner of database test
7 objects in database test1
201 objects in database test
ERROR: role "admin" already exists
ERROR: current user cannot be dropped
ERROR: role "postgres" already exists
ERROR: role "sql-ledger" cannot be dropped because some objects depend on it
DETAIL: owner of database bean-demo
owner of database bean-cash
owner of database bean-41
Is there something I need to do RE the user I connect as?
Or should I do the dump to a file - transfer the file and then attempt
the reload?
Thanks,
bailey86
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2009-04-10 13:42:43 | Re: Finding out on exactly what I am stuck |
| Previous Message | Kevin Bailey | 2009-04-10 09:34:44 | backing and restoring whole database server - how does this script look |