Re: Doubt in Backup

-----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-----