[ale] Postgreq backup help

[Beddingfield, Allen]

I did:
"alter user <username> with SUPERUSER;"


--
Allen Beddingfield
Systems Engineer
The University of Alabama
________________________________
From: ale-bounces at ale.org [ale-bounces at ale.org] on behalf of James Sumners [james.sumners at gmail.com]
Sent: Monday, September 28, 2015 10:24 AM
To: Atlanta Linux Enthusiasts
Subject: Re: [ale] Postgreq backup help


On Mon, Sep 28, 2015 at 11:00 AM, Beddingfield, Allen <allen at ua.edu<mailto:allen at ua.edu>> wrote:
Aha!  That got it.  I put a "*" in the database name field of the .pgpass file, and the pg_dumpall works as expected.

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?


--
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/e8cd1484/attachment.html>