Skip site navigation (1) Skip section navigation (2)

Re: pg_dump roles support

From: Benedek László <laci(at)benedekl(dot)tvnetwork(dot)hu>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: pg_dump roles support
Date: 2008-10-11 06:45:16
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
Hello All,

in my last mail
I have sent you a patch of pg_dump and pg_dumpall --role option support. 
Nobody replied
or commented jet so now I send it again. The attached patch is the same 
as the last one,
except it is against the current upstream HEAD.

The patch contains the following things:

- pg_dump and pg_dumpall accepts the --role=rolename parameter, and 
sends a SET ROLE

command on their connections
- pg_dumpall passes this option to the called pg_dump process
- pg_dump emits the SET ROLE command into the archive
- sgml documentation of this feature


  doc/src/sgml/ref/pg_dump.sgml        |   16 ++++++++++
  doc/src/sgml/ref/pg_dumpall.sgml     |   27 +++++++++++++----
  src/bin/pg_dump/pg_backup.h          |    2 +
  src/bin/pg_dump/pg_backup_archiver.c |   38 +++++++++++++++++++++--
  src/bin/pg_dump/pg_dump.c            |   55 
  src/bin/pg_dump/pg_dumpall.c         |   26 +++++++++++++++-
  6 files changed, 153 insertions(+), 11 deletions(-)

Thank you, best regards:
Laszlo Benedek

Attachment: pg_dump.role.patch
Description: text/x-patch (13.2 KB)

In response to


pgsql-hackers by date

Next:From: ITAGAKI TakahiroDate: 2008-10-11 09:05:35
Subject: contrib/pg_stat_statements
Previous:From: Pavel StehuleDate: 2008-10-11 06:29:25
Subject: Re: patch: array_ndims

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group