Change owner of all database objects

Поиск
Список
Период
Сортировка
От Andrus
Тема Change owner of all database objects
Дата
Msg-id dqjc02$2j5q$1@news.hub.org
обсуждение исходный текст
Ответы Re: Change owner of all database objects
Список pgsql-general
Currently all my database objects are owned by superuser postgres .

I need to change owner to a nonprivileged role for all objects in a
database.

I'm using Postgres 8.1 server and client in Windows XP, only plpSQL language
installed in server.

I'm thinking about the following possibilities:

1. Create a loop over all database objects and issue change owner statements
2. Update system tables.
3. Make database dump and restore
4. make text dump and run some global find/replace. I'm not sure which
utility can handle it in windows

Is there any sample how to do it in Windows ?

Andrus.



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

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: Distance calculation
Следующее
От: Marcin
Дата:
Сообщение: Re: Huge number of disk writes after migration to 8.1