Re: Doubt in Backup - Mailing list pgsql-general

From tomas@tuxteam.de
Subject Re: Doubt in Backup
Date
Msg-id 20110321083349.GB31429@tomas
Whole thread Raw
In response to Doubt in Backup  (Adarsh Sharma <adarsh.sharma@orkash.com>)
List pgsql-general
-----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-----

pgsql-general by date:

Previous
From: tomas@tuxteam.de
Date:
Subject: Re: cannot connect to server
Next
From: Vibhor Kumar
Date:
Subject: Re: Doubt in Backup