<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style id="owaParaStyle" type="text/css">P {margin-top:0;margin-bottom:0;}</style>
</head>
<body ocsi="0" fpstyle="1">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;">Aha! That got it. I put a "*" in the database name field of the .pgpass file, and the pg_dumpall works as expected.<br>
<br>
Thanks!<br>
Allen B.<br>
<div><br>
<div style="font-family:Tahoma; font-size:13px">--<br>
Allen Beddingfield<br>
Systems Engineer<br>
The University of Alabama<br>
</div>
</div>
<div style="font-family: Times New Roman; color: #000000; font-size: 16px">
<hr tabindex="-1">
<div style="direction: ltr;" id="divRpF354602"><font face="Tahoma" color="#000000" size="2"><b>From:</b> ale-bounces@ale.org [ale-bounces@ale.org] on behalf of James Sumners [james.sumners@gmail.com]<br>
<b>Sent:</b> Monday, September 28, 2015 9:46 AM<br>
<b>To:</b> Atlanta Linux Enthusiasts<br>
<b>Subject:</b> Re: [ale] Postgreq backup help<br>
</font><br>
</div>
<div></div>
<div>
<div dir="ltr">
<div class="gmail_extra"><br>
<div class="gmail_quote">On Mon, Sep 28, 2015 at 10:35 AM, Beddingfield, Allen <span dir="ltr">
<<a href="mailto:allen@ua.edu" target="_blank">allen@ua.edu</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex; border-left:1px #ccc solid; padding-left:1ex">
<div style="direction:ltr; font-family:Tahoma; color:#000000; font-size:10pt">Okay, so I've gotten the .pgpass to work without any issue.<br>
The file is in ~/.pgpass, with permissions of 600<br>
<br>
The file looks like:<br>
<hostname>.<a href="http://ua.edu:5432" target="_blank">ua.edu:5432</a>:<dbname>:<user>:<password><br>
<br>
I can do:<br>
pg_dump -h <hostname>.<a href="http://ua.edu" target="_blank">ua.edu</a> -d <dbname> -U <user> -w<br>
<div><br>
This works, dumping out that database, without prompting for a password.<br>
<br>
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.<br>
<br>
When I try:<br>
pg_dumpall -h <hostname>.<a href="http://ua.edu" target="_blank">ua.edu</a> -U <user> -w<br>
<br>
I get:<br>
pg_dumpall: could not connect to database "template1": fe_sendauth: no password supplied<br>
<br>
Any ideas?</div>
</div>
</blockquote>
</div>
<br>
Wildcards work in pretty much any field. So put a '*' in the database field.<br>
<br clear="all">
<div><br>
</div>
-- <br>
<div class="gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div>James Sumners<br>
<a href="http://james.sumners.info/" target="_blank">http://james.sumners.info/</a> (technical profile)</div>
<div><a href="http://jrfom.com/" target="_blank">http://jrfom.com/</a> (personal site)</div>
<div><a href="http://haplo.bandcamp.com/" target="_blank">http://haplo.bandcamp.com/</a> (band page)</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>