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