Database restoration performance issue on PostgreSQL 7.4.7

Поиск
Список
Период
Сортировка
От Leon Pu
Тема Database restoration performance issue on PostgreSQL 7.4.7
Дата
Msg-id 20060404043039.41125.qmail@web15706.mail.cnb.yahoo.com
обсуждение исходный текст
Ответы Re: Database restoration performance issue on PostgreSQL 7.4.7  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi all,

the database restoration on my PosgreSQL 7.4.7 Linux installation is
terribly poor. It takes more than one and half hour to restore a 61M
restored database.

Here are my commands to backup and restore.

- backup: pg_dump -d $DB_NAME > db.bak
- restore: psql -d $DB_NAME < db.bak

Is the problem related to my backup and restore command, or it's the
problem of my system, or PostgreSQL installation?


Best regards,
Leon

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

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

Предыдущее
От: Chris
Дата:
Сообщение: Re: Log Slow Queries
Следующее
От: "deepak pal"
Дата:
Сообщение: what datatype is for autonumbering.in postgress