<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;">I think that was the example I got from either the man pages or the Postgres documentation on their website.<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="divRpF158305"><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 10:31 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">Not exactly optimal, but it'll do. Thanks.</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Mon, Sep 28, 2015 at 11:28 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>
<div style="direction:ltr; font-family:Tahoma; color:#000000; font-size:10pt">I did:<br>
"alter user <username> with SUPERUSER;"<span class=""><br>
<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>
</span>
<div style="font-family:Times New Roman; color:#000000; font-size:16px">
<hr>
<div style="direction:ltr"><font face="Tahoma" color="#000000" size="2"><span class=""><b>From:</b>
<a href="mailto:ale-bounces@ale.org" target="_blank">ale-bounces@ale.org</a> [<a href="mailto:ale-bounces@ale.org" target="_blank">ale-bounces@ale.org</a>] on behalf of James Sumners [<a href="mailto:james.sumners@gmail.com" target="_blank">james.sumners@gmail.com</a>]<br>
</span><b>Sent:</b> Monday, September 28, 2015 10:24 AM<span class=""><br>
<b>To:</b> Atlanta Linux Enthusiasts<br>
<b>Subject:</b> Re: [ale] Postgreq backup help<br>
</span></font><br>
</div>
<div>
<div class="h5">
<div></div>
<div>
<div dir="ltr">
<div class="gmail_extra"><br>
<div class="gmail_quote">On Mon, Sep 28, 2015 at 11:00 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">
Aha! That got it. I put a "*" in the database name field of the .pgpass file, and the pg_dumpall works as expected.</blockquote>
</div>
<br>
Looking at my backup routine it looks like I've got an issue with my backup user. Would you mind providing me with the statement you used to grant permissions to your backup user?<br>
<br clear="all">
<div><br>
</div>
-- <br>
<div>
<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>
</div>
</div>
</div>
<br>
_______________________________________________<br>
Ale mailing list<br>
<a href="mailto:Ale@ale.org" target="_blank">Ale@ale.org</a><br>
<a href="http://mail.ale.org/mailman/listinfo/ale" rel="noreferrer" target="_blank">http://mail.ale.org/mailman/listinfo/ale</a><br>
See JOBS, ANNOUNCE and SCHOOLS lists at<br>
<a href="http://mail.ale.org/mailman/listinfo" rel="noreferrer" target="_blank">http://mail.ale.org/mailman/listinfo</a><br>
<br>
</blockquote>
</div>
<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>
</body>
</html>