Re: Backup Database Question

I have a little bash script that is called by cron to make a backup of the
db, as well as being able to pull a copy of our production db to my local
machine for development.

It requires that you have a .pgpass file setup to connect to your database
without entering a password.

On Thu, Oct 6, 2011 at 11:26 AM, Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com>wrote:

> On Thu, Oct 6, 2011 at 11:19 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> > Use pg_dumpall. The extra time to dump the user and database
> > definitions is unlikely to be noticeable, and if push comes to shove
> > you'll be glad you had them.
>
> Yes I agree but I didn't know enough about PostgreSQL to make that
> determination. Seems very logical however. Does anyone know of a
> PostgreSQL backup script floating around the Internet for Linux
> systems? I found a great one for MySQL but sadly that doesn't do me
> any good.
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

--
Adam Cornett
adam(dot)cornett(at)gmail(dot)com
(678) 296-1150