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 is
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 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
On Thu, May 13, 2010 at 8:16 PM, Scott Marlowe scott.marl...@gmail.comwrote:
On Thu, May 13, 2010 at 9:50 AM, Wang, Mary Y mary.y.w...@boeing.com
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
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
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
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
On Thu, May 13, 2010 at 11:50 AM, Wang, Mary Y mary.y.w...@boeing.com 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
On Thu, May 13, 2010 at 9:50 AM, Wang, Mary Y mary.y.w...@boeing.com 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: