recatalog existing databases after re-build from source

From: <gnuoytr(at)rcn(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: recatalog existing databases after re-build from source
Date: 2009-03-13 19:28:57
Message-ID: 20090313152857.CIO79406@ms15.lnh.mail.rcn.net
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Going through the PLPython threads on the Planet, I realized that I needed plpython. So I rebuilt PG with python, expecting that I could then re-catalog the databases. But, not. initdb, wants the data directory, which is where the database files are, and doesn't run if it's not empty. The data directories have descriptive names like 16431, etc.

These are only small test db's; losing them is not a big deal, but is there a way to get them back?

When I went to createlang I got the no "root" user message, which is why I went to look at initdb. adduser says that postgres user exists, which makes sense.

thanks,
Robert

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2009-03-13 19:49:30 Re: recatalog existing databases after re-build from source
Previous Message Bill Moran 2009-03-13 19:20:00 Re: Inserting string with a " into an array using {} syntax ... possible?