1. Forum
  2. Usenet
  3. COMP.DATABASES.POSTGRESQL

  • backup using pg_dump

    From Magnus Warker@21:1/5 to All on Wed Apr 13 06:12:05 2016
    Hello,

    when backing up a database with pg_dump:
    How can I pass the password for the database on the commandline?

    Thanks
    Magnus

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Magnus Warker@21:1/5 to Peter H. Coffin on Sat Apr 16 04:42:37 2016
    On 04/15/2016 08:24 PM, Peter H. Coffin wrote:
    On Wed, 13 Apr 2016 06:12:05 +0200, Magnus Warker wrote:

    when backing up a database with pg_dump:
    How can I pass the password for the database on the commandline?

    Can't. Set up a strictly permisssioned password file or use an
    environmental variable (which is probably safest read from a strictly permissioned file).

    Thanks,

    I use the .pgpass solution (what you said) now...

    Magnus

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Peter H. Coffin@21:1/5 to Magnus Warker on Fri Apr 15 13:24:31 2016
    On Wed, 13 Apr 2016 06:12:05 +0200, Magnus Warker wrote:
    Hello,

    when backing up a database with pg_dump:
    How can I pass the password for the database on the commandline?

    Can't. Set up a strictly permisssioned password file or use an
    environmental variable (which is probably safest read from a strictly permissioned file).

    --
    29. I will dress in bright and cheery colors, and so throw my enemies
    into confusion.
    --Peter Anspach's list of things to do as an Evil Overlord

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)