-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Mon, Mar 21, 2011 at 11:43:57AM +0530, Adarsh Sharma wrote: > 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. > > I think it picks the previous data and therefore, no need for restoring > backups of 2 databases that was taken before. *If* the versions of the old and new PostgreSQL don't differ very wildly this will most probably work, yes (well: you'd also run into problems with different processor architectuures). > 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. Hm. I don't understand: you re-used the data directory for the new installation and the new installation lost one database? > However I restore it from my previous backup. and after the restore it was there again? That's definitely strange. Regards - -- tomÃs -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD4DBQFNhw1tBcgs9XrR2kYRAl1UAJEBCs9NBQLsGJLy1Dxm2OElCYIEAJ4y7N4d GtEFnsrstDjASx+6OuY7Yw== =Kg5b -----END PGP SIGNATURE----- -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general