Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YxkZE-0007d6-CU for pgsql-docs@arkaria.postgresql.org; Wed, 27 May 2015 23:16:56 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YxkZD-00045c-TJ for pgsql-docs@arkaria.postgresql.org; Wed, 27 May 2015 23:16:55 +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 1YxkZD-00045O-7s for pgsql-docs@postgresql.org; Wed, 27 May 2015 23:16:55 +0000 Received: from lists.commandprompt.com ([69.168.55.30]) by makus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1YxkZ9-0003rX-KA for pgsql-docs@postgresql.org; Wed, 27 May 2015 23:16:53 +0000 Received: from [192.168.1.3] (spinlock.commandprompt.com [69.168.55.30]) by lists.commandprompt.com (Postfix) with ESMTPA id 391722FA for ; Wed, 27 May 2015 16:16:50 -0700 (PDT) Received: from [192.168.1.3] ([67.168.169.165] helo=[192.168.1.3]) by assp.commandprompt.com with ESMTPS(AES128-SHA) (2.1.1); 27 May 2015 16:16:49 -0700 Message-ID: <55665072.9020409@commandprompt.com> Date: Wed, 27 May 2015 16:17:06 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.6.0 MIME-Version: 1.0 To: pgsql-docs Subject: per feedback I received directly, pg_dump manpage patch Content-Type: multipart/mixed; boundary="------------080907050604040708020702" X-Assp-Version: 2.1.1(11364) on assp.commandprompt.com X-Assp-Client-SSL: yes X-Assp-ID: assp.commandprompt.com m1-68610-09754 X-Assp-Envelope-From: jd@commandprompt.com X-Assp-Intended-For: pgsql-docs@postgresql.org X-Assp-Original-Subject: per feedback I received directly, pg_dump manpage patch X-Pg-Spam-Score: -1.9 (-) 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. --------------080907050604040708020702 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit 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. -- Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564 PostgreSQL Centered full stack support, consulting and development. Announcing "I'm offended" is basically telling the world you can't control your own emotions, so everyone else should do it for you. --------------080907050604040708020702 Content-Type: text/x-patch; name="pg_dump.man.diff" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="pg_dump.man.diff" diff --git a/doc/src/sgml/ref/pg_dump.sgml b/doc/src/sgml/ref/pg_dump.sgml index a6e7b08..4cb647c 100644 --- a/doc/src/sgml/ref/pg_dump.sgml +++ b/doc/src/sgml/ref/pg_dump.sgml @@ -45,6 +45,14 @@ PostgreSQL documentation accessing the database (readers or writers). + + + is required for a full backup as + pg_dump does not backup the required global + options such as user or roles. + + + Dumps can be output in script or archive file formats. Script dumps are plain-text files containing the SQL commands required --------------080907050604040708020702 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 --------------080907050604040708020702--