Upgrading from 9.1 to 9.3

Поиск
Список
Период
Сортировка
От JORGE MALDONADO
Тема Upgrading from 9.1 to 9.3
Дата
Msg-id CAAY=A7_bcKAQxt1TN3Vebf5dRnHrLWCDub_MkRSwkUTp74=Kig@mail.gmail.com
обсуждение исходный текст
Ответы Re: Upgrading from 9.1 to 9.3  (Venkata Balaji Nagothi <vbnpgc@gmail.com>)
Список pgsql-novice
I am planning to upgrade PostgreSQL from version 9.1 to 9.3 and I would like to do it backing up the current 9.1 DB with 9.3 backup command. My actual DB has a tablespace, group roles and login roles. I suppose that I need to "re-create" the whole picture including the tablespace, group roles and login roles. So, after backing up my DB, I should delete the tablespace in order to create it in the new version. Also, I should add the group and login roles to the new version and finally perform a restore. Of course, the backup should contain table privilegies. Is my approach correct or is there an easier way to achieve my goal?

Respectfully,
Jorge Maldonado

В списке pgsql-novice по дате отправления:

Предыдущее
От: Michael Rowan
Дата:
Сообщение: Postgres 9.1 trigger function parameters
Следующее
От: Venkata Balaji Nagothi
Дата:
Сообщение: Re: Upgrading from 9.1 to 9.3