| From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
|---|---|
| To: | "mcelroy, tim" <tim(dot)mcelroy(at)bostonstock(dot)com> |
| Cc: | 'Bruno Wolff III' <bruno(at)wolff(dot)to>, "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: backups |
| Date: | 2006-05-10 19:35:14 |
| Message-ID: | 1147289714.9755.44.camel@state.g2switchworks.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Wed, 2006-05-10 at 14:11, mcelroy, tim wrote:
> Excellent point Bruno, thanks. I must admit that I did think of that
> and have already copied all my .conf files to the backup directory. I
> should have noted that earlier.
>
> Thanks,
> Tim
Another thing to check is that your global data (i.e. user accounts) are
being backed up. pg_dumpall does this, but individual pg_dumps do not.
In our prod environment we run a backup of those accounts with
'pg_dumpall -g' every night as well.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | mcelroy, tim | 2006-05-10 19:43:19 | Re: backups |
| Previous Message | Chris Browne | 2006-05-10 19:28:02 | Re: Logging long queries: not all get logged |