Thread: Postgres dump using password on command line

Postgres dump using password on command line

From
Ankur Kaushik
Date:

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

Re: Postgres dump using password on command line

From
Thomas Kellerer
Date:
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
whenexecute 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