Обсуждение: Postgres dump using password on command line

Поиск
Список
Период
Сортировка

Postgres dump using password on command line

От
Ankur Kaushik
Дата:

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

От
Thomas Kellerer
Дата:
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