Search Postgresql Archives

Re: recatalog existing databases after re-build from source

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



----- "Joshua D. Drake" <jd@xxxxxxxxxxxxxxxxx> wrote:

> On Fri, 2009-03-13 at 15:28 -0400, gnuoytr@xxxxxxx wrote:
> > Going through the PLPython threads on the Planet, I realied 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.
> > 
> 
> I am having a hard time understanding your problem. Why do you have
> to
> recatalog the databases? Why not just createlang -u postgres?
> 
> Joshua D. Drake
> 
> 
> > thanks
> > Robert
> > 
> -- 

My guess is he thought he needed to re-initdb the cluster after rebuilding the source to generate plpythonu. Robert, you don't need to do that. As Josh said use createlang to add plpythonu to the database.


Adrian Klaver
aklaver@xxxxxxxxxxx

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux