Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fdw57-0001Fh-Lf for pgsql-admin@arkaria.postgresql.org; Fri, 13 Jul 2018 11:17:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fdw56-0007ub-6E for pgsql-admin@arkaria.postgresql.org; Fri, 13 Jul 2018 11:17:48 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fdnrX-0005yR-Sv for pgsql-admin@lists.postgresql.org; Fri, 13 Jul 2018 02:31:15 +0000 Received: from n3.nabble.com ([162.255.23.22]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fdnrQ-0000IB-V5 for pgsql-admin@postgresql.org; Fri, 13 Jul 2018 02:31:15 +0000 Received: from n3.nabble.com (localhost [127.0.0.1]) by n3.nabble.com (Postfix) with ESMTP id C8BE5DFC7021 for ; Thu, 12 Jul 2018 19:31:06 -0700 (MST) Date: Thu, 12 Jul 2018 19:31:06 -0700 (MST) From: pavna To: pgsql-admin@postgresql.org Message-ID: <1531449066819-0.post@n3.nabble.com> Subject: How do I exclude a schema , a function and a table from pg_backup MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk I need to exclude a schema, few tables and functions defined in public schema. How do i exclude them from the backup ? I know how to exclude schema and tables. is there a way to exclude 1 or more functions? sudo -u postgres pg_dump -Fc -exclude-schema=schema1 --exclude-table=table1 --disable-triggers -f DB.dump database1 -- Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html