Thread: suggestion for backup

Hi,
In day to day work I need to dump objects of only specific types like functions, types, view etc from a schema. I know that it will be better to use separate schemas for  similar tasks and already using it. This problem arises when I have to issue an update script to the client having only function mostly. And as most of the functions are dependent on others and having more than 1100 functions it becomes hard to write a list of objects for pg_dump.
So I suggest to provide a feature in pg_dump/pg_dumpall to backup only specific type of objects like tables, functions etc. It will be very useful for users who are in database development.

thanks,

C P Kulkarni

Hi,

Il 19/05/12 19:09, c k ha scritto:
> similar tasks and already using it. This problem arises when I have to
> issue an update script to the client having only function mostly. And
> as most of the functions are dependent on others and having more than
> 1100 functions it becomes hard to write a list of objects for pg_dump.
It may sound unrelated at first, but if you have PostgreSQL 9.1 this use
case matches very well with the new EXTENSION framework. Please look at
the CREATE EXTENSION command and evaluate it.

Cheers,
Gabriele

--
  Gabriele Bartolini - 2ndQuadrant Italia
  PostgreSQL Training, Services and Support
  gabriele.bartolini@2ndQuadrant.it | www.2ndQuadrant.it