Re: Postgres dump using password on command line

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Postgres dump using password on command line
Date: 2015-06-15 08:58:01
Message-ID: mlm42p$ir7$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ankur Kaushik 2015-06-15 09:42:41 ERROR: duplicate key value violates unique constraint "geocode_settings_pkey"
Previous Message Ankur Kaushik 2015-06-15 08:54:31 Postgres dump using password on command line