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 по дате отправления: