8.0.1 in a non-standard location and tsearch2

Ben <bench@silentmedia.com> writes:

make installcheck tries to connect to the older postgres install (I
don't see an option to set the port it attempts to use),

Set PGPORT, eg
export PGPORT=7777

regards, tom lane

Nifty.

On Mar 24, 2005, at 7:34 PM, Tom Lane wrote:

Did you try 'make clean' first ?

On Thu, 24 Mar 2005, Ben wrote:

I'm trying to install tsearch2 into an empty database on a new 8.0.1 postgres
install. The machine already has an older 7.4 install of postgres on it, so I
gave configure a --prefix=/usr/local/pg801 option. Postgres installed and
started fine (after changing the port), and I was able to create my new empty
database without issues.

Now comes the part where I fail to install tsearch2. I go to the
contrib/tsearch2 directory, run make and make install without issues. make
installcheck tries to connect to the older postgres install (I don't see an
option to set the port it attempts to use), so I try to pipe tsearch2.sql
into the new database. It starts working fine, and then says:

ERROR: could not find function "tsvector_cmp" in file
"/usr/local/pgsql/lib/tsearch2.so"

.... which is interesting, because it's not trying to use /usr/local/pg801/
like it's supposed to.

Thoughts?

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

I tried it in the tsearch2 directory, not the postgres src directory.

On Mar 24, 2005, at 9:35 PM, Oleg Bartunov wrote:

Yes, I did.

On Fri, 25 Mar 2005, Oleg Bartunov wrote:

Did you resolve your problem ?

On Tue, 29 Mar 2005, Ben wrote:

Yes, I did.

On Fri, 25 Mar 2005, Oleg Bartunov wrote:

Did you try 'make clean' first ?

On Thu, 24 Mar 2005, Ben wrote:

I'm trying to install tsearch2 into an empty database on a new 8.0.1 postgres
install. The machine already has an older 7.4 install of postgres on it, so I
gave configure a --prefix=/usr/local/pg801 option. Postgres installed and
started fine (after changing the port), and I was able to create my new empty
database without issues.

Now comes the part where I fail to install tsearch2. I go to the
contrib/tsearch2 directory, run make and make install without issues. make
installcheck tries to connect to the older postgres install (I don't see an
option to set the port it attempts to use), so I try to pipe tsearch2.sql
into the new database. It starts working fine, and then says:

ERROR: could not find function "tsvector_cmp" in file
"/usr/local/pgsql/lib/tsearch2.so"

.... which is interesting, because it's not trying to use /usr/local/pg801/
like it's supposed to.

Thoughts?

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

Yes.... by reinstalling to the default location. :)

When I get a chance I'll try this again, but I've been too swamped to give
it a go.

On Tue, 29 Mar 2005, Oleg Bartunov wrote:

On Tue, 29 Mar 2005, Ben wrote:

Yes.... by reinstalling to the default location. :)

When I get a chance I'll try this again, but I've been too swamped to give
it a go.

I just tried myself to install pgsql into non-standard location and
got no problem.

On Tue, 29 Mar 2005, Oleg Bartunov wrote:

Did you resolve your problem ?

On Tue, 29 Mar 2005, Ben wrote:

Yes, I did.

On Fri, 25 Mar 2005, Oleg Bartunov wrote:

Did you try 'make clean' first ?

On Thu, 24 Mar 2005, Ben wrote:

I'm trying to install tsearch2 into an empty database on a new 8.0.1 postgres
install. The machine already has an older 7.4 install of postgres on it, so I
gave configure a --prefix=/usr/local/pg801 option. Postgres installed and
started fine (after changing the port), and I was able to create my new empty
database without issues.

Now comes the part where I fail to install tsearch2. I go to the
contrib/tsearch2 directory, run make and make install without issues. make
installcheck tries to connect to the older postgres install (I don't see an
option to set the port it attempts to use), so I try to pipe tsearch2.sql
into the new database. It starts working fine, and then says:

ERROR: could not find function "tsvector_cmp" in file
"/usr/local/pgsql/lib/tsearch2.so"

.... which is interesting, because it's not trying to use /usr/local/pg801/
like it's supposed to.

Thoughts?

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83