[ADMIN] Compilation error with --with-java option

2004-09-29 Thread KrishnaPradeep Tamma
hi, I was able to successfully compile and run postgresql-7.4.5 with out "--with-java" option on a Redhat Linux machine. But when I enable the "--with-java" option I am getting the following error message. * gmake[3]: Enteri

[ADMIN] fedora core 2 postgresql regression tests fail

2004-09-29 Thread John McBride
Hello, I have been playing with postgresql at home, working through a book on general database installation and use. Mostly it is an oracle book, but much of the book is easily translated to Postgres. This is on a fedora core 2 linux box, kept fully yum updated. Here are the packages installed

Re: [ADMIN] Data Partition is Growing

2004-09-29 Thread Tom Lane
... forgot to mention ... Mike Darretta <[EMAIL PROTECTED]> writes: > We are running Postgres 7.4 with the incremental vacuum process active. Also make sure you have an up-to-date version of pg_autovacuum. The early releases had bugs that could prevent it from vacuuming very large tables at all

Re: [ADMIN] Data Partition is Growing

2004-09-29 Thread Tom Lane
Mike Darretta <[EMAIL PROTECTED]> writes: > I'm an application developer trying to understand a pg data partition > issue. We are storing large objects (gifs) at a rate of about 1GIG /day. > After about a week, most of the objects are recycled -- that is, an > insert triggers a delete of a simil

[ADMIN] Data Partition is Growing

2004-09-29 Thread Mike Darretta
I'm an application developer trying to understand a pg data partition issue. We are storing large objects (gifs) at a rate of about 1GIG /day. After about a week, most of the objects are recycled -- that is, an insert triggers a delete of a similar object. The postgres data partition, though, c

Re: [ADMIN] TCP/IP access in Postgresql 8 Windows

2004-09-29 Thread Bender, Cheryl
Correction to my previous statement, Remote tcp/ip connections on windows are not enabled by default, but Magnus is right in that local connections are enabled by default. Sorry for my mistatement. Cheryl Bender -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Be

Re: [ADMIN] TCP/IP access in Postgresql 8 Windows

2004-09-29 Thread Magnus Hagander
> < else>> > This is not bourne out by my experience or the document you > referenced. > The document and postgresql.conf both state that the default > is 'localhost' and only allows local loopback connections. Default is 'localhost'. This is TCP/IP. Which is different from Unix sockets. Since U

Re: [ADMIN] TCP/IP access in Postgresql 8 Windows

2004-09-29 Thread Bender, Cheryl
<> This is not bourne out by my experience or the document you referenced. The document and postgresql.conf both state that the default is 'localhost' and only allows local loopback connections. For some reason the author of postgresql.conf did not follow the convention of putting the commented d

Re: [ADMIN] TCP/IP access in Postgresql 8 Windows

2004-09-29 Thread Magnus Hagander
> Hi, > > I'm pretty versed in Postgresql version 7.* on Linux. Need to setup a > 8.* server on Windows. Postgresql 8 is rejecting TCP/IP connections. > Tried to acivate tcpip_sockets, as in the 7.4.* versions, > configuring postgresql.conf param tcpip_sockets, but it is > not recognized by vers

Re: [ADMIN] TCP/IP access in Postgresql 8 Windows

2004-09-29 Thread Bender, Cheryl
Werner; Activating tcp/ip listening is different than 7.*. You need to uncomment the following line in your postgresql.conf and change it to listen on a specified interface or '*' for all interfaces. Listen_addresses='*' Then restart the service. Another very useful parameter on Windows to c

[ADMIN] TCP/IP access in Postgresql 8 Windows

2004-09-29 Thread Werner Bohl
Hi, I'm pretty versed in Postgresql version 7.* on Linux. Need to setup a 8.* server on Windows. Postgresql 8 is rejecting TCP/IP connections. Tried to acivate tcpip_sockets, as in the 7.4.* versions, configuring postgresql.conf param tcpip_sockets, but it is not recognized by version 8 (it even f

Re: [ADMIN] tsearch2 poor performance

2004-09-29 Thread Oleg Bartunov
Kris, is't possible to share your "paragraph generator" ? It'd be better than downloading the whole dump :) On Wed, 29 Sep 2004, Kris Kiger wrote: > Oleg, the data I have right now was generated using a random paragraph > generator. The words are real words, but there are only 508 distinct > ke

Re: [ADMIN] tsearch2 poor performance

2004-09-29 Thread Kris Kiger
Oleg, the data I have right now was generated using a random paragraph generator. The words are real words, but there are only 508 distinct keywords in the 3,000,000 records that tsearch2 will pick up, using default settings. I was using this data set for the purpose of testing tsearch2's cap

Re: [ADMIN] tsearch2 poor performance

2004-09-29 Thread Oleg Bartunov
Kris, we're working on prototype of tsearchd - full text search daemon, which maintain static inverted index outside of postgresql using the same parser, dictionary tsearch2 does. This approach could scale up fts capability preserving access to metadata, so yo may have "archive" part of your coll

Re: [ADMIN] How to install plperl on Windows?

2004-09-29 Thread Magnus Hagander
> Hi, > > Hope someone can help me with this. Installed > postgresql-8.0-beta2-dev3.msi, then installed Perl 5.8: > activeperl5.8.4. > When issuing a createlang plperl it errs with: > createlang: Language installation failed: ERROR could not > load library "C:\Program > Files\PostgreSQL\8.0-