[ale] Postgreq backup help

[James Sumners]

Or using a pgpass dotfile in the backup user's home directory. chmod
appropriately.

On Wednesday, September 23, 2015, Robert Slaughter <
robert.s.slaughter at gmail.com> wrote:

> You can avoid password prompting by setting the PGPASS environment
> variable to point to an appropriate file. Google for details I can't recall.
>
>
> ----
> Bob Slaughter
> http://www.facebook.com/robert.s.slaughter
> "The price good men pay for indifference to public affairs is to be ruled
> by evil men." -- Plato
> "All that is necessary for the triumph of evil is that good men do
> nothing." -- Edmund Burke
> "The world is a dangerous place, not because of those who do evil, but
> because of those who look on and do nothing." -- Albert Einstein
> "Nothing emboldens the wicked so greatly as the lack of courage on the
> part of the good." -- Pope Leo XIII, encyclical 'On Christians as Citizens'
>
> On Wed, Sep 23, 2015 at 5:17 PM, Beddingfield, Allen <allen at ua.edu
> <javascript:_e(%7B%7D,'cvml','allen at ua.edu');>> wrote:
>
>> So, after 20 years of being a Unix/Linux admin, I've finally got a
>> situation where I need to setup a Postgres server (aside from a few
>> provided-with-the-product cases).  Anyway, I've got it all up and running
>> with no issue, but I'm struggling with the best way to do a remote backup
>> of the whole server.
>> In MySQL/MariaDB, I do:
>>
>> "mysqldump --host=servername.domain -u username --password "plain text
>> pw" --all-databases > filename.sql"
>>
>> I need an equivalent for Postgres.  I've discovered that I can do
>> "pg_dump -h servername.domain -U username -W databasename", that I'm
>> prompted for the password, and it will dump out that database.
>>
>> I've been experimenting with pg_dumpall, but it dumps a portion, prompts
>> for the password, etc...
>>
>> Suggestions/options here?
>> I have a script I use for MariaDB that dumps out an -all-databases
>> backup, with a date-based naming convention, then handles a 30 day rotation
>> of the backups.  I just want to plug in some pg_dump pg_dumpall into there
>> and do the same.  I would prefer a full server backup that will capture
>> users, grants, etc... so that I can put the entire server back from one
>> backup.
>>
>> Thanks.
>> Allen B.
>>
>> --
>> Allen Beddingfield
>> Systems Engineer
>> The University of Alabama
>>
>> _______________________________________________
>> Ale mailing list
>> Ale at ale.org <javascript:_e(%7B%7D,'cvml','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/20150923/751d1219/attachment.html>