On 16/05/2010 16:59, Adrian von Bidder wrote:
> * pint in time recovery
This is what happens *after* work - this side of the pond, anyway :-)
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
On Thursday 13 May 2010 17.50:31 Wang, Mary Y wrote:
> http://www.postgresql.org/docs/8.3/static/backup-dump.html#BACKUP-DUMP-A
> LL (I only found the documentation for 8.3.10), and it looks like
> pg_dumpall > outfile is the best choice.
pg_dumpall or by-database pg_dump ha the advantage that it
On Thu, May 13, 2010 at 8:16 PM, Scott Marlowe wrote:
> On Thu, May 13, 2010 at 9:50 AM, Wang, Mary Y
> wrote:
> > Hi,
> >
> > I'm running on Postgres 8.3.8. My system admin is ready to set up a cron
> job for a daily database backup.
> > By reading the documentation over here:
> http://www.post
On Thu, 2010-05-13 at 09:15 -0700, Wang, Mary Y wrote:
> By reading the documentation over here:
> http://www.postgresql.org/docs/8.3/static/backup-dump.html#BACKUP-DUMP-ALL (I
> only found the documentation for 8.3.10),
If you replace 8.3 with current, you will get the current docs.
> and it l
On Thu, May 13, 2010 at 9:50 AM, Wang, Mary Y wrote:
> Hi,
>
> I'm running on Postgres 8.3.8. My system admin is ready to set up a cron job
> for a daily database backup.
> By reading the documentation over here:
> http://www.postgresql.org/docs/8.3/static/backup-dump.html#BACKUP-DUMP-ALL (I
>
On Thu, May 13, 2010 at 11:50 AM, Wang, Mary Y wrote:
> it looks like pg_dumpall > outfile is the best choice. I'd like to ask the
> community to reconfirm.
We do an individual pg_dump on each DB separately, using the '-Fc'
format. The only thing we miss from pg_dumpall we get via "pg_dumpall
On Thu, 2010-05-13 at 09:15 -0700, Wang, Mary Y wrote:
> Hi,
>
> I'm running on Postgres 8.3.8. My system admin is ready to set up a cron job
> for a daily database backup.
> By reading the documentation over here:
> http://www.postgresql.org/docs/8.3/static/backup-dump.html#BACKUP-DUMP-ALL (I
Hi,
I'm running on Postgres 8.3.8. My system admin is ready to set up a cron job
for a daily database backup.
By reading the documentation over here:
http://www.postgresql.org/docs/8.3/static/backup-dump.html#BACKUP-DUMP-ALL (I
only found the documentation for 8.3.10), and it looks like pg_dum
Hi,
I'm running on Postgres 8.3.8. My system admin is ready to set up a cron job
for a daily database backup.
By reading the documentation over here:
http://www.postgresql.org/docs/8.3/static/backup-dump.html#BACKUP-DUMP-ALL (I
only found the documentation for 8.3.10), and it looks like pg_dum