Re: moving user obejcts to production

Поиск
Список
Период
Сортировка
От marc@oscar.eng.cv.net (Marc Spitzer)
Тема Re: moving user obejcts to production
Дата
Msg-id slrn9rjtk9.qtb.marc@oscar.eng.cv.net
обсуждение исходный текст
Ответ на moving user obejcts to production  (s.chava@wcom.com (Srinivasa Rao Chava))
Список pgsql-admin
In article <66d229f1.0110020612.5c87e712@posting.google.com>,
Srinivasa Rao Chava wrote:
> Hi,
> I have a postgresql database(DEPG) in development which contains three
> user accounts(pldev,extranet,intranet) for different applications. One
> application(pldev) has been finished development and the other two are
> still in development stage. The finished application(pldev) which
> contains several tables , functions, procedures and triggers need to
> be moved to production, leaving the unfinished in development.
> I createa database PGPROD in production box and trying to move only
> the objects belonging to finished application(pldev).If I use pg_dump,
> it is dumping full database.
> I need to dump only the finished application account(pldev).
> In oracle , we use export with owner= username option for exporting
> the individual users objects. and import in production server into the
> respective user's account,say pldev in production database.
> How to do it in postgresql? and is there any way to do it?
> Thanks
> chava

I do not know much about postgress yet but how about this:
1: dump db somewhere
2: install it somewhere else
3: make changes needed to make it production( remove 2 users)
4: dump the new production db
5: ship

marc

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

Предыдущее
От: "Pier Paolo Bortone"
Дата:
Сообщение: HELP: Insert FLOAT in ITALIAN format.
Следующее
От: Chris Pesko
Дата:
Сообщение: Storage management?????