Re: pg_dump, pg_dumpall, pg_restore: Add --no-policies option - Mailing list pgsql-hackers

From newtglobal postgresql_contributors
Subject Re: pg_dump, pg_dumpall, pg_restore: Add --no-policies option
Date
Msg-id 174184875546.294107.9656924571663274690.pgcf@coridan.postgresql.org
Whole thread Raw
In response to Re: pg_dump, pg_dumpall, pg_restore: Add --no-policies option  (Jim Jones <jim.jones@uni-muenster.de>)
List pgsql-hackers
The following review has been posted through the commitfest application:
make installcheck-world:  not tested
Implements feature:       not tested
Spec compliant:           not tested
Documentation:            not tested

Hi,
Tested this patch with `--no-policies` option works as expected by ensuring that policy definitions are not included in
databasebackups. Successfully tested using `pg_dump`, `pg_dumpall`, and `pg_restore`, confirming that policies are
excludedupon restoration. The `admin_full_access` policy was correctly applied, granting full access to the `admin`
rolefor the `users` table. Additionally, the `read_only_access` policy was verified to restrict the `readonly` role to
onlyperforming `SELECT` operations.
 

Regards,
Newt Global PostgreSQL Contributors

pgsql-hackers by date:

Previous
From: newtglobal postgresql_contributors
Date:
Subject: Re: Add XMLNamespaces to XMLElement
Next
From: Ashutosh Bapat
Date:
Subject: Re: Test to dump and restore objects left behind by regression