[ale] Postgreq backup help

James Sumners james.sumners at gmail.com
Mon Sep 28 10:46:14 EDT 2015


On Mon, Sep 28, 2015 at 10:35 AM, Beddingfield, Allen <allen at ua.edu> wrote:

> Okay, so I've gotten the .pgpass to work without any issue.
> The file is in ~/.pgpass, with permissions of 600
>
> The file looks like:
> <hostname>.ua.edu:5432:<dbname>:<user>:<password>
>
> I can do:
> pg_dump -h <hostname>.ua.edu -d <dbname> -U <user> -w
>
> This works, dumping out that database, without prompting for a password.
>
> I want to be able to do pg_dumpall (I want a one file backup to re-add
> users, databases, grants, etc...) - similar to a MySQL --all-databases
> backup.
>
> When I try:
> pg_dumpall -h <hostname>.ua.edu -U <user> -w
>
> I get:
> pg_dumpall: could not connect to database "template1": fe_sendauth: no
> password supplied
>
> Any ideas?
>

Wildcards work in pretty much any field. So put a '*' in the database field.


-- 
James Sumners
http://james.sumners.info/ (technical profile)
http://jrfom.com/ (personal site)
http://haplo.bandcamp.com/ (band page)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.ale.org/pipermail/ale/attachments/20150928/86c23da5/attachment.html>


More information about the Ale mailing list