Skip site navigation (1) Skip section navigation (2)

Re: problem after upgrade db missing

From: Aleksander Rozman <andy(dot)rozman(at)gmail(dot)com>
To: Daniel Verite <daniel(at)manitou-mail(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: problem after upgrade db missing
Date: 2012-06-10 12:15:12
Message-ID: 4FD48FD0.2070004@gmail.com (view raw or flat)
Thread:
Lists: pgsql-fr-generalepgsql-general
On 6/6/2012 2:35 AM, Daniel Verite wrote:
> 	Aleksander Rozman wrote:
>
>> Now I am not sure two of this directories are old databases, but I think
>> they are... Is there a way to register one of this databases into new
>> installation (I am sure that directory "1" is old postgres database, and
>> "11563" is my database I want to save, and "11564" is new postgresql
>> database (this is only directory with new date).
> Actually 1, 11563 and 11564 are what you get with a fresh new installation.
> On a 8.4 install on Ubuntu, the corresponding databases are:
>
> SELECT oid, datname from pg_database where oid in (1,11563,11564);
>
>    oid  |  datname
> -------+-----------
>       1 | template1
>   11563 | template0
>   11564 | postgres
>
> Also normally initdb wouldn't work on a non-empty data directory, anyway.
> I'd say that either the old data directory has been moved aside at some point
> of the upgrade procedure, or it has been wiped out :(
>
> Best regards,
Problem is that upgrade of Ubuntu failed at some point, and after that I 
did clean install... So database probably got deleted at some point.

Andy

In response to

pgsql-fr-generale by date

Next:From: Guillaume LelargeDate: 2012-06-10 21:31:55
Subject: Traduction de la documentation de PostgreSQL 9.2
Previous:From: Florence CousinDate: 2012-06-08 06:50:07
Subject: Re: PGFR à Solutions Linux 2012

pgsql-general by date

Next:From: Chris TraversDate: 2012-06-11 00:47:49
Subject: Re: Run external SQL file via Perl dbh
Previous:From: Jasen BettsDate: 2012-06-10 11:48:05
Subject: Re: Procedural Languages

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group