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 supportCraig <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 -------