Moving a database AND changing the superuser
| От | Rich Cullingford |
|---|---|
| Тема | Moving a database AND changing the superuser |
| Дата | |
| Msg-id | 3FDDD39D.1060101@sysd.com обсуждение исходный текст |
| Ответы |
Re: Moving a database AND changing the superuser
Re: Moving a database AND changing the superuser Re: Moving a database AND changing the superuser |
| Список | pgsql-admin |
All,
I did a pg_dumpall in preparation for moving one of our databases from
PG7.3 to PG7.4, but I just realized I have another problem: that DB
(which has served us faithfully for some time) was created for superuser
'postgres,' whilst our new DBs use a superuser name that's aligned with
our product. I'm expecting conflicts when I try to restore the data into
a 'new' DB. Am I right, and if so, what can I do? (I know I could just
try it, but the old database machine will be disappearing soon, and if I
need to do a different kind of dump -- per DB, for example -- I need to
know that soonest.)
Thanks,
Rich Cullingford
System Detection, Inc.
rculling@sysd.com
В списке pgsql-admin по дате отправления: