Backup very large databases

From: "Nikolay Mihaylov" <pg(at)nmmm(dot)nu>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Backup very large databases
Date: 2002-04-16 14:51:13
Message-ID: 000001c1e556$2854d180$97e309d9@protos
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)nmmm(dot)nu

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dmitry Tkach 2002-04-16 15:20:38 Large table update/vacuum PLEASE HELP!
Previous Message Gunther Schadow 2002-04-16 14:48:25 trouble with object names ...