Re: moving user obejcts to production

In article <66d229f1(dot)0110020612(dot)5c87e712(at)posting(dot)google(dot)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