Re: Backup very large databases - Mailing list pgsql-general

From Francisco Reyes
Subject Re: Backup very large databases
Date
Msg-id 20020419114516.S76398-100000@zoraida.natserv.net
Whole thread Raw
In response to Backup very large databases  ("Nikolay Mihaylov" <pg@nmmm.nu>)
Responses Re: Backup very large databases  (Curt Sampson <cjs@cynic.net>)
List pgsql-general
On Tue, 16 Apr 2002, Nikolay Mihaylov wrote:

> 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

For starters why haven't you moved the DB to 7.2?

> 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?
Not really sure if you could make it low priority "automagically", but you
could use ps to find the PID for the process and then manually do a nice
on it.


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

Don't know how many other people would be interested, but I like the idea.
However, what is wrong with just posting the questions to general?

I have about 7GB worth of data.


pgsql-general by date:

Previous
From: Darren Ferguson
Date:
Subject: Re: pltcl bug in 7.2?
Next
From: Francisco Reyes
Date:
Subject: Troubleshooting cored dumps