Re: Doubt in Backup

Поиск
Список
Период
Сортировка
От Brian Hirt
Тема Re: Doubt in Backup
Дата
Msg-id 226B24DC-FA0C-49BB-AECD-DEAEA038A1C8@me.com
обсуждение исходный текст
Ответ на Doubt in Backup  (Adarsh Sharma <adarsh.sharma@orkash.com>)
Список pgsql-general
Дерево обсуждения

Dear all,

2 days ago, I need to backup 2 databases in my Database server because I need to format the system and reinstalls again with the back up databases.

After a fresh install of ubuntu-10.4 , I install postgreplus-8.4 binary and I think giving the previous data directory /hdd2-1/postgres_data during installation for my own testing.


You really shouldn't backup the filesystem to backup your database.  There are many situations where it will not work and you will shoot yourself in the foot.   You should really use pg_dump or pg_dumpall.   See http://www.postgresql.org/docs/9.0/static/backup.html and http://www.postgresql.org/docs/9.0/static/backup-file.html for more information.  

I think it picks the previous data and therefore,  no need for restoring backups of 2 databases that was taken before.

But what I have noticed that there is 6 databases in my Postgres database and one database pdc_uima doesn't have any entry in \l command.

However I restore it from my previous backup.

Does Someone has any comments and suggestion on it. What is the reason of this strange problem.


Thanks & best Regards,
Adarsh Sharma

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

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: query taking much longer since Postgres 8.4 upgrade
Следующее
От: tv@fuzzy.cz
Дата:
Сообщение: Re: query taking much longer since Postgres 8.4 upgrade