On 06/05/2012 02:51 PM, Aleksander Rozman wrote:
Hi ! I am long time user of postgresql (on several platforms), and last month I came across weird problem... I started upgrade of Ubuntu and halfway through, upgrade failed... I was forced to do clean install. After install all my databases were missing (I also had to reinstall postgres, so I installed same version of pgsql I had before - 8.4). Like I said before all databases were missing... One of thoose database was very important, but since I didn't have time I didn't pursue it further. Now that I can breathe again, I am here again... I looked through data directory and I found in /var/lib/postgresql/8.4/main/base I found 3 directories which leads me to beleive, that old databases were not in fact deleted, they are just not "registered". Two of this directories have old date (like date when my computer run on previous version of OS) and one has new date. 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). Any help is appreciated? I would really need data from that database...
Can you start the 8.4 instance you installed? If so, what do you see when you do \l in psql?
Thanks for all help in advance. Andy
-- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Programming PHP] [Kernel Newbies] [PHP Classes] [Find Someone Nice] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]