pg web hosting with tsearch2?

Started by Rick Schumeyerover 19 years ago8 messagesgeneral
Jump to latest
#1Rick Schumeyer
rschumeyer@ieee.org

I hope pg-general is the correct forum for this question.if not please let
me know the correct location.

I have a pg application that uses tsearch2. I would like to move this
application off my local machine and onto a web host somewhere. I have some
questions regarding this:

1) What is the preferred postgresql text searching tool these days?
Is it still tsearch2?

2) Can someone suggest a web host service that includes tsearch2 (or
an equivalent text searching component)?

3) All the web hosts I am aware of are still offering only pg 7.4.
Does anybody offer pg 8.x ?

#2Joshua D. Drake
jd@commandprompt.com
In reply to: Rick Schumeyer (#1)
Re: pg web hosting with tsearch2?

Rick Schumeyer wrote:

I hope pg-general is the correct forum for this question.if not please let
me know the correct location.

I have a pg application that uses tsearch2. I would like to move this
application off my local machine and onto a web host somewhere. I have some
questions regarding this:

1) What is the preferred postgresql text searching tool these days?
Is it still tsearch2?

Yes and pg_trgm (similar but different)

2) Can someone suggest a web host service that includes tsearch2 (or
an equivalent text searching component)?

www.commandprompt.com

3) All the web hosts I am aware of are still offering only pg 7.4.
Does anybody offer pg 8.x ?

8.0.x and 8.1.x only.

Joshua D. Drake

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

#3Rick Schumeyer
rschumeyer@ieee.org
In reply to: Joshua D. Drake (#2)
Re: pg web hosting with tsearch2?

I guess I should have mentioned this initially...I also need a web host that
offers that other database (my***). We are using the Joomla content
management system which only works with my***. Although, I'm not as picky
about which version of my*** is offered.

I'm examining that commandprompt...my initial guess is they do not support
my*** ?

-----Original Message-----
From: Joshua D. Drake [mailto:jd@commandprompt.com]
Sent: Friday, September 29, 2006 5:05 PM
To: Rick Schumeyer
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] pg web hosting with tsearch2?

Rick Schumeyer wrote:

I hope pg-general is the correct forum for this question.if not please let
me know the correct location.

I have a pg application that uses tsearch2. I would like to move this
application off my local machine and onto a web host somewhere. I have

some

questions regarding this:

1) What is the preferred postgresql text searching tool these days?
Is it still tsearch2?

Yes and pg_trgm (similar but different)

2) Can someone suggest a web host service that includes tsearch2 (or
an equivalent text searching component)?

www.commandprompt.com

3) All the web hosts I am aware of are still offering only pg 7.4.
Does anybody offer pg 8.x ?

8.0.x and 8.1.x only.

Joshua D. Drake

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

#4Jean-Christophe Roux
jcxxr@yahoo.com
In reply to: Joshua D. Drake (#2)
Re: pg web hosting with tsearch2?

I don't know if A2webhosting.com specifically supports tsearch2, but they say they offer 8.1 with procedural language installed.
JCR

----- Original Message ----
From: Joshua D. Drake <jd@commandprompt.com>
To: Rick Schumeyer <rschumeyer@ieee.org>
Cc: pgsql-general@postgresql.org
Sent: Friday, September 29, 2006 5:04:51 PM
Subject: Re: [GENERAL] pg web hosting with tsearch2?

Rick Schumeyer wrote:

I hope pg-general is the correct forum for this question.if not please let
me know the correct location.

I have a pg application that uses tsearch2. I would like to move this
application off my local machine and onto a web host somewhere. I have some
questions regarding this:

1) What is the preferred postgresql text searching tool these days?
Is it still tsearch2?

Yes and pg_trgm (similar but different)

2) Can someone suggest a web host service that includes tsearch2 (or
an equivalent text searching component)?

www.commandprompt.com

3) All the web hosts I am aware of are still offering only pg 7.4.
Does anybody offer pg 8.x ?

8.0.x and 8.1.x only.

Joshua D. Drake

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

#5Joshua D. Drake
jd@commandprompt.com
In reply to: Jean-Christophe Roux (#4)
Re: pg web hosting with tsearch2?

Rick Schumeyer wrote:

I guess I should have mentioned this initially...I also need a web host that
offers that other database (my***). We are using the Joomla content

Well that pretty much blows us out of the water :).

I'm examining that commandprompt...my initial guess is they do not support
my*** ?

No guessing about it from the site:

MySQL Databases

* We support MySQL for migration purposes only. If you need MySQL
support, please contact us to discuss your migration plans. Also, MySQL
is only available with dedicated hosting services.

So if you have a migration plan, we are 100% happy to help you :)

Sincerely,

Joshua D. Drake
Command Prompt, Inc.

-----Original Message-----
From: Joshua D. Drake [mailto:jd@commandprompt.com]
Sent: Friday, September 29, 2006 5:05 PM
To: Rick Schumeyer
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] pg web hosting with tsearch2?

Rick Schumeyer wrote:

I hope pg-general is the correct forum for this question.if not please let
me know the correct location.

I have a pg application that uses tsearch2. I would like to move this
application off my local machine and onto a web host somewhere. I have

some

questions regarding this:

1) What is the preferred postgresql text searching tool these days?
Is it still tsearch2?

Yes and pg_trgm (similar but different)

2) Can someone suggest a web host service that includes tsearch2 (or
an equivalent text searching component)?

www.commandprompt.com

3) All the web hosts I am aware of are still offering only pg 7.4.
Does anybody offer pg 8.x ?

8.0.x and 8.1.x only.

Joshua D. Drake

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

#6Michelle Konzack
linux4michelle@freenet.de
In reply to: Rick Schumeyer (#1)
Re: pg web hosting with tsearch2?

Am 2006-09-29 13:45:34, schrieb Rick Schumeyer:

3) All the web hosts I am aware of are still offering only pg 7.4.
Does anybody offer pg 8.x ?

I am thinking about a root-Server for 39 Euro/Month
on which I can install what I want

Greetings
Michelle Konzack
Systemadministrator
Tamay Dogan Network
Debian GNU/Linux Consultant

--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
Michelle Konzack Apt. 917 ICQ #328449886
50, rue de Soultz MSM LinuxMichi
0033/6/61925193 67100 Strasbourg/France IRC #Debian (irc.icq.com)

#7Robby Russell
robby.lists@planetargon.com
In reply to: Rick Schumeyer (#1)
Re: pg web hosting with tsearch2?

On Sep 29, 2006, at 10:45 AM, Rick Schumeyer wrote:

I hope pg-general is the correct forum for this question…if not
please let me know the correct location.

I have a pg application that uses tsearch2. I would like to move
this application off my local machine and onto a web host
somewhere. I have some questions regarding this:

2) Can someone suggest a web host service that includes
tsearch2 (or an equivalent text searching component)?

http://www.planetargon.com/

3) All the web hosts I am aware of are still offering only
pg 7.4. Does anybody offer pg 8.x ?

http://www.planetargon.com/postgresql_hosting.html

-Robby

#8John DeSoi
desoi@pgedit.com
In reply to: Robby Russell (#7)
Re: pg web hosting with tsearch2?

a2hosting.com offers tsearch2 and recent versions for PostgreSQL
hosting.

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL