Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id BC5E62E004A for ; Wed, 16 Apr 2008 00:41:27 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 26457-03 for ; Wed, 16 Apr 2008 00:41:20 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by developer.postgresql.org (Postfix) with ESMTP id DD5F02E0045 for ; Wed, 16 Apr 2008 00:41:19 -0300 (ADT) Received: from localhost (or-69-34-217-90.sta.embarqhsd.net [69.34.217.90]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id m3G3fvLi011170 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Tue, 15 Apr 2008 20:41:58 -0700 Date: Tue, 15 Apr 2008 20:41:23 -0700 From: "Joshua D. Drake" To: pgsql-docs@postgresql.org Subject: Slight change to backup.sgml Message-ID: <20080415204123.64e29767@commandprompt.com> Organization: Command Prompt, Inc. X-Mailer: Claws Mail 3.0.2 (GTK+ 2.12.9; x86_64-pc-linux-gnu) Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="MP_/twr2qsjkRDorMqaU0fO_m00" X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Tue, 15 Apr 2008 20:41:58 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/16 X-Sequence-Number: 4876 --MP_/twr2qsjkRDorMqaU0fO_m00 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline As worded currently: Restore the database files from your backup dump. Says to me... use pg_restore as I used pg_dump to make a dump. I changed it to: Restore the database files from your base backup. As creating the base backup is referenced earlier in the page. Joshua D. Drake -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ United States PostgreSQL Association: http://www.postgresql.us/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate --MP_/twr2qsjkRDorMqaU0fO_m00 Content-Type: text/x-patch; name=backup.diff Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename=backup.diff Index: backup.sgml =================================================================== RCS file: /projects/cvsroot/pgsql/doc/src/sgml/backup.sgml,v retrieving revision 2.118 diff -c -r2.118 backup.sgml *** backup.sgml 9 Apr 2008 02:52:04 -0000 2.118 --- backup.sgml 16 Apr 2008 03:39:59 -0000 *************** *** 930,936 **** ! Restore the database files from your backup dump. Be careful that they are restored with the right ownership (the database system user, not root!) and with the right permissions. If you are using tablespaces, --- 930,936 ---- ! Restore the database files from your base backup. Be careful that they are restored with the right ownership (the database system user, not root!) and with the right permissions. If you are using tablespaces, --MP_/twr2qsjkRDorMqaU0fO_m00--