X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 2EA519DD67B for ; Thu, 1 Dec 2005 11:40:04 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 39040-07 for ; Thu, 1 Dec 2005 11:39:58 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 8912D9DD673 for ; Thu, 1 Dec 2005 11:40:00 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id jB1Fe5ct011078 for ; Thu, 1 Dec 2005 10:40:05 -0500 (EST) To: pgsql-admin@postgresql.org Subject: Re: old database dump. In-reply-to: <20051201101725.28974.qmail@web86405.mail.ukl.yahoo.com> References: <20051201101725.28974.qmail@web86405.mail.ukl.yahoo.com> Comments: In-reply-to Paul Breen message dated "Thu, 01 Dec 2005 10:17:25 +0000" Date: Thu, 01 Dec 2005 10:40:05 -0500 Message-ID: <11077.1133451605@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200512/7 X-Sequence-Number: 19727 Paul Breen writes: > Alternatively you can login with your password as > normal and then once in psql use the '\i filename' > command to read in your backup. Or use "psql -f file" instead of "psql < file". regards, tom lane