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 4C98B9DD642 for ; Thu, 1 Dec 2005 06:24:11 -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 18517-09 for ; Thu, 1 Dec 2005 06:24:04 -0400 (AST) X-Greylist: delayed 00:06:36.460582 by SQLgrey- Received: from web86405.mail.ukl.yahoo.com (web86405.mail.ukl.yahoo.com [217.12.12.117]) by postgresql.org (Postfix) with SMTP id 15BE69DD614 for ; Thu, 1 Dec 2005 06:24:04 -0400 (AST) Received: (qmail 28976 invoked by uid 60001); 1 Dec 2005 10:17:25 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=btinternet.com; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=0zE5qmubWDQN6IArOQ6W6Ztv1Br/PawBipRKCGSIwxLFWvrtVOzw5BK7CWXI23ESH2UTL6HGeaKzAbCQ7maU9/ChHVy2kR7eGnsOBbb+Pzq5Vi4ONDVmHC2lCO9OIhZ3JJ4Kk30CnC1Ucz4rL+v3gXHrq7710WGLWKkicrAEx9Q= ; Message-ID: <20051201101725.28974.qmail@web86405.mail.ukl.yahoo.com> Received: from [80.176.179.58] by web86405.mail.ukl.yahoo.com via HTTP; Thu, 01 Dec 2005 10:17:25 GMT Date: Thu, 1 Dec 2005 10:17:25 +0000 (GMT) From: Paul Breen Subject: Re: old database dump. To: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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/3 X-Sequence-Number: 19723 Alternatively you can login with your password as normal and then once in psql use the '\i filename' command to read in your backup. E.g., psql dbname Password: dbname=# \i database.bak dbname=# \q Regards - Paul Breen --- Jeff Frost wrote: > Use the .pgpass file. > > On Thu, 1 Dec 2005, Theo Galanakis wrote: > > > database.bak prompts me for a password. How can I > run the psql command > > without being prompted for a password. The > password prompt and < command > > -- > Jeff Frost, Owner > Frost Consulting, LLC > http://www.frostconsultingllc.com/ > Phone: 650-780-7908 FAX: 650-649-1954 > > ---------------------------(end of > broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster >