pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres dump using password on command line
2+ messages / 2 participants
[nested] [flat]
* Postgres dump using password on command line
@ 2015-06-15 08:54 Ankur Kaushik <ankurkaushik@gmail.com>
2015-06-15 08:58 ` Re: Postgres dump using password on command line Thomas Kellerer <spam_eater@gmx.net>
0 siblings, 1 reply; 2+ messages in thread
From: Ankur Kaushik @ 2015-06-15 08:54 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Postgres dump using password on command line
2015-06-15 08:54 Postgres dump using password on command line Ankur Kaushik <ankurkaushik@gmail.com>
@ 2015-06-15 08:58 ` Thomas Kellerer <spam_eater@gmx.net>
0 siblings, 0 replies; 2+ messages in thread
From: Thomas Kellerer @ 2015-06-15 08:58 UTC (permalink / raw)
To: 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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2015-06-15 08:58 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-06-15 08:54 Postgres dump using password on command line Ankur Kaushik <ankurkaushik@gmail.com>
2015-06-15 08:58 ` Thomas Kellerer <spam_eater@gmx.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox