Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 5A8AD1337BBC
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed,  9 Mar 2011 11:28:05 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 51249-06; Wed,  9 Mar 2011 15:27:56 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-fx0-f46.google.com (mail-fx0-f46.google.com
	[209.85.161.46])
	by mail.postgresql.org (Postfix) with ESMTP id 1CEF51337B93;
	Wed,  9 Mar 2011 11:27:53 -0400 (AST)
Received: by fxm17 with SMTP id 17so581727fxm.19
	for <multiple recipients>; Wed, 09 Mar 2011 07:27:53 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:from:reply-to:to:subject:date:user-agent:cc
	:references:in-reply-to:mime-version:content-type
	:content-transfer-encoding:message-id;
	bh=fuPxjkXsnmNR1/3TZNf/0c7c/IHJDTDONpbKH8RgxQU=;
	b=jECx+NUJ/9Rx07HzOPPKHtx5XJTdLfyMx5PTzANfYf8TC68kuu82XrH3sr5Sf2eFQM
	1347Jt7SyW6CZEHtZtv22y0M4HA2vthsCKXV8IbyRx/9IA7xlsiTRShvLT4PpjWMYtSg
	JYKB5boWAVQnTR7r36RF/nby42GALJTi8I8tg=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=from:reply-to:to:subject:date:user-agent:cc:references:in-reply-to
	:mime-version:content-type:content-transfer-encoding:message-id;
	b=aY7EK6jsytAOvQx6qqj/0CGdpjDTIy+OJ88KItuiqLZOGlyhmHxv57C6EuYp6LDWLk
	ATq6/5CY0otMwSlL0RDP0uNpn4mP1MBPBDIwpL5/BHRulIHrZUiQnDsJKFrMXVdxK9d4
	N66DzVYUpbilTBktKJ9kTnr9/tjAW4Sed0H20=
Received: by 10.223.102.129 with SMTP id g1mr273829fao.3.1299684473657;
	Wed, 09 Mar 2011 07:27:53 -0800 (PST)
Received: from tucker.localnet (c-24-17-164-54.hsd1.wa.comcast.net
	[24.17.164.54])
	by mx.google.com with ESMTPS id s2sm929262fai.45.2011.03.09.07.27.51
	(version=SSLv3 cipher=OTHER); Wed, 09 Mar 2011 07:27:52 -0800 (PST)
From: Adrian Klaver <adrian.klaver@gmail.com>
Reply-To: adrian.klaver@gmail.com
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] FW: backup using pg_dump  postgreSQL 8.3.8
Date: Wed, 9 Mar 2011 07:27:48 -0800
User-Agent: KMail/1.13.5 (Linux/2.6.32-29-generic; KDE/4.4.5; i686; ; )
Cc: "Sandy Test" <sandy@mcw.co.il>,
 pgsql-admin@postgresql.org
References: 
 <10E646CF2170984794256AC2DD2C065C6BA882@Mcw-BS-Mail.mpdc.mcw.co.il>
In-Reply-To: 
 <10E646CF2170984794256AC2DD2C065C6BA882@Mcw-BS-Mail.mpdc.mcw.co.il>
MIME-Version: 1.0
Content-Type: Text/Plain;
  charset="iso-8859-15"
Content-Transfer-Encoding: 7bit
Message-Id: <201103090727.48971.adrian.klaver@gmail.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.889 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, T_TO_NO_BRKTS_FREEMAIL=0.01
X-Spam-Level: 
X-Archive-Number: 201103/100
X-Sequence-Number: 36972

On Wednesday, March 09, 2011 5:58:20 am Sandy Test wrote:
>
> 
> 
> 
> 2. Is there a way of running a dos script that would run the pg_dump
> providing a password when prompted?

Using .pgpass
http://www.postgresql.org/docs/9.0/static/libpq-pgpass.html



> 
> 
> 
> Thanks
> 
> 
> 
> Sandy Test
>
-- 
Adrian Klaver
adrian.klaver@gmail.com