Re: Specific objects backup in PostgreSQL

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: nikhil kumar <nikhil(dot)dba97(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Specific objects backup in PostgreSQL
Date: 2024-07-10 18:41:01
Message-ID: CAKFQuwace9Tqp-7ANOovEDY58vWvEg3AmA5wpoMij0SFJPLYSQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, Jul 10, 2024 at 11:05 AM nikhil kumar <nikhil(dot)dba97(at)gmail(dot)com>
wrote:

>
> We received a request from client. They required all functions, stored
> procedures and triggers backup. can anyone please let me know. How to take
> backup only above objects.
>

This hardly qualifies as a performance question.

You might try the -general list if you want to brainstorm workarounds
because pg_dump itself doesn't provide any command line options to give you
this specific subset of your database.

David J.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Olivier Gautherot 2024-07-10 18:42:49 Re: Specific objects backup in PostgreSQL
Previous Message nikhil kumar 2024-07-10 18:05:22 Specific objects backup in PostgreSQL