Postgres Pro
Downloads
Home   >   mailing lists

Re: Doubt in Backup - Mailing list pgsql-general

From Brian Hirt
Subject Re: Doubt in Backup
Date
Msg-id 226B24DC-FA0C-49BB-AECD-DEAEA038A1C8@me.com
Whole thread Raw
In response to Doubt in Backup  (Adarsh Sharma <adarsh.sharma@orkash.com>)
List pgsql-general
Tree view

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 by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: query taking much longer since Postgres 8.4 upgrade
Next
From: tv@fuzzy.cz
Date:
Subject: Re: query taking much longer since Postgres 8.4 upgrade