Re: suggestion for backup (pg_dump) - Mailing list pgsql-general

From c k
Subject Re: suggestion for backup (pg_dump)
Date
Msg-id CAN2Y=uMC8agLZ8EmzDEqXyzRUD0BnP=oW5geTbDz2N=rv5Ji-A@mail.gmail.com
Whole thread Raw
List pgsql-general
Yes, It is useful. But situation is different. Most of the times objects are first created, tested and only after finalization can go in the extension update file. Also it can be difficult not to get the object definitions from an extension in the backup from pg_dump. A customer could have to execute commands to create and update extensions for all versions to current. It can be very difficult.
My suggestion to provide an extra option for pg_dump to include objects of specific types only along with switch for a schema.
Thanks for help. Looking out if it is really possible to use extension for our software.

Regards,

C P Kulkarni
On Sun, May 20, 2012 at 12:43 PM, Gabriele Bartolini <gabriele.bartolini@2ndquadrant.it> wrote:
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


pgsql-general by date:

Previous
From: Ian Harding
Date:
Subject: Re: Locking or Something Else?
Next
From: c k
Date:
Subject: losing schema name in pg_dump