Re: [GENERAL] Query, usually running <300ms, sometimes hangs for hours

Hi! Tom Lane wrote: > Yes, that reading is correct: this stack trace shows > it's blocked trying to send query results back to > the client. > So you need to figure out why the client is failing > to accept data. Thanks; we saw one of those zombie queries again today, a simple restart of the

[GENERAL] Query, usually running <300ms, sometimes hangs for hours

Hi! We're currently still on PostgreSQL 8.3.7 and are experiencing a strange problem since a couple of days. I have a suspicion on what is causing it (probably not PostgreSQL) and I'd like to hear your opinion before taking my findings to the Railo bugtracker. We're running queries like this ever

Re: [GENERAL] Problem with to_tsquery() after restore on PostgreSQL 9.0.1

Hi! Tom Lane writes: > So far as I can see offhand, the only way you'd get that error message > is if to_tsquery were declared to take OID not regconfig as its first > argument. > > > I suspect it has to do with the Tsearch2-compatibility modules from > > contrib - these were compiled and insta

[GENERAL] Problem with to_tsquery() after restore on PostgreSQL 9.0.1

Hi! I currently testing the upgrade of our 8.3 databases to 9.0. In some of those restored databases to_tsquery is throwing an error: magazine=# SELECT to_tsquery('simple','plants'); ERROR: invalid input syntax for type oid: "simple" LINE 1: SELECT to_tsquery('simple','plants'); In other datab

Re: [GENERAL] Transaction wraparound problem with database postgres

Hi! > From: Scott Marlowe [mailto:scott.marl...@gmail.com] > Do your logs show any kind of error when vacuuming about > "only owner can vacuum" a table or anything? I grepped through the logs from the last four days and, no, there were none such errors whatsoever. Last vacuum analyze run retu

Re: [GENERAL] Transaction wraparound problem with database postgres

looked into right now, but if I knew what kind of data to retain I mit be able to come up with some more useful info next time... Kind regards Markus > -Ursprüngliche Nachricht- > Von: Markus Wollny > Gesendet: Freitag, 21. März 2008 23:34 > An: 'Tom Lane&#x

Re: [GENERAL] Massive table bloat

> -Ursprüngliche Nachricht- > Von: Thom Brown [mailto:thombr...@gmail.com] > Gesendet: Mittwoch, 3. März 2010 16:56 > An: Markus Wollny > Cc: pgsql-general@postgresql.org > Betreff: Re: [GENERAL] Massive table bloat > If you update rows, it actually creates a new v

[GENERAL] Massive table bloat

Hi! I've set up some system to track slow page executions in one of our (as yet not live) web apps. The tracking itself is handled completely within the database using a function. Within a very short time (approx. 1 week) and although we haven't got that much traffic on our testpages, the table in

Re: [GENERAL] Postgres won't start. Nothing in the log.

Hi! pgsql-general-ow...@postgresql.org wrote: > Unfortunately there is nothing anywhere telling me what the > problem is. The log file is empty, there is nothing in the > /var/log/messages or /var/log/syslog either. The only output > I get is this. > > * Starting PostgreSQL 8.3 database server >

Re: [GENERAL] GIN and GiST index - more in depth info

> For sure I had a look to Oleg Bartunov' s and Teodor Sigaev's > website at http://www.sai.msu.su/~megera/wiki/ but for me > it's still not clear how to describe the differences between > the indexes and the usage scenarios when to use GIN or GiST. As far as I understand it's a matter of usage

Re: [GENERAL] Could not open file "pg_clog/...."

Hi! > It appears to be failing on the pcaction.article table. Could > you get away without that? Perhaps, and it'd be a longshot, > you'd be able to dump the rest of the data with it gone? > > I'm going to duck out of this now though, and I think you > should probably wait until someone a lit

Re: [GENERAL] Could not open file "pg_clog/...."

Hi! > -Ursprüngliche Nachricht- > Von: Glyn Astill [mailto:glynast...@yahoo.co.uk] > Gesendet: Dienstag, 12. Mai 2009 12:33 > An: pgsql-general@postgresql.org; Markus Wollny > The first thing I would have done if I've been forced to do > that (if there was no ot

[GENERAL] Could not open file "pg_clog/...."

Hello! Recently one of my PostgreSQL servers has started throwing error messages like these: ERROR: could not access status of transaction 3489956864 DETAIL: Could not open file "pg_clog/0D00": Datei oder Verzeichnis nicht gefunden. (file not found) The machine in question doesn't show any sig

[GENERAL] Question about function returning record

Hi! I've got a generalized function getshadowrecord(schema (varchar),table (varchar), id (int4), version_id (int)) which returns RECORD. As this function is supposed to work on any table structure, I need to declare a column alias list when I do a SELECT on it, like SELECT *

[GENERAL] PL/Perl: Is there a way to use spi_prepare/spi_exec_prepared with a list as second argument?

Hello! I'd like to dynamically prepare and execute a certain statement in PL/perl, i.e. I don't know at the time of calling my trigger function how many arguments I need to pass for this queries and which types they have. The command string is assembled dynamically, as is the list of type-identifi

Re: [GENERAL] diff-/patch-functionality for text-type data inside PostgreSQL

Hi! > -Ursprüngliche Nachricht- > Von: Tom Lane [mailto:t...@sss.pgh.pa.us] > Gesendet: Montag, 4. Mai 2009 15:04 > "Markus Wollny" writes: > > So far I have been playing around with PL/PerlU for diff/path > > functionality, using CPAN modul

Re: [GENERAL] diff-/patch-functionality for text-type data insidePostgreSQL

Hi! > -Ursprüngliche Nachricht- > Von: Martijn van Oosterhout [mailto:klep...@svana.org] > Gesendet: Montag, 4. Mai 2009 15:30 > I've used the Algorithm::Diff module in the past with > success. It works on sequences of objects rather than just > text but it works well. That means you

[GENERAL] diff-/patch-functionality for text-type data inside PostgreSQL

Hi! I want to implement a versioning system for text columns of a table inside a PostgreSQL 8.3 database. As some of the changes to a text field might be very small compared to the total text size, I'd prefer storing diffs instead of full previous versions of the text and use a patch-like function

[GENERAL] invalid byte sequence on restore

Hi! I am currently struggling with a couple oif tainted bytes in one of our PostgreSQL 8.2 databases which I plan to move to 8.3 soon - so I need to dump & restore. I think this problem bit me almost every single time during a major upgrade in the last couple of years, so I must say that I hav

Re: [GENERAL] Suboptimal execution plan for simple query

Hi! Sam Mason wrote: > You may have some luck with increasing the statistics target on the > entry_id and last_updated columns and re-ANALYZING the table. Then > again, the fact that it thinks it's only going to get a single row > back when it searches for the entity_id suggests that it's all a b

Re: [GENERAL] Suboptimal execution plan for simple query

Hi! In preparation for my upcoming upgrade to PostgreSQL 8.3.5, I have taken the opportunity to try this scenario on a test machine with the latest PostgreSQL version. Unfortunately the result remains the same, though this database has been just reloaded from a dump and vacuum analyzed. select

[GENERAL] Suboptimal execution plan for simple query

Hi! We've got a table with the following definition: CREATE TABLE image_relation ( id integer, article_id integer NOT NULL, entity_id integer NOT NULL, image_id integer NOT NULL, subline text, "position" integer, article_headline text, entity_name text, entity_type_id integer,

[GENERAL] Efficient data structures and UI for product matrix

Hi! We wish to provide our users with a simple-to-use web-based processor-selection tool, where a user could select a couple of attribute values and be presented with a list of matching processors. The basis of the required data would be provided by our editors as Excel documents of the followi

Re: [GENERAL] Need to update all entries of one table based on an earlier backup

Hi! You're missing a table declaration for the table foo_old. You might try this: update foo set foo.foo_name2= (SELECT foo_old.foo_name2 FROM foo_old where foo.foo_id = foo_old.foo_id); Kind regards Markus Von: [EMAIL PROTECTED] [mailto:[EMAIL

Re: [GENERAL] Slony-I configuration problem, probably due to custom casts in 8.3

Hi, Sorry for the bother - found this: http://archives.postgresql.org/pgsql-general/2008-03/msg01159.php That seems to solve the problem. Thank you! Kind regards Markus Computec Media AG Sitz der Gesellschaft und Registergericht: Fürth (HRB 8818) Vorstandsmitglieder: Johannes S. Gözalan (

[GENERAL] Slony-I configuration problem, probably due to custom casts in 8.3

Hi I'm trying to get Slony-I up and running; master-db is PostgreSQL 8.3.1, slave is PostgreSQL 8.2.4, Slony-I is 1.2.14 on both machines. This is the DDL for the table I wish to replicate: CREATE TABLE stats.article_impressions_day ( site_id integer NOT NULL, article_id integer NOT NULL, date

Re: [GENERAL] tsvector_update_trigger throws error "column is not of tsvector type"

Hi! Tom Lane wrote: > > Well, you could probably get away with an "update pg_attribute set > atttypid ..." but it might be safer to just wait for 8.3.2. I like it safe :) Thanks for the advice! Kind regards Markus Computec Media AG Sitz der Gesellschaft und Registergericht: Fürth (HRB 8

Re: [GENERAL] tsvector_update_trigger throws error "column is not of tsvector type"

Tom Lane wrote: > It should work if you explicitly change the column's type to > pg_catalog.tsvector. (There's a fix in place for 8.3.2, also.) Which would probably be not such a good idea to try on a 7GB table in production, I think. Or is there some way hacking the system catalog to correct

Re: [GENERAL] tsvector_update_trigger throws error "column is not of tsvector type"

Hi! Tom Lane wrote: > I wrote: >> Would you confirm that >> select atttypid from pg_attribute where attrelid = >> 'public.ct_com_board_message'::regclass and attname = 'idxfti'; >> gives 3614 (the preassigned OID for pg_catalog.tsvector)? > > Actually, I'll bet a nickel that you'll find it doesn

Re: [GENERAL] tsvector_update_trigger throws error "column is not of tsvector type"

Hi! Tom Lane wrote: > This is leaping to conclusions, but what I suspect is that you've got > two types "tsvector" in your database and the column is the wrong > one. > This situation is not too hard to get into if you try to restore a > dump from an old database that used contrib/tsearch2 --- the

[GENERAL] tsvector_update_trigger throws error "column is not of tsvector type"

Hi! I am in the process of migrating a PostgreSQL 8.2.4 database to 8.3. So far, everything has worked fine, even tsearch2-searching an indexed table. There's something severely wrong with the trigger-function I use to keep the tsvector-column updated. Here's my table definition: CREATE TABLE

Re: [GENERAL] Duplicate Key violation on dump&reload using pg_restore

Tom Lane wrote: > Maybe there actually is a duplicate key in the source DB --- have you > checked? There were some bugs in early 8.2.x releases that could > possibly allow that to happen. Thanks, I was hoping there would be an easy explanation like that. I guess I'll have to do a little reading

Re: [GENERAL] Duplicate Key violation on dump&reload using pg_restore

Quick update: Seems like removing that tuple has solved the issue, dump and import of that table went fine, everything is where is should be - but there shouldn't have been an issue there in the first place however, with the primary key constraint present in the source database. I'm still curiou

[GENERAL] Duplicate Key violation on dump&reload using pg_restore

Hello! I'm currently trying to migrate one of our databases from PostgreSQL 8.2.4 to PostgreSQL 8.3.1. I have worked around the Tsearch2 migration (we used the contrib module) without too much hassle, but find myself stuck at an unexpected point - I get a duplicate key violation for the primar

[GENERAL] Logging of autovacuum activity

Hi, I am a bit stuck finding out how to log autovacuum activity in PostgreSQL 8.2. In the olden times I used to pipe the pg_autovacuum daemon's output to a file. Now pg_autovacuum has become part of the core, I wonder if there's some other possibility of monitoring its activity? I've got the f

Re: [GENERAL] Transaction wraparound problem with database postgres

Tom Lane wrote: > "Markus Wollny" <[EMAIL PROTECTED]> writes: >> I'd still like to find out what exactly happened here so I can >> prevent the same from happening again in the future. > > Me too. It would seem that something did a vacuum of postgres wi

Re: [GENERAL] Transaction wraparound problem with database postgres

Andreas 'ads' Scherbaum wrote: > Hello, > First of all, it would help you and most of the readers on this list, > if you have the error messages in english. There is a german > mailinglist too, if you want to ask in german. Sorry, I tried to describe the issue as best as I could and included the

Re: [GENERAL] Transaction wraparound problem with database postgres

Hi! Thanks for all the quick replies :) Tom Lane wrote: > "Markus Wollny" <[EMAIL PROTECTED]> writes: >> Just some more info, hoping that it helps with a diagnosis: > >> 1: datname (typeid = 19, len = 64, typmod = -1, byval = f) >> 2: age (

Re: [GENERAL] Transaction wraparound problem with database postgres

Hi! Sorry for the quick updates to my own messages, but I didn't want to lean back and wait - so I took to more aggressive measures. All my other databases in this cluster are fine - and the 'postgres' database doesn't seem to do anything really useful except being the default database. I drop

[GENERAL] Transaction wraparound problem with database postgres

Hi! My database cluster has just stopped working. I get the following message: psql: FATAL: Datenbank nimmt keine Befehle an, um Datenverlust in Datenbank »postgres« wegen Transaktionsnummernüberlauf zu vermeiden TIP: Halten Sie den Postmaster an und verwenden Sie ein Standalone-Backend, um V

Re: [GENERAL] Transaction wraparound problem with database postgres

64, typmod = -1, byval = f) 2: age = "-2147321383" (typeid = 23, len = 4, typmod = -1, byval = t) 3: datfrozenxid = "1835116837" (typeid = 28, len = 4, typmod = -1, byval = t) It worries me, that 'age' is negative. Kind regards Mark

[GENERAL] Questions about TSearch2 and PG 8.2

Hello! I'm in the process of upgrading our PostgreSQL 8.1 databases to PostgreSQL 8.2.4. I have stumbled over a minor issue with the upgrade and some helpful suggestions here: http://people.planetpostgresql.org/xzilla/index.php?/archives/291-The-pain-that-is-tsearch2-8.1-8.2-upgrading.html I sh

[GENERAL] 8.2.3 initdb fails - invalid value for parameter "timezone_abbreviations": "Default"

Hello! I've just tried to initdb a fresh install of PostgreSQL 8.3.2 on Debian Etch (testing). My configure settings were ./configure --prefix=/opt/pgsql --datadir=/var/lib/pgsql/data/base --enable-locale --with-perl --enable-odbc --with-java This is what happens: [EMAIL PROTECTED]:~$ /opt/pgsq

[GENERAL] Asynchronous replication of a PostgreSQL DB to a MySQL target

Hi! I'd like to export schema and data from a PostgreSQL database to a remote MySQL database; any changes to the PG-master should be reflected on the MySQL target in a matter of a few minutes to one hour max. Has anybody done something like this before? Here's some more background: We've got an

Re: [GENERAL] invalid byte sequence for encoding error

Nis Jorgensen wrote: > Oliver A. Rojo wrote: >> how do you fix your original db? >> > > Since I had only 3 occurrences of the error, I used > hand-crafted update statements. The fact that the replacement > for the invalid characters was constant and plain ascii made > this very easy. > > If you

Re: [GENERAL] MediaWiki and Postgresql?

Hi [EMAIL PROTECTED] wrote: > Has anyone put MediaWiki up using the current version of Postgresql? I have, although our Mediawiki installation is currently not openly accessible. Can't say that it went like a breeze, but the obstacles where more or less minor and writing a little custom auth-plu

Re: [GENERAL] configure: error: file 'tclConfig.sh' is required for Tcl

Hi! Being a Debian-user I haven't really got a clue about Fedora Core, but have you tried installing the tcl-devel-package? Kind regards Markus Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Teresa Noviello Gesendet: Freit

Re: [GENERAL] error in creating database

Hi! > -Ursprüngliche Nachricht- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im Auftrag von Karthik.S > Gesendet: Dienstag, 6. Dezember 2005 13:26 > An: pgsql-general@postgresql.org > Betreff: [GENERAL] error in creating database > > Dear all, > > I am using postgres ve

Re: [GENERAL] Unicode Corruption and upgrading to 8.0.4. to 8.1

Hi! > -Ursprüngliche Nachricht- > Von: Howard Cole [mailto:[EMAIL PROTECTED] > Gesendet: Dienstag, 6. Dezember 2005 15:38 > An: Markus Wollny > Cc: PgSql General > Betreff: Re: [GENERAL] Unicode Corruption and upgrading to > 8.0.4. to 8.1 > I am avoiding thi

Re: [GENERAL] Unicode Corruption and upgrading to 8.0.4. to 8.1

Hello! > -Ursprüngliche Nachricht- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im Auftrag von Howard Cole > Gesendet: Dienstag, 6. Dezember 2005 13:41 > An: 'PgSql General' > Betreff: Re: [GENERAL] Unicode Corruption and upgrading to > 8.0.4. to 8.1 > >> Hi everyone, I have a p

[GENERAL] 'AS' column-alias beign ignored on outer select

Hi! Is this the expected behaviour? select ID , USK_RATING AS USK from ( select ID , USK_RATING from MAIN_SONY_PS2_GAME where ID = 101400 limit 1 ) as PRODUCT_LIST limit 1; id | usk_rating + 101400 | (1 row) Note the column-header being labe

Re: [GENERAL] Errors upgrading from 7.3 to 8.1

Title: AW: [GENERAL] Errors upgrading from 7.3 to 8.1 Hello! We experienced the exact same problems. You may solve the problem by feeding the dump through iconv. See my earlier message on this issue http://archives.postgresql.org/pgsql-general/2005-11/msg00799.php On top of that you'd be w

Re: [GENERAL] Incomplete Startup Packet

Title: [GENERAL] Incomplete Startup Packet ? Hi!   We're getting "incomplete startup packet" messages in our logfiles due to some sort of system probe run by our service provider which checks if PG is still running. In our case they're harmless of course. Are you sure that you're not runni

Re: [GENERAL] invalid UTF-8 byte sequence detected

Hi! > -Ursprüngliche Nachricht- > Von: Bruce Momjian [mailto:[EMAIL PROTECTED] > Gesendet: Dienstag, 15. November 2005 19:46 > An: Markus Wollny > Cc: pgsql-general@postgresql.org > Betreff: Re: [GENERAL] invalid UTF-8 byte sequence detected > > > I am als

[GENERAL] invalid UTF-8 byte sequence detected

Hello! I am currently testdriving migration of our PostgreSQL 8.0 databases to 8.1; in this process I have stumbled a couple of times over certain errors in text-fields that lead to error-messages during import of the dump like these: <2005-11-09 14:57:34 CET - 9354: [EMAIL PROTECTED]>ERROR: i

Re: [GENERAL] Finding (and deleting) dupes in relation table

Hello! CSN [EMAIL PROTECTED] wrote: > I have a table that relates id's of two other tables: > > table1id, table2id > > Dupes have found their way into it (create unique index > across both fields fails). Is there a quick and easy way to > find and delete the dupes (there are tens of thousands of

[GENERAL] Upgrade instructions ->7.4.8/8.0.3 incomplete regarding tsearch2

Hello! I am currently trying to import a 8.0.1 database dump into a 8.0.3 installation. I, too, have at first stumbled over the tsearch2-issue which is explained here: http://www.postgresql.org/docs/8.0/static/release-7-4-8.html (should make a rule to thoroughly read the upgrade notes first :) )

[GENERAL] Using gdb to obtain statement

Hello! As pg_stat_activity.current_query truncates statements to about 255 characters, I've tinkered a bit with gdb, as suggested by Tom Lane a little while ago. But when I attach to the backend in question, the only output I get from p debug_query_string is some number, for example: mysrv:/var/l

Re: [GENERAL] Problems with pgcrypto and special characters

Hi! -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] > Possibly a binary cast (WITHOUT FUNCTION) would solve your problem, > though I doubt it will work well on bytea values containing \0. Thanks, I've been a bit thick here, but I just found the solution to my problem - and

Re: [GENERAL] Problems with pgcrypto and special characters

Hi! -Original Message- From: Ragnar Hafstað [mailto:[EMAIL PROTECTED] >are you sure your problem is with pg_crypto ? >what does this produce: > select bytea2text('Tübingen'::bytea) as foo; >? Well I'm sure it's not WITH pgcrypto but with actually using pgcrypto in conjunction with U

[GENERAL] Problems with pgcrypto and special characters

Hello! To get straight to the point, here's my problem: mypgdb=# select bytea2text(decrypt(encrypt('Tübingen'::bytea, 'mypassphrase'::bytea,'bf'::text),'mypassphrase'::bytea,'bf'::text)) as foo; foo - T\303\274bingen (1 row) I have compiled and installed pg_crypto and I

pgsql-general@postgresql.org

Hi! Thanks, I'll try Slony-I next time - I currently lack the time to test it beforehand on my non-production system; I'd be a bit worried about the additional load a second PG-instance as replication slave would impose on the machine, so at the moment I'm more confident going along the same tr

pgsql-general@postgresql.org

al Message- From: Magnus Hagander [mailto:[EMAIL PROTECTED] Sent: Mon 2/21/2005 13:04 To: Markus Wollny; pgsql-general@postgresql.org Cc: Subject:RE: [GENERAL] Ways to speed up dump&reload > Hello! > > Finally the time has come for us to upgrade our PostgreSQL &

pgsql-general@postgresql.org

sources to just this task. Kind regards Markus -Original Message- From: Oleg Bartunov [mailto:[EMAIL PROTECTED] Sent: Mon 2/21/2005 11:15 To: Markus Wollny Cc: pgsql-general@postgresql.org Subject:Re: [GENERAL] Ways to speed up dump&reload Markus, have you

pgsql-general@postgresql.org

Hello! Finally the time has come for us to upgrade our PostgreSQL 7.4.5-servers to 8.0.1 - and though I'm very much looking forward to some of the new features, the dump&reload process is worrying me a bit this time. I've got one cluster in particular which is roughly 9GB in size and features s

Re: [GENERAL] High volume inserts - more disks or more CPUs?

Hi! > -Ursprüngliche Nachricht- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im Auftrag von > Guy Rouillier > Gesendet: Montag, 13. Dezember 2004 07:17 > An: PostgreSQL General > Betreff: [GENERAL] High volume inserts - more disks or more CPUs? > (1) Would we be better off with

Re: [GENERAL] How can I recovery old Data from files and folders on windows?

Hi! You can't. You'll have to restore your erroneous version first, then dump your data, the reinstall and use restore to restore the data you want. Kind regards Markus > -Ursprüngliche Nachricht- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im Auftrag von > Premsun Cholt

Re: [GENERAL] why use SCHEMA? any real-world examples?

Hi! It's really just a convenience-thing to organize your data in a more intuitive way. We're running several online magazines, each of those with a sort of "entity-database", but each with their own articles. So we've just put the entity-data in the public schema, whereas the magazine-specific

Re: [GENERAL] Tsearch2 and Unicode?

Hi! I dug through my list-archives - I actually used to have the very same problem that you described: special chars being swallowed by tsearch2-functions. The source of the problem was that I had INITDB'ed my cluster with [EMAIL PROTECTED] as locale, whereas my databases used Unicode encoding

Re: [GENERAL] Tsearch2 and Unicode?

Hi! Hi! Oleg, what exactly do you mean by "tsearch2 doesn't support unicode yet"? It does seem to work fine in my database, it seems: ./pg_controldata [mycluster] gives me pg_control version number:72 [...] LC_COLLATE: de_DE.UTF-8 LC_CTYPE:

Re: [GENERAL] Can this be indexed?

PostgreSQL doesn't provide pre-configured support for materialized views as such, but using some PL/pgSQL and triggers, one can easily implement any kind of materialized view as seen fit for the specific intended purpose (Snapshot, Eager, Lazy, Very Lazy). You may find an excellent tutorial on

Re: [OpenFTS-general] AW: [GENERAL] tsearch2, ispell, utf-8 and german special characters

hus making any search containing 'ein' a little bit fuzzier, but nonetheless still usable. It's still some sort of cosmetic bug, though, but I guess that's probably due to German being somewhat less IT-friendly than english. Kind regards Markus -Original Message-

Re: [OpenFTS-general] AW: [GENERAL] tsearch2, ispell, utf-8 and german special characters

Hi! > -Ursprüngliche Nachricht- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im > Auftrag von Markus Wollny > Gesendet: Mittwoch, 21. Juli 2004 17:04 > An: Oleg Bartunov > Cc: [EMAIL PROTECTED]; > [EMAIL PROTECTED] > Betreff: [OpenFTS-general] AW:

Re: [GENERAL] tsearch2, ispell, utf-8 and german special characters

your help! Kind regards Markus > -----Ursprüngliche Nachricht- > Von: Oleg Bartunov [mailto:[EMAIL PROTECTED] > Gesendet: Mittwoch, 21. Juli 2004 15:34 > An: Markus Wollny > Cc: [EMAIL PROTECTED]; > [EMAIL PROTECTED] > Betreff: Re: [GENERAL] tsearch2, ispell, utf-8 and

Re: [GENERAL] tsearch2, ispell, utf-8 and german special characters

#x27;s only this one dictionary configured for ts_name default_german and tok_alias lhword, lpard_hword, lword (the remaining tog_alias entries are set to use the simple dictionary). Kind regards Markus > -Ursprüngliche Nachricht- > Von: Peter Eisentraut [mailto:[EMAIL PROTECTED

Re: [GENERAL] ./configure --with-java fails

> -Ursprüngliche Nachricht- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im Auftrag von Kris Jurka > Gesendet: Dienstag, 6. Juli 2004 13:11 > An: Markus Wollny > Cc: [EMAIL PROTECTED] > Betreff: Re: [GENERAL] ./configure --with-java fails > Your setup look

[GENERAL] ./configure --with-java fails

Hi!   I am trying to build PostgreSQL 7.4.3 with Java enabled; I've got Apache Ant version 1.5 and j2sdk1.4.1_05 installed:   Verifiying ant: # which javac/usr/java/j2sdk1.4.1_05/bin/javac# ant -versionApache Ant version 1.5 compiled on October 15 2002 Verifying java-compiler:  # which ja

[GENERAL] Character Encoding Confusion

Hi! We've been using PostgreSQL (currently 7.4) via ODBC with ColdFusion until now and didn't experience any problems. But now we want to move from ColdFusion 4.5 to ColdFusion MX, thus abandoning ODBC and migrating to JDBC. As ODBC seems to be blissfully unaware of any character encodings whatso

[GENERAL] Cron-job for checking up on pg_autovacuum

Hi! I haven't found anything in terms of startup- and check-scripts for pg_autovacuum yet; usually I like to have some sort of mechanism to check if some daemon is running and restart it if it isn't. Of course this sort of script shouldn't be too much of a bother for more experienced users; howev

[GENERAL] configure --with-java fails

Hello! When I try to run ./configure --with-java, it complains that ant doesn't work. However ant is installed, as is the latest Java SDK 1.4.2 from sun, PATH and JAVA_HOME are set correctly; helles:/ # /usr/java/apache-ant-1.5.4/bin/ant -version Apache Ant version 1.5.4 compiled

Re: [GENERAL] tsearch2 column update produces "word too long"error

mess in a production environment. Is there a way to get around this problem with oversized words? Kind regards Markus > -Ursprüngliche Nachricht- > Von: Oleg Bartunov [mailto:[EMAIL PROTECTED] > Gesendet: Freitag, 21. November 2003 15:13 > An: Markus Wollny > Cc: [

Re: [GENERAL] tsearch2 column update produces "word too long" error

Hello! > Von: Oleg Bartunov [mailto:[EMAIL PROTECTED] > Gesendet: Freitag, 21. November 2003 13:06 > An: Markus Wollny > Cc: [EMAIL PROTECTED] > > Word length is limited by 2K. What's exactly the word > tsearch2 complained on ? > 'Llanfairpwllgwyngyllgoge

[GENERAL] tsearch2 column update produces "word too long" error

Hello! I'm currently testing deployment of tsearch2 on our forum table. The table is huge in itself - some 2GB of data without the indexes. I have got PostgreSQL 7.4RC2 running on a test machine, installed tsearch2 to my database, added the new column to the table and tried to update it in the rec

Re: [GENERAL] More Praise for 7.4RC2

Hello! > You can use the oid2name program in the contrib directory to kinda > research which files are big under those trees and see if > it's a table or > index growth problem. I found it a tedious operation, if you want to keep a check on growth of your databases regularly. So I wrote a l

Re: [GENERAL] pg7.3.4: pg_atoi: zero-length string

> -Ursprüngliche Nachricht- > Von: Andrew Sullivan [mailto:[EMAIL PROTECTED] > Gesendet: Dienstag, 4. November 2003 12:32 > An: [EMAIL PROTECTED] > Betreff: Re: [GENERAL] pg7.3.4: pg_atoi: zero-length string > > > On Tue, Nov 04, 2003 at 11:21:35AM +, Rob Fielding wrote: > > We're cur

Re: [GENERAL] Recomended FS

> Theory vs. real life. In Theory, RAID5 is faster because less > data have > to be written to disk. But it's true, many RAID5 controllers > don't have > enough CPU power. I think it might not be just CPU-power of the controller. For RAID0+1 you just have two disc-I/O per write-access: writing t

Re: [GENERAL] Recomended FS

Hi! > -Ursprüngliche Nachricht- > Von: Shridhar Daithankar [mailto:[EMAIL PROTECTED] > Gesendet: Dienstag, 21. Oktober 2003 08:08 > An: [EMAIL PROTECTED] > Betreff: Re: [GENERAL] Recomended FS > Can you compare ogbench results for the RAID and single IDE > disks? It would be > great if