[GENERAL] Postgresql version
What version would you recommend to use for a new installation: 8.0.x or 7.4.x TIA ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[GENERAL] XlogFlus error message
I've a problem with my postgresql database Version : 7.2.4 Os: Mandrake Linux release 8.2 Kernel 2.4.20 I get this king of error ERROR: XLogFlush: request 14D/F77EFE94 is not satisfied --- flushed only to 14D/F75CD1B0 ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] XlogFlus error message
I know. I'm working on an upgrade to postgresql 8.0.3 The big deal is to migrate openfts with tsearch V1 to new version. I've tried to use pg_resetxlog, but not successful. The I've tried to reindex the database. Same problem. Now I came back to a normal state with a backup of the database from this morning and launch my synchronization with the master database. I think that the upgrade will be done next week Thanks > -Message d'origine- > De : Tom Lane [mailto:[EMAIL PROTECTED] > Envoyé : mercredi 14 septembre 2005 16:29 > À : philip johnson > Cc : pgsql-general@postgresql.org > Objet : Re: [GENERAL] XlogFlus error message > > "philip johnson" <[EMAIL PROTECTED]> writes: > > I've a problem with my postgresql database > > Version : 7.2.4 > > That's an awfully old version, with a lot of known problems. You should > at least be running 7.2.8, and preferably thinking about an update to a > newer release series. > > > I get this king of error > > ERROR: XLogFlush: request 14D/F77EFE94 is not satisfied --- flushed > only to > > 14D/F75CD1B0 > > Is the error reproducible after restarting the postmaster? If so it may > be something similar to what was reported here: > http://archives.postgresql.org/pgsql-bugs/2005-09/msg00056.php > but we haven't been able to track down the original cause :-( > > regards, tom lane ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[GENERAL] tsearch2 and pdf files
I'm using Postgresql 8.1.5 Tsearch2 is installed and runs well I'd like to use tsearch2 to index PDF files. Do someone has a detailed process to implement that?
Re: [GENERAL] tsearch2 and pdf files
Do you know what kind of table should I use ? Is there a shell script or a php script that does the work ? regards > -Message d'origine- > De : [EMAIL PROTECTED] [mailto:pgsql-general- > [EMAIL PROTECTED] De la part de Hannes Dorbath > Envoyé : lundi 11 décembre 2006 12:21 > À : pgsql-general@postgresql.org > Objet : Re: [GENERAL] tsearch2 and pdf files > > You just need software that extracts the text from it. Search google for > pdf2txt and others. Printer drivers that try to get text from anything > are available as well. > > > On 11.12.2006 11:41, Philip Johnson wrote: > > I'm using Postgresql 8.1.5 > > > > Tsearch2 is installed and runs well > > > > I'd like to use tsearch2 to index PDF files. > > > > Do someone has a detailed process to implement that? > > > -- > Regards, > Hannes Dorbath > > ---(end of broadcast)--- > TIP 5: don't forget to increase your free space map settings ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
Re: [GENERAL] tsearch2 and pdf files
>> 1. Convert PDF to file with e.g xpdf >> 2. Insert parsed text to a table of your choice. >> 3. Make vectors from the text. > > Actually, if you're not going to use the headline() function, you cna > just store it directly in a vector, cutting down on the size > requirements. What size requirements ? > Just insert to the to_tsvector() result. The full text is > required for headline() though, so you can't cheat on that. > > //Magnus > > ---(end of broadcast)--- > TIP 6: explain analyze is your friend > ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
