[ale] Postgreq backup help

[Robert Slaughter]

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> 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
> http://mail.ale.org/mailman/listinfo/ale
> See JOBS, ANNOUNCE and SCHOOLS lists at
> http://mail.ale.org/mailman/listinfo
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.ale.org/pipermail/ale/attachments/20150923/1a34ca53/attachment.html>