Re: Backup Database Question - Mailing list pgsql-general

From Carlos Mennens
Subject Re: Backup Database Question
Date
Msg-id CAAQLLO6_BTrD_kJE4v0R+oXXxUjLV_FogZnugPHDZ3Ey1_Zztw@mail.gmail.com
Whole thread Raw
In response to Re: Backup Database Question  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Backup Database Question  (Adam Cornett <adam.cornett@gmail.com>)
Re: Backup Database Question  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
On Thu, Oct 6, 2011 at 11:19 AM, Tom Lane <tgl@sss.pgh.pa.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.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Backup Database Question
Next
From: Andrew Sullivan
Date:
Subject: Re: Never-idle autovacuum, and does (auto)vacuuming fill the OS cache ?