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
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:
Show quoted text
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?
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
Show quoted text
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?---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
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
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
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
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
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.
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:
Show quoted text
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.
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:
Show quoted text
go for it, point it at archives.postgresql.org though, since that is the
major part of the search engineOn 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)
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
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 engineOn 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
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 ...
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:
Show quoted text
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
hi Marc,
for whatever reason i think your board is very
confusing and hard to find information.
i was hoping you could help me by answering a few
questions about postgresql.
why don't you people have a regular PHPBBs? they are
so easy to use and understand.
i greatly appreciate it.
hello everyone i am very new to postgresql 7.3.3 and
am using it on my mac G4 OS X and i am having some
trouble which i hope you can help me out with some
answers to my questions:
1.) How can I get a list of users currently logged
into the database? Is it possible?
2) I plan on using postgresql for a posting board
database, how can I search for a certain word that is
in the post's topic subject header? For example if the
post subject was "Flying to the moon" and the user
wants to find that post he/she enters 'moon' in the
search field I made, I've used the : SELECT * FROM
mytable WHERE (subject) LIKE 'moon'); command to find
a one word exact match but don't know how to find just
one word in a string of words using postgresql. (
web/http is not an option for my posting board. )
3.) Is having the default user 'Postgres' a security
risk? wouldn't a hacker look for that default user
name and thus make it easier for him to break in?
4.) Is there a database table limit? (can I have 700
tables in my database?)
5.) is there a text length limit? as I said I plan on
using postgresql and your plugin for a Posting board
and also an email system for my server so I am
wondering if there is a limit to the posts and email
lengths?
6.) How can I backup my postgresql database and
tables? is it possible to backup only certain tables
and not the whole database?
Is it possible to use your plugin for regular
scheduled backups?
7.) how many users can a mac OS X system support at
one time while maintaining decent/good performance?
does postgreSQL have a limit for mac servers? i've
read that windows has a limit of only about 50
simultaneous users. i have a fast G4 and if i have to
will buy a G5 i suspect i'll need to support 200
simultaneous users that are actively file swapping.
can a G4/G5 handle that?
8.) can anyone recommend a really good book for Mac OS
X and postgreSQL? it's very hard for me to get good
help/information online, it's slow and complicated to
me and it also hurts my eyes. has anyone read
O'reily's book 'practicle postgresql'? is it good?
I know these are alot of questions but for some reason
i am having a really hard time trying to figure it out
on my own.
thank you very much.
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
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
Show quoted text
-----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?
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
Show quoted text
<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.htmlI 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?---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
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:
Show quoted text
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.htmlI 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?---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)