pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Postgres 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>
  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:58  Thomas Kellerer <spam_eater@gmx.net>
  parent: Ankur Kaushik <ankurkaushik@gmail.com>
  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