Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Z4QDg-00021v-JT for pgsql-admin@arkaria.postgresql.org; Mon, 15 Jun 2015 08:58:16 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Z4QDf-0003ZD-Uw for pgsql-admin@arkaria.postgresql.org; Mon, 15 Jun 2015 08:58:16 +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 1Z4QDf-0003Z7-6S for pgsql-admin@postgresql.org; Mon, 15 Jun 2015 08:58:15 +0000 Received: from plane.gmane.org ([80.91.229.3]) by makus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1Z4QDc-00077L-J9 for pgsql-admin@postgresql.org; Mon, 15 Jun 2015 08:58:13 +0000 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1Z4QDX-0007io-GV for pgsql-admin@postgresql.org; Mon, 15 Jun 2015 10:58:07 +0200 Received: from 185.40.248.10 ([185.40.248.10]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 15 Jun 2015 10:58:07 +0200 Received: from spam_eater by 185.40.248.10 with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 15 Jun 2015 10:58:07 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-admin@postgresql.org From: Thomas Kellerer Subject: Re: Postgres dump using password on command line Date: Mon, 15 Jun 2015 10:58:01 +0200 Lines: 16 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: 185.40.248.10 User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.23) Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666 In-Reply-To: X-Pg-Spam-Score: -1.4 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Ankur Kaushik schrieb am 15.06.2015 um 10:54: > > I have made script for the postgresql dump but unable to get dump only using command line as it require the password when execute the script. > > list of database command require Password after enter > > psql -l -t | cut -d'|' -f1 | sed -e 's/ //g' -e '/^$/d' > > same for pg_dump > > pg_dump $i|gzip > $backupfile > See here: http://stackoverflow.com/a/6405296/330315 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin