Thread: YOUR SITES SEARCH FEATURE DOES NOT WORK!

YOUR SITES SEARCH FEATURE DOES NOT WORK!

From
"3rd."
Date:
hello,

i've been trying now for the last hour to use your
sites search feature.

guess what it doesn't work.

i've tried with 2 different browsers about 20 times.

never once did your search feature work. it never
found anything let alone tell me it was even trying to
search. i only know it was trying to search from the
browser motion.

just now after waiting (again) i was notified your
website could not connect to whatever it has to.

i really need help with Postgresql and OS X terminal.
i cannot figure out how to create a new user. firstly
i cannot figure out how to get back into the
postgresql interactive terminal.

please help me


__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

Re: YOUR SITES SEARCH FEATURE DOES NOT WORK!

From
"Marc G. Fournier"
Date:
okay, first off ... what URL?  I've been working on, and testing, archives
all week, and altho getting things down below a 2min search appears to be
near impossible (anyone know something *better* then mnogosearch that will
handle >250k URLs and growing ... ?  we tried ht/Dig before, and the
resources it suck'd were outrageous) ...




On Mon, 1 Sep 2003, 3rd. wrote:

> hello,
>
> i've been trying now for the last hour to use your
> sites search feature.
>
> guess what it doesn't work.
>
> i've tried with 2 different browsers about 20 times.
>
> never once did your search feature work. it never
> found anything let alone tell me it was even trying to
> search. i only know it was trying to search from the
> browser motion.
>
> just now after waiting (again) i was notified your
> website could not connect to whatever it has to.
>
> i really need help with Postgresql and OS X terminal.
> i cannot figure out how to create a new user. firstly
> i cannot figure out how to get back into the
> postgresql interactive terminal.
>
> please help me
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site design software
> http://sitebuilder.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>

Re: YOUR SITES SEARCH FEATURE DOES NOT WORK!

From
matt
Date:
This is not facetious, honestly, but what about google?

site:archives.postgresql.org +"OS X" +terminal

returns just a couple of pages...

Of course there's no date ordering as such, although "+2003" works
fairly well, as does +"[ADMIN]".

Not a panacea I know, but it's quick, and it does have the whole of
archives indexed.

M

On Tue, 2003-09-02 at 23:26, Marc G. Fournier wrote:
> okay, first off ... what URL?  I've been working on, and testing, archives
> all week, and altho getting things down below a 2min search appears to be
> near impossible (anyone know something *better* then mnogosearch that will
> handle >250k URLs and growing ... ?  we tried ht/Dig before, and the
> resources it suck'd were outrageous) ...
>
>
>
>
> On Mon, 1 Sep 2003, 3rd. wrote:
>
> > hello,
> >
> > i've been trying now for the last hour to use your
> > sites search feature.
> >
> > guess what it doesn't work.
> >
> > i've tried with 2 different browsers about 20 times.
> >
> > never once did your search feature work. it never
> > found anything let alone tell me it was even trying to
> > search. i only know it was trying to search from the
> > browser motion.
> >
> > just now after waiting (again) i was notified your
> > website could not connect to whatever it has to.
> >
> > i really need help with Postgresql and OS X terminal.
> > i cannot figure out how to create a new user. firstly
> > i cannot figure out how to get back into the
> > postgresql interactive terminal.
> >
> > please help me
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > Yahoo! SiteBuilder - Free, easy-to-use web site design software
> > http://sitebuilder.yahoo.com
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> >                http://archives.postgresql.org
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>


Re: YOUR SITES SEARCH FEATURE DOES NOT WORK!

From
Ian Barwick
Date:
On Wednesday 03 September 2003 00:26, Marc G. Fournier wrote:
> okay, first off ... what URL?  I've been working on, and testing, archives
> all week, and altho getting things down below a 2min search appears to be
> near impossible (anyone know something *better* then mnogosearch that will
> handle >250k URLs and growing ... ?  we tried ht/Dig before, and the
> resources it suck'd were outrageous) ...

At a pinch and as an alternative there's always google: use

site:archives.postgresql.org "search terms here"

or similar and it does a very quick search. Unfortunately
index seems to be about a month behind.


Ian Barwick
barwick@gmx.net

Re: YOUR SITES SEARCH FEATURE DOES NOT WORK!

From
Ian Barwick
Date:
On Wednesday 03 September 2003 09:42, Ian Barwick wrote:
> On Wednesday 03 September 2003 00:26, Marc G. Fournier wrote:
> > okay, first off ... what URL?  I've been working on, and testing,
> > archives all week, and altho getting things down below a 2min search
> > appears to be near impossible (anyone know something *better* then
> > mnogosearch that will handle >250k URLs and growing ... ?  we tried
> > ht/Dig before, and the resources it suck'd were outrageous) ...
>
> At a pinch and as an alternative there's always google: use
>
> site:archives.postgresql.org "search terms here"
>
> or similar and it does a very quick search. Unfortunately
> index seems to be about a month behind.

A more up-to-date alternative:

  http://www.mail-archive.com/index.php?hunt=pgsql-

Other possibilities:

  http://geocrawler.com/lists/3/Databases/
  http://groups.google.com/groups?q=comp.databases.postgresql&hl=en
  http://marc.theaimsgroup.com/ (see section "Databases")


Ian Barwick
barwick@gmx.net


Dumping select tables (omitting tables)

From
Yuji Shinozaki
Date:
I would like to dump select tables from a database (omitting some tables).

It looks like pg_dump only allows you to dump the entire database or
select single tables to dump.   Is there a way to specify to pg_dump a
list of tables to dump (or to omit)?

I can dump all the desired tables as single dumps, but
dump-many-single-tables approach is troublesome since I want to apply the
indexes at the end to make the restore more efficient (and to avoid
integrity checking until the entire database is restored)

Wouldn't that mean hand-editing the dumps to apply the indexes separately
(or at least last)?  Or can I simply concatenate all these single-table
dumps and tell pg_restore to apply the indexes last?

Is there a simple way to accomplish this?

yuji
----
Yuji Shinozaki                            Computer Systems Senior Engineer
ys2n@virginia.edu            Advanced Technologies Group
(434)924-7171                Information Technology & Communication
http://www.people.virginia.edu/~ys2n    University of Virginia


Re: Dumping select tables (omitting tables)

From
Bruce Momjian
Date:
Yuji Shinozaki wrote:
>
> I would like to dump select tables from a database (omitting some tables).
>
> It looks like pg_dump only allows you to dump the entire database or
> select single tables to dump.   Is there a way to specify to pg_dump a
> list of tables to dump (or to omit)?
>
> I can dump all the desired tables as single dumps, but
> dump-many-single-tables approach is troublesome since I want to apply the
> indexes at the end to make the restore more efficient (and to avoid
> integrity checking until the entire database is restored)
>
> Wouldn't that mean hand-editing the dumps to apply the indexes separately
> (or at least last)?  Or can I simply concatenate all these single-table
> dumps and tell pg_restore to apply the indexes last?
>
> Is there a simple way to accomplish this?
>

You can just concatenate them, I think.  The only thing I don't know is
how referential integrity constraints will be handled because the
primary table might not exist when you create the foreign table.

We can dump specific schemas in 7.4beta.  You can do a full dump and use
pg_resetore to pull out specific tables, but then again, I don't know
how it handles referential integrity.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Re: YOUR SITES SEARCH FEATURE DOES NOT WORK!

From
"scott.marlowe"
Date:
On Tue, 2 Sep 2003, Marc G. Fournier wrote:

>
> okay, first off ... what URL?  I've been working on, and testing, archives
> all week, and altho getting things down below a 2min search appears to be
> near impossible (anyone know something *better* then mnogosearch that will
> handle >250k URLs and growing ... ?  we tried ht/Dig before, and the
> resources it suck'd were outrageous) ...

Hi Marc, I use htdig at work to index a rather large web site and it
doesn't use resources all that bad.   My htdig db directory is only 250
megs and it screams.  Are you sure it was that bad?

Would it be ok if I pointed a test instance of htdig at postgresql.org at
night and indexed it to get an idea of how much space it'll take to index
it?  I'm a huge fan of htdig/ warts and all, so I'd kinda like to see if
it can be made to work.


Re: YOUR SITES SEARCH FEATURE DOES NOT WORK!

From
"Marc G. Fournier"
Date:
go for it, point it at archives.postgresql.org though, since that is the
major part of the search engine

On Thu, 4 Sep 2003, scott.marlowe wrote:

> On Tue, 2 Sep 2003, Marc G. Fournier wrote:
>
> >
> > okay, first off ... what URL?  I've been working on, and testing, archives
> > all week, and altho getting things down below a 2min search appears to be
> > near impossible (anyone know something *better* then mnogosearch that will
> > handle >250k URLs and growing ... ?  we tried ht/Dig before, and the
> > resources it suck'd were outrageous) ...
>
> Hi Marc, I use htdig at work to index a rather large web site and it
> doesn't use resources all that bad.   My htdig db directory is only 250
> megs and it screams.  Are you sure it was that bad?
>
> Would it be ok if I pointed a test instance of htdig at postgresql.org at
> night and indexed it to get an idea of how much space it'll take to index
> it?  I'm a huge fan of htdig/ warts and all, so I'd kinda like to see if
> it can be made to work.
>
>

Re: YOUR SITES SEARCH FEATURE DOES NOT WORK!

From
"Marc G. Fournier"
Date:
k, try the search engine now ... I just found a 'missing index' on one of
the critical tables, and I'm getting more realistic speeds on search
results ...

On Thu, 4 Sep 2003, Marc G. Fournier wrote:

>
> go for it, point it at archives.postgresql.org though, since that is the
> major part of the search engine
>
> On Thu, 4 Sep 2003, scott.marlowe wrote:
>
> > On Tue, 2 Sep 2003, Marc G. Fournier wrote:
> >
> > >
> > > okay, first off ... what URL?  I've been working on, and testing, archives
> > > all week, and altho getting things down below a 2min search appears to be
> > > near impossible (anyone know something *better* then mnogosearch that will
> > > handle >250k URLs and growing ... ?  we tried ht/Dig before, and the
> > > resources it suck'd were outrageous) ...
> >
> > Hi Marc, I use htdig at work to index a rather large web site and it
> > doesn't use resources all that bad.   My htdig db directory is only 250
> > megs and it screams.  Are you sure it was that bad?
> >
> > Would it be ok if I pointed a test instance of htdig at postgresql.org at
> > night and indexed it to get an idea of how much space it'll take to index
> > it?  I'm a huge fan of htdig/ warts and all, so I'd kinda like to see if
> > it can be made to work.
> >
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>

Re: YOUR SITES SEARCH FEATURE DOES NOT WORK!

From
Ang Chin Han
Date:
Marc G. Fournier wrote:
> okay, first off ... what URL?  I've been working on, and testing, archives
> all week, and altho getting things down below a 2min search appears to be
> near impossible (anyone know something *better* then mnogosearch that will
> handle >250k URLs and growing ... ?  we tried ht/Dig before, and the
> resources it suck'd were outrageous) ...

(I assume we're talking about the email archives).

How about a quick and dirty script (perl, maybe) that grabs everything,
"intelligently" chucks the pseudo contents (stripping message quotes for
instance) into a pgsql table, and then see if tsearchv2 can be used to
search it via another quick and dirty CGI? Have to find some place to
host it though, the db might be huge.

Eating our own dog food and all that.

--
Linux homer 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386
GNU/Linux
   6:30pm  up 253 days,  9:51,  5 users,  load average: 5.00, 5.00, 5.00

Attachment

Re: YOUR SITES SEARCH FEATURE DOES NOT WORK!

From
Robert Treat
Date:
Personally I'd like to see effort go into getting fts.postgresql.org
back up and going; I've always had better results searching their.

Robert Treat

On Thu, 2003-09-04 at 14:38, Marc G. Fournier wrote:
>
> k, try the search engine now ... I just found a 'missing index' on one of
> the critical tables, and I'm getting more realistic speeds on search
> results ...
>
> On Thu, 4 Sep 2003, Marc G. Fournier wrote:
>
> >
> > go for it, point it at archives.postgresql.org though, since that is the
> > major part of the search engine
> >
> > On Thu, 4 Sep 2003, scott.marlowe wrote:
> >
> > > On Tue, 2 Sep 2003, Marc G. Fournier wrote:
> > >
> > > >
> > > > okay, first off ... what URL?  I've been working on, and testing, archives
> > > > all week, and altho getting things down below a 2min search appears to be
> > > > near impossible (anyone know something *better* then mnogosearch that will
> > > > handle >250k URLs and growing ... ?  we tried ht/Dig before, and the
> > > > resources it suck'd were outrageous) ...
> > >
> > > Hi Marc, I use htdig at work to index a rather large web site and it
> > > doesn't use resources all that bad.   My htdig db directory is only 250
> > > megs and it screams.  Are you sure it was that bad?
> > >
> > > Would it be ok if I pointed a test instance of htdig at postgresql.org at
> > > night and indexed it to get an idea of how much space it'll take to index
> > > it?  I'm a huge fan of htdig/ warts and all, so I'd kinda like to see if
> > > it can be made to work.
> > >
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL


Re: YOUR SITES SEARCH FEATURE DOES NOT WORK!

From
"Marc G. Fournier"
Date:

On Fri, 5 Sep 2003, Robert Treat wrote:

> Personally I'd like to see effort go into getting fts.postgresql.org
> back up and going; I've always had better results searching their.

As far as I know, the database side is ready for them, and Teodor has the
information, but I suspect that beta is bogging them down also ...

Fixing the index on the url table in mnogosearch appears to have made an
immense difference ... by factors of 10 ...


Re: YOUR SITES SEARCH FEATURE DOES NOT WORK!

From
"Marc G. Fournier"
Date:

check the archive search now and let me know if you find it still doesn't
work ...

On Fri, 5 Sep 2003, Ang Chin Han wrote:

> Marc G. Fournier wrote:
> > okay, first off ... what URL?  I've been working on, and testing, archives
> > all week, and altho getting things down below a 2min search appears to be
> > near impossible (anyone know something *better* then mnogosearch that will
> > handle >250k URLs and growing ... ?  we tried ht/Dig before, and the
> > resources it suck'd were outrageous) ...
>
> (I assume we're talking about the email archives).
>
> How about a quick and dirty script (perl, maybe) that grabs everything,
> "intelligently" chucks the pseudo contents (stripping message quotes for
> instance) into a pgsql table, and then see if tsearchv2 can be used to
> search it via another quick and dirty CGI? Have to find some place to
> host it though, the db might be huge.
>
> Eating our own dog food and all that.
>
> --
> Linux homer 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386
> GNU/Linux
>    6:30pm  up 253 days,  9:51,  5 users,  load average: 5.00, 5.00, 5.00
>

Re: YOUR SITES SEARCH FEATURE DOES NOT WORK!

From
"Nick Fankhauser"
Date:
Can't help with the search engine, but the answer to your question is: psql
<database name>.

I'd recommend starting with the tutorial in the docs for questions like
this.
http://www.postgresql.org/docs/7.3/static/tutorial-start.html

I can also confirm that the search engine in the docs area
(http://www.postgresql.org/docs/7.3/static/index.html) is working. I just
used it moments ago.

-Nick


> -----Original Message-----
> From: pgsql-admin-owner@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of 3rd.
> Sent: Monday, September 01, 2003 7:58 PM
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] YOUR SITES SEARCH FEATURE DOES NOT WORK!
>
>
> hello,
>
> i've been trying now for the last hour to use your
> sites search feature.
>
> guess what it doesn't work.
>
> i've tried with 2 different browsers about 20 times.
>
> never once did your search feature work. it never
> found anything let alone tell me it was even trying to
> search. i only know it was trying to search from the
> browser motion.
>
> just now after waiting (again) i was notified your
> website could not connect to whatever it has to.
>
> i really need help with Postgresql and OS X terminal.
> i cannot figure out how to create a new user. firstly
> i cannot figure out how to get back into the
> postgresql interactive terminal.
>
> please help me
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site design software
> http://sitebuilder.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>



Re: YOUR SITES SEARCH FEATURE DOES NOT WORK!

From
"Glenn Wiorek"
Date:
These links might also be of help.  Found then on the Postgres Techdoc
Site -  http://techdocs.postgresql.org/

http://developer.apple.com/internet/macosx/postgres.html
http://www.macdevcenter.com/pub/a/mac/2002/06/07/postgresql.html

----- Original Message -----
From: "Nick Fankhauser" <nickf@ontko.com>
To: "3rd." <mnevara@yahoo.com>; <pgsql-admin@postgresql.org>
Sent: Friday, November 14, 2003 3:51 PM
Subject: Re: [ADMIN] YOUR SITES SEARCH FEATURE DOES NOT WORK!


> Can't help with the search engine, but the answer to your question is:
psql
> <database name>.
>
> I'd recommend starting with the tutorial in the docs for questions like
> this.
> http://www.postgresql.org/docs/7.3/static/tutorial-start.html
>
> I can also confirm that the search engine in the docs area
> (http://www.postgresql.org/docs/7.3/static/index.html) is working. I just
> used it moments ago.
>
> -Nick
>
>
> > -----Original Message-----
> > From: pgsql-admin-owner@postgresql.org
> > [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of 3rd.
> > Sent: Monday, September 01, 2003 7:58 PM
> > To: pgsql-admin@postgresql.org
> > Subject: [ADMIN] YOUR SITES SEARCH FEATURE DOES NOT WORK!
> >
> >
> > hello,
> >
> > i've been trying now for the last hour to use your
> > sites search feature.
> >
> > guess what it doesn't work.
> >
> > i've tried with 2 different browsers about 20 times.
> >
> > never once did your search feature work. it never
> > found anything let alone tell me it was even trying to
> > search. i only know it was trying to search from the
> > browser motion.
> >
> > just now after waiting (again) i was notified your
> > website could not connect to whatever it has to.
> >
> > i really need help with Postgresql and OS X terminal.
> > i cannot figure out how to create a new user. firstly
> > i cannot figure out how to get back into the
> > postgresql interactive terminal.
> >
> > please help me
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > Yahoo! SiteBuilder - Free, easy-to-use web site design software
> > http://sitebuilder.yahoo.com
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> >                http://archives.postgresql.org
> >
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>



Re: YOUR SITES SEARCH FEATURE DOES NOT WORK!

From
"Marc G. Fournier"
Date:
What URL are you using?  I just went to archives.postgresql.org, typed in
'mvcc' for a search and it came back in <10 seconds ...

On Fri, 14 Nov 2003, Nick Fankhauser wrote:

> Can't help with the search engine, but the answer to your question is: psql
> <database name>.
>
> I'd recommend starting with the tutorial in the docs for questions like
> this.
> http://www.postgresql.org/docs/7.3/static/tutorial-start.html
>
> I can also confirm that the search engine in the docs area
> (http://www.postgresql.org/docs/7.3/static/index.html) is working. I just
> used it moments ago.
>
> -Nick
>
>
> > -----Original Message-----
> > From: pgsql-admin-owner@postgresql.org
> > [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of 3rd.
> > Sent: Monday, September 01, 2003 7:58 PM
> > To: pgsql-admin@postgresql.org
> > Subject: [ADMIN] YOUR SITES SEARCH FEATURE DOES NOT WORK!
> >
> >
> > hello,
> >
> > i've been trying now for the last hour to use your
> > sites search feature.
> >
> > guess what it doesn't work.
> >
> > i've tried with 2 different browsers about 20 times.
> >
> > never once did your search feature work. it never
> > found anything let alone tell me it was even trying to
> > search. i only know it was trying to search from the
> > browser motion.
> >
> > just now after waiting (again) i was notified your
> > website could not connect to whatever it has to.
> >
> > i really need help with Postgresql and OS X terminal.
> > i cannot figure out how to create a new user. firstly
> > i cannot figure out how to get back into the
> > postgresql interactive terminal.
> >
> > please help me
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > Yahoo! SiteBuilder - Free, easy-to-use web site design software
> > http://sitebuilder.yahoo.com
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> >                http://archives.postgresql.org
> >
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>