Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Yy2MJ-0001TL-GK for pgsql-docs@arkaria.postgresql.org; Thu, 28 May 2015 18:16:47 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Yy2MI-0004hs-PR for pgsql-docs@arkaria.postgresql.org; Thu, 28 May 2015 18:16:46 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Yy2MH-0004hl-Qr for pgsql-docs@postgresql.org; Thu, 28 May 2015 18:16:45 +0000 Received: from mout.gmx.net ([212.227.17.22]) by makus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.84) (envelope-from ) id 1Yy2MA-0000LK-Ji for pgsql-docs@postgresql.org; Thu, 28 May 2015 18:16:44 +0000 Received: from auth2-smtp.messagingengine.com ([66.111.4.228]) by mail.gmx.com (mrgmx101) with ESMTPSA (Nemesis) id 0LeALI-1ZU5Kp3lPA-00puZP for ; Thu, 28 May 2015 20:16:36 +0200 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailauth.nyi.internal (Postfix) with ESMTP id 515C820869 for ; Thu, 28 May 2015 14:16:34 -0400 (EDT) Received: from frontend1 ([10.202.2.160]) by compute5.internal (MEProxy); Thu, 28 May 2015 14:16:34 -0400 X-Sasl-enc: VH7kjl5QXuRMX+iUefXXVoXjGoPgHjSSH38GF1dVpjCu 1432836994 Received: from [192.168.1.147] (unknown [204.145.120.11]) by mail.messagingengine.com (Postfix) with ESMTPA id 19A06C00015; Thu, 28 May 2015 14:16:34 -0400 (EDT) Message-ID: <55675B81.8030109@gmx.net> Date: Thu, 28 May 2015 14:16:33 -0400 From: Peter Eisentraut User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:31.0) Gecko/20100101 Thunderbird/31.7.0 MIME-Version: 1.0 To: "Joshua D. Drake" , pgsql-docs Subject: Re: per feedback I received directly, pg_dump manpage patch References: <55665072.9020409@commandprompt.com> In-Reply-To: <55665072.9020409@commandprompt.com> Content-Type: multipart/mixed; boundary="------------090700030803000805040008" X-Provags-ID: V03:K0:mauA+6om+xYwUg2EA/zWZstThvIvpcS38xtufh1faHznPZCnXhO AKgwsMoURTH4yzaKTZjGWErOBPsCmf8Wi9S6NObKf510zfTNqgByuzgxY9QWnGcI9d9wNEq H3F5mhe2dAZ4gg1dN2pY2VZIOL1+36qGjr2lRZ45RK1gLok4DSv11OJMsGVXwYLu3690O9S GJbS7bZ8UA1gqPw1D+Dkw== X-UI-Out-Filterresults: notjunk:1;V01:K0:Id9106TuGV0=:byBfTd8CWkVlzS0uPZl7zW Q6hlj23lH9AJN2q7+f31Ja/iVCLrShdCsJrfS2xG4rr4nkcl3Pv80yXKt7hBszi6YXo9DXvmE ozXXwbHR+3p0JxDXr8zsN52L+H21FBHfvFK1ma474dMh4zIAkiMhmV1vDA2UlEWpWtgiDGK+s rWtH2XNFwtRWB1czdONSX+c8cqG6GMBglHRtWRC7a7bk6WB2tPIkvpBczjcovxnUYVYLc3vsF //JdLPOGLJq8Wd/CM5vILIV11XDJ5wobhsr74QmYfgc5J43hc8uEpU7GFBy0dsOv9fvt1pwWV 3MtiNNlAHSvfLi3qV7Rmo20RtWC09VFoF6b1pxTal9wB/JQFItbf/s0MRZwcOMMruX7yfkv8K izjedqbQIp0BXvJLpOUqoWbM7nXzxwJsAKP/m+pcAU4NdIomnmtCwBqTsro06MuYKoao6zROp Ii+zBaPF64E25M2klrmjgyEEYGffr67RVEz9CL0bi3CeOG2U9TrAnvraj4J9JNQnrBq0smFbo KWSyYG1b8ClUie+VT8rDC85f9zYBxxHp9kUlw4sllmHJTaxkH7WNSOGydtqXG0QalahCzhpOf oEYU5j4soayIt7FNV+vrVp9+8iDOX10rNrYT7sWcdt4eH97SJXJlvCrIZMZRLO5mAfkuoQqao zB57hUlug4rD9lmT5p39F6ksasYsZVFcNcV1Y0eWfqGhNZA== X-Pg-Spam-Score: -3.0 (---) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org This is a multi-part message in MIME format. --------------090700030803000805040008 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit On 5/27/15 7:17 PM, Joshua D. Drake wrote: > The man page does not clearly state that pg_dump will not dump things > like users or roles. It does mention briefly in the notes section that > pg_dumpall is needed for items that are set via SET but that isn't very > clear on the other items. How about this patch? --------------090700030803000805040008 Content-Type: text/x-diff; name="pg_dump-note.patch" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="pg_dump-note.patch" diff --git a/doc/src/sgml/ref/pg_dump.sgml b/doc/src/sgml/ref/pg_dump.sgml index a6e7b08..33a1902 100644 --- a/doc/src/sgml/ref/pg_dump.sgml +++ b/doc/src/sgml/ref/pg_dump.sgml @@ -46,6 +46,12 @@ + pg_dump only dumps a single database. To save + global objects that are common to all databases in a cluster, such as roles + and tablespaces, use . + + + Dumps can be output in script or archive file formats. Script dumps are plain-text files containing the SQL commands required to reconstruct the database to the state it was in at the time it was --------------090700030803000805040008 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs --------------090700030803000805040008--