Backup Functions

From: Sridhar Parepalli <Sridhar(dot)Parepalli(at)sas(dot)com>
To: pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: Backup Functions
Date: 2021-08-18 15:05:42
Message-ID: DM6PR05MB62655EA131770BD3BABA99E6F3FF9@DM6PR05MB6265.namprd05.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello experts,
I was just wondering should a schema of a database contain functions and triggering functions does the pg_dump include functions as it takes back up of the schema? I'm on postgres 11 version.

Here's my command looks like
/pg_dump -Fd --lock-wait-timeout 300 -d tenant1 -n public -f /pgbackup/tenant1_public_20210816_233807

I know in the public schema of the Tenant database there are over 60 functions and are not backed up. Any pointers are greatly helpful.

Regards,
Sridhar Parepalli

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Vijaykumar Jain 2021-08-18 15:30:14 Re: Backup Functions
Previous Message aditya desai 2021-08-18 10:18:57 Re: Is there any way to invoke Java API from PostgreSQL