[ale] Postgreq backup help

James Sumners james.sumners at gmail.com
Mon Sep 28 11:31:08 EDT 2015


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

On Mon, Sep 28, 2015 at 11:28 AM, Beddingfield, Allen <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 [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>
> 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
> 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/f95cc315/attachment.html>


More information about the Ale mailing list