Backup very large databases - Mailing list pgsql-general

From Nikolay Mihaylov
Subject Backup very large databases
Date
Msg-id 000001c1e556$2854d180$97e309d9@protos
Whole thread Raw
Responses Re: Backup very large databases
List pgsql-general
Hi all,

I have the following problem - when I;m backuping my database (4 GB+ is
single database) the website (is used from a web site) going too slow,
because of the backup.

Database is 7.0, pg_dump is from 7.2.1

Any ideas how I can make the process for backup to be with low priority,
or can I use second readonly!?!?!?! Postgres server on same machine?

Im also are interested to join/make? New group for very large postgres
databases. Is there other people that running simillar large databases?


-----------------------------------------------------------
The Reboots are for hardware upgrades,
Found more here: http://www.nmmm.nu
Nikolay Mihaylov nmmm@nmmm.nu


pgsql-general by date:

Previous
From: "Miia Leino"
Date:
Subject: ON DELETE CASCADE doesn't work
Next
From: tom dyson
Date:
Subject: Java as PG Procedural Language