On 6/6/2012 2:35 AM, Daniel Verite wrote:
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.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,
Andy -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
