Re: newbie psql - Backup/Restore - database

Поиск
Список
Период
Сортировка
От Hunter Matthews
Тема Re: newbie psql - Backup/Restore - database
Дата
Msg-id 1035486347.1253.28.camel@jade.biology.duke.edu
обсуждение исходный текст
Ответ на newbie psql - Backup/Restore - database  ("Nguyen, Dan" <danguyen@lsil.com>)
Список pgsql-admin
In my particular enviroment, fast backups were more important than 24
hour operation. I do the following.

1. rsync the raw database files to another directory.
   Note that this is DIRTY, the database is still operational. However,
   it gets about 95% of the data, WHILE the database is online.

2. Down the database

3. rsync again. Because  we got most of the data the first time, we're
   averaging about 10-15 seconds here.

4. start the database back up.

Total downtime per night over the last two weeks seems to be about 30
seconds. Which, for us, is nearly perfect.


On Mon, 2002-10-21 at 14:39, Nguyen, Dan wrote:
> Hello all,
>
> I just convert a MSQL database to PSQL and wondering if someone can help me
> to duplicate or restore a database in a short period.  Here is what I have
> done.
>
> Backup <users> database:
>    pg_dump -C -D -n -f backupDB.psql users
>
> Duplicate <users> database:
>    1. createdb test
>    2. edit the backupDB.psql file and remove the first block regarding users
> DATABASE
>    3. psql -a -e -f backupDB.psql test
>
>
> Doing this way will take about a hour to duplicate a database with about
> 50,000 records.  Is there any other ways that you can help me to speed up
> the process?
>
> All of your help will be greatly appreciated.
>
> Dan
--
Hunter Matthews                          Unix / Network Administrator
Office: BioScience 145/244               Duke Univ. Biology Department
Key: F0F88438 / FFB5 34C0 B350 99A4 BB02  9779 A5DB 8B09 F0F8 8438
Never take candy from strangers. Especially on the internet.


В списке pgsql-admin по дате отправления:

Предыдущее
От: Jeremy Buchmann
Дата:
Сообщение: Re: pg or DBI
Следующее
От: "Ross J. Reedstrom"
Дата:
Сообщение: Re: newbie qs; examining databases and tables