Thread: Adding pl/perl support
Hi
I am quite new to PostgreSQL on freebsd (or anything other than windows). I installed PostgreSQL without perl support, but I would now like to add it. I have found posts about running ./configure --with-perl. I have done that, but now I am not sure of the correct way to add this support to the running version of postgres. This is a production server and I cannot really afford any down time.
I installed PostgreSQL 8.1.0 from source.
Any help will be much appreciated
Thanks
Craig
Craig <postgresql@bryden.co.za> schrieb: > I installed PostgreSQL 8.1.0 from source. > > Any help will be much appreciated Try: createlang plperl <your_db> HTH, Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknow) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
Hi Andreas
I explained the situation badly. I had "originally" installed from source
WITHOUT perl support. I would now like to add it, please can you explain how
I would do that without completely re-installing PostgreSQL?
I had already tried the creatlang command
Thanks
Craig
----- Original Message -----
From: "Andreas Kretschmer" <akretschmer@spamfence.net>
To: <pgsql-general@postgresql.org>
Sent: Saturday, February 11, 2006 1:49 PM
Subject: Re: [GENERAL] Adding pl/perl support
Craig <postgresql@bryden.co.za> schrieb:
> I installed PostgreSQL 8.1.0 from source.
>
> Any help will be much appreciated
Try: createlang plperl <your_db>
HTH, Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknow)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
just go to the "src/pl/plperl" directory and do a make && make install, then the createlang command ---------- Original Message ----------- From: "Craig" <postgresql@bryden.co.za> To: "Andreas Kretschmer" <akretschmer@spamfence.net>, <pgsql-general@postgresql.org> Sent: Sat, 11 Feb 2006 14:45:51 +0200 Subject: Re: [GENERAL] Adding pl/perl support > Hi Andreas > > I explained the situation badly. I had "originally" installed from source > WITHOUT perl support. I would now like to add it, please can you explain how > I would do that without completely re-installing PostgreSQL? > > I had already tried the creatlang command > > Thanks > Craig > > ----- Original Message ----- > From: "Andreas Kretschmer" <akretschmer@spamfence.net> > To: <pgsql-general@postgresql.org> > Sent: Saturday, February 11, 2006 1:49 PM > Subject: Re: [GENERAL] Adding pl/perl support > > Craig <postgresql@bryden.co.za> schrieb: > > I installed PostgreSQL 8.1.0 from source. > > > > Any help will be much appreciated > > Try: createlang plperl <your_db> > > HTH, Andreas > -- > Really, I'm not out to destroy Microsoft. That will just be a completely > unintentional side effect. (Linus Torvalds) > "If I was god, I would recompile penguin with --enable-fly." (unknow) > Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889° > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings ------- End of Original Message -------