diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2025-03-16 18:08:15 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2025-03-16 18:08:15 -0400 |
| commit | cd3c45125d2d92e86ad7530b162562a23d063c26 (patch) | |
| tree | e43f923efbd683e1db726e16d4882907708f7ae8 /doc/src | |
| parent | 44890442398cf3a65230d53167e61905d2b0d348 (diff) | |
| download | postgresql-cd3c45125d2d92e86ad7530b162562a23d063c26.tar.gz postgresql-cd3c45125d2d92e86ad7530b162562a23d063c26.zip | |
pg_dump, pg_dumpall, pg_restore: Add --no-policies option.
Add --no-policies option to control row level security policy handling
in dump and restore operations. When this option is used, both CREATE
POLICY commands and ALTER TABLE ... ENABLE ROW LEVEL SECURITY commands
are excluded from dumps and skipped during restores.
This is useful in scenarios where policies need to be redefined in the
target system or when moving data between environments with different
security requirements.
Author: Nikolay Samokhvalov <nik@postgres.ai>
Reviewed-by: Greg Sabino Mullane <htamfids@gmail.com>
Reviewed-by: Jim Jones <jim.jones@uni-muenster.de>
Reviewed-by: newtglobal postgresql_contributors <postgresql_contributors@newtglobalcorp.com>
Discussion: https://postgr.es/m/CAM527d8kG2qPKvbfJ=OYJkT7iRNd623Bk+m-a4ngm+nyHYsHog@mail.gmail.com
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/pg_dump.sgml | 9 | ||||
| -rw-r--r-- | doc/src/sgml/ref/pg_dumpall.sgml | 9 | ||||
| -rw-r--r-- | doc/src/sgml/ref/pg_restore.sgml | 10 |
3 files changed, 28 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/pg_dump.sgml b/doc/src/sgml/ref/pg_dump.sgml index 1975054d7bf..0ae40f9be58 100644 --- a/doc/src/sgml/ref/pg_dump.sgml +++ b/doc/src/sgml/ref/pg_dump.sgml @@ -1106,6 +1106,15 @@ PostgreSQL documentation </varlistentry> <varlistentry> + <term><option>--no-policies</option></term> + <listitem> + <para> + Do not dump row security policies. + </para> + </listitem> + </varlistentry> + + <varlistentry> <term><option>--no-publications</option></term> <listitem> <para> diff --git a/doc/src/sgml/ref/pg_dumpall.sgml b/doc/src/sgml/ref/pg_dumpall.sgml index c2fa5be9519..ae5afb3c7d5 100644 --- a/doc/src/sgml/ref/pg_dumpall.sgml +++ b/doc/src/sgml/ref/pg_dumpall.sgml @@ -442,6 +442,15 @@ exclude database <replaceable class="parameter">PATTERN</replaceable> </varlistentry> <varlistentry> + <term><option>--no-policies</option></term> + <listitem> + <para> + Do not dump row security policies. + </para> + </listitem> + </varlistentry> + + <varlistentry> <term><option>--no-publications</option></term> <listitem> <para> diff --git a/doc/src/sgml/ref/pg_restore.sgml b/doc/src/sgml/ref/pg_restore.sgml index 199ea3345f3..35140187807 100644 --- a/doc/src/sgml/ref/pg_restore.sgml +++ b/doc/src/sgml/ref/pg_restore.sgml @@ -724,6 +724,16 @@ PostgreSQL documentation </varlistentry> <varlistentry> + <term><option>--no-policies</option></term> + <listitem> + <para> + Do not output commands to restore row security policies, even if + the archive contains them. + </para> + </listitem> + </varlistentry> + + <varlistentry> <term><option>--no-publications</option></term> <listitem> <para> |