[ale] Postgreq backup help

[Beddingfield, Allen]

I think that was the example I got from either the man pages or the Postgres documentation on their website.

--
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:31 AM
To: Atlanta Linux Enthusiasts
Subject: Re: [ale] Postgreq backup help

Not exactly optimal, but it'll do. Thanks.

On Mon, Sep 28, 2015 at 11:28 AM, Beddingfield, Allen <allen at ua.edu<mailto:allen at ua.edu>> wrote:
I did:
"alter user <username> with SUPERUSER;"


--
Allen Beddingfield
Systems Engineer
The University of Alabama
________________________________
From: ale-bounces at ale.org<mailto:ale-bounces at ale.org> [ale-bounces at ale.org<mailto:ale-bounces at ale.org>] on behalf of James Sumners [james.sumners at gmail.com<mailto: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)

_______________________________________________
Ale mailing list
Ale at ale.org<mailto:Ale at ale.org>
http://mail.ale.org/mailman/listinfo/ale
See JOBS, ANNOUNCE and SCHOOLS lists at
http://mail.ale.org/mailman/listinfo




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