Re: [GENERAL] Replacement for Oracle Text

[Stephen Davies]

On 20/02/16 16:21, Chris Travers wrote:

A more general way would be to have a function which takes a pdf in and
returns the text.  Mark it immutable.

Then you can index the output of converting that text to a tsvector.

You may want to pull everything into a tsvector column for ease of review, but
functional indexes also make that less important

On Sat, Feb 20, 2016 at 1:10 AM, Stephen Davies > wrote:

On 20/02/16 00:24, Bruce Momjian wrote:

On Fri, Feb 19, 2016 at 02:49:16PM +0100, s d wrote:

On 19 February 2016 at 14:19, Bruce Momjian > wrote:
  > Ah, no. That's not possible
  >
  >
  > ...not possible, Yet.
  >
  > PostgreSQL grows by adding the features people need and
its changing
  rapidly.

  I wonder if PLPerl could be used to extract the words from a 
PDF
  document and create a tsvector column from it.

   I don't know about PLPerl(I'm pretty sure it could be used for
this purpose,
though.).  On the other hand I've written code for this in Python
which should
be easy to adapt for PLPython, if necessary.


Right, so you would write a PL/Perl or PL/Python trigger function that
would populate the tsvector column on every INSERT or UPDATE.

FWIW, I just use pdftotext in my CGI.

--

=
Stephen Davies Consulting P/L Phone: 08-8177 
1595
Adelaide, South Australia.Mobile:040 304 
0583



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




--
Best Wishes,
Chris Travers

Efficito:  Hosted Accounting and ERP.  Robust and Flexible.  No vendor lock-in.
http://www.efficito.com/learn_more


I reckon my approach is simpler and easier (given web-based data entry).
I get all the meta data plus the PDF BLOB in one HTML request, get out the 
text and do the insert and all indexing including the tsvector in one PG request.
It also makes is easier to handle BLOB types other than PDF in the same CGI 
script as I just include the extracted text in the PG request.
There are readily callable text extraction utilities similar to pdftotext for 
all BLOB types that I see.


With a function, I would have to have separate functions or an extra BLOB-type 
parameter to the function and separate extraction logic in the function.



--
=
Stephen Davies Consulting P/L Phone: 08-8177 1595
Adelaide, South Australia.Mobile:040 304 0583


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Replacement for Oracle Text

[Chris Travers]

A more general way would be to have a function which takes a pdf in and
returns the text.  Mark it immutable.

Then you can index the output of converting that text to a tsvector.

You may want to pull everything into a tsvector column for ease of review,
but functional indexes also make that less important

On Sat, Feb 20, 2016 at 1:10 AM, Stephen Davies  wrote:

> On 20/02/16 00:24, Bruce Momjian wrote:
>
>> On Fri, Feb 19, 2016 at 02:49:16PM +0100, s d wrote:
>>
>>> On 19 February 2016 at 14:19, Bruce Momjian  wrote:
>>>  > Ah, no. That's not possible
>>>  >
>>>  >
>>>  > ...not possible, Yet.
>>>  >
>>>  > PostgreSQL grows by adding the features people need and its
>>> changing
>>>  rapidly.
>>>
>>>  I wonder if PLPerl could be used to extract the words from a PDF
>>>  document and create a tsvector column from it.
>>>
>>>   I don't know about PLPerl(I'm pretty sure it could be used for this
>>> purpose,
>>> though.).  On the other hand I've written code for this in Python which
>>> should
>>> be easy to adapt for PLPython, if necessary.
>>>
>>
>> Right, so you would write a PL/Perl or PL/Python trigger function that
>> would populate the tsvector column on every INSERT or UPDATE.
>>
>> FWIW, I just use pdftotext in my CGI.
>
> --
>
> =
> Stephen Davies Consulting P/L Phone: 08-8177
> 1595
> Adelaide, South Australia.Mobile:040 304
> 0583
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>



-- 
Best Wishes,
Chris Travers

Efficito:  Hosted Accounting and ERP.  Robust and Flexible.  No vendor
lock-in.
http://www.efficito.com/learn_more

Re: [GENERAL] Replacement for Oracle Text

[Stephen Davies]

On 20/02/16 00:24, Bruce Momjian wrote:

On Fri, Feb 19, 2016 at 02:49:16PM +0100, s d wrote:

On 19 February 2016 at 14:19, Bruce Momjian  wrote:
 > Ah, no. That's not possible
 >
 >
 > ...not possible, Yet.
 >
 > PostgreSQL grows by adding the features people need and its changing
 rapidly.

 I wonder if PLPerl could be used to extract the words from a PDF
 document and create a tsvector column from it.

  I don't know about PLPerl(I'm pretty sure it could be used for this purpose,
though.).  On the other hand I've written code for this in Python which should
be easy to adapt for PLPython, if necessary.


Right, so you would write a PL/Perl or PL/Python trigger function that
would populate the tsvector column on every INSERT or UPDATE.


FWIW, I just use pdftotext in my CGI.

--
=
Stephen Davies Consulting P/L Phone: 08-8177 1595
Adelaide, South Australia.Mobile:040 304 0583


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Replacement for Oracle Text

[Oleg Bartunov]

On Fri, Feb 19, 2016 at 8:28 PM, Josh berkus  wrote:

> On 02/19/2016 05:49 AM, s d wrote:
>
>> On 19 February 2016 at 14:19, Bruce Momjian > > wrote:
>>
>> I wonder if PLPerl could be used to extract the words from a PDF
>> document and create a tsvector column from it.
>>
>>
>>   I don't know about PLPerl(I'm pretty sure it could be used for this
>> purpose, though.).  On the other hand I've written code for this in
>> Python which should be easy to adapt for PLPython, if necessary.
>>
>
> I'd swear someone already built something to do this.  All you need is a
> library which reads PDF and transforms it into text, and then you can FTS
> it.  I know there's a module for OpenOffice docs somewhere as well, but
> heck if I can remember where.
>

I used pdftotext for that.
I think it'd be useful to have extension{s}, which can be used to convert
anything to text. I remember someone indexed chemical formulae,  TeX/LaTeX,
DOC files.


>
> --
> --
> Josh Berkus
> Red Hat OSAS
> (any opinions are my own)
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

Re: [GENERAL] Monitoring and insight into NOTIFY queue

[Jeff Janes]

On Fri, Feb 19, 2016 at 6:01 AM, Jiří Hlinka  wrote:
> Hello,
>
> I'd like to ask you whether there is a way how to monitor and log details
> about NOTIFY queue? What do you use for this prupose?
>
> In the official documentation I'm unable to find a way how to monitor NOTIFY
> queue in more detail, at least size of this queue, which is critical in case
> of filling up the queue, which will lead to stopping the NOTIFY queue
> functionality.


It won't help you now, but version 9.6 will introduce a new function
that should help:


Date:   Fri Jul 17 09:12:03 2015 -0400

Add new function pg_notification_queue_usage.

This tells you what fraction of NOTIFY's queue is currently filled.


Cheers,

Jeff


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Replacement for Oracle Text

[Josh berkus]

On 02/19/2016 05:49 AM, s d wrote:

On 19 February 2016 at 14:19, Bruce Momjian > wrote:

I wonder if PLPerl could be used to extract the words from a PDF
document and create a tsvector column from it.


  I don't know about PLPerl(I'm pretty sure it could be used for this
purpose, though.).  On the other hand I've written code for this in
Python which should be easy to adapt for PLPython, if necessary.


I'd swear someone already built something to do this.  All you need is a 
library which reads PDF and transforms it into text, and then you can 
FTS it.  I know there's a module for OpenOffice docs somewhere as well, 
but heck if I can remember where.


--
--
Josh Berkus
Red Hat OSAS
(any opinions are my own)


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Charlotte Postgres User Group

[Don Parris]

Definitely putting this on my calendar.  I have not been aware of other
PostgreSQL users here - would love to meet some other users.

Don

On Wed, Feb 17, 2016 at 10:39 AM, Boyan Botev  wrote:

> If you live near or around Charlotte, please join us for the inaugural
> meeting of the Charlotte PUG on March 1, followed by a second meeting on
> April 11 featuring Bruce Momjian. More information about the two events can
> be found here:
>
> http://www.meetup.com/Charlotte-PostgreSQL-User-Group
>
> Also if you are travelling through Charlotte, NC or you just like to visit
> the "Queen City" you are welcome to stop by an give a talk to the Charlotte
> PUG. Just contact me when you would be in town and I can pencil you in for
> a talk or a presentation.
>
> Thanks,
> Boyan Botev
>



-- 
D.C. Parris, FMP, Linux+, ESL Certificate
Minister, Security/FM Coordinator, Free Software Advocate
http://dcparris.net/ 

GPG Key ID: F5E179BE

Re: [GENERAL] Live steraming replication setup issue!

[Ashish Chauhan]

Below is recovery.conf on slave

#---
# STANDBY SERVER PARAMETERS
#---
#
# standby_mode
#
# When standby_mode is enabled, the PostgreSQL server will work as a
# standby. It will continuously wait for the additional XLOG records, using
# restore_command and/or primary_conninfo.
#
standby_mode = 'on'
#
# primary_conninfo
#
# If set, the PostgreSQL server will try to connect to the primary using this
# connection string and receive XLOG records continuously.
#
primary_conninfo = 'host= port=5432'
#
#
# By default, a standby server keeps restoring XLOG records from the
# primary indefinitely. If you want to stop the standby mode, finish recovery
# and open the system in read/write mode, specify path to a trigger file.
# The server will poll the trigger file path periodically and start as a
# primary server when it's found.
#
trigger_file = '/data/main/primary.trigger'

Thanks,
Ashish


-Original Message-
From: Andreas Kretschmer [mailto:andr...@a-kretschmer.de] 
Sent: Thursday, February 18, 2016 5:11 PM, 17:11
To: Ashish Chauhan; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Live steraming replication setup issue!


> Currently we have master -> slave -> DR hot standby streaming 
> replication in current prod environment. Between master and slave 
> server replication running fine. Between slave and DR server 
> replication is broken and I am trying to fix it. For DR server, slave server 
> is master server.
> 
> Issue: Few days back, DR was lagging behind slave server and stopped 
> replication. I tried to setup the replication from slave to DR 
> (currently there is replication running from master to slave) with 
> pg_basebackup command, I am able to restart Postgres without any error 
> on DR server but when I try to run any psql on DR, it throwing up below error.
> 
> psql: FATAL:  the database system is starting up



please show us your recovery.conf. this should include this line:

standby_mode  = 'on'


--
Andreas Kretschmer
http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Live steraming replication setup issue!

[Ashish Chauhan]

I am using Postgres 9.4.

I removed /etc/Postgres/9.4/main directory from DR server and fetching data 
through below pg_basebackup command but no luck.

sudo -u postgres pg_basebackup -h  -D 
/var/lib/postgresql/9.4/main -U postgres -v –P

Do I need to enable these two parameters in slave server? archive_mode = on and 
archive_command = some command?

Biggest issue is, replication running between master and slave and I need to 
build DR from slave server.

Thanks,
Ashish

From: Venkata Balaji N [mailto:nag1...@gmail.com]
Sent: Thursday, February 18, 2016 3:45 PM, 15:45
To: Ashish Chauhan
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Live steraming replication setup issue!

How do I setup replication between DR server and slave server while slave 
server and master server are running? I cannot stop master server. Can someone 
please guide with steps?


Steps are pretty much similar. You can setup replication between slave and DR 
by using the backup of Master database + WAL archives (if available) and setup 
primary_conninfo to point to slave database in recovery.conf on DR.
Can you please let us know which version of postgresql you are using ? Thats 
important for us to make any suggestions.

Regards,
Venkata B N

Fujitsu Australia

Re: [GENERAL] Monitoring and insight into NOTIFY queue

[Adrian Klaver]

On 02/19/2016 06:01 AM, Jiří Hlinka wrote:

Hello,

I'd like to ask you whether there is a way how to monitor and log
details about NOTIFY queue? What do you use for this prupose?

In the official documentation I'm unable to find a way how to monitor
NOTIFY queue in more detail, at least size of this queue, which is
critical in case of filling up the queue, which will lead to stopping
the NOTIFY queue functionality.


Should have added from:

http://www.postgresql.org/docs/9.5/interactive/sql-notify.html

"Once the queue is half full you will see warnings in the log file 
pointing you to the session that is preventing cleanup. In this case you 
should make sure that this session ends its current transaction so that 
cleanup can proceed"


Where the message is of form(from async.c):

(errmsg("NOTIFY queue is %.0f%% full", fillDegree * 100),
 (minPid != InvalidPid ?
  errdetail("The server process with 
PID %d is among those with the oldest transactions.", minPid)

  : 0),
 (minPid != InvalidPid ?
  errhint("The NOTIFY queue cannot be 
emptied until that process ends its current transaction.")

  : 0)));




Thanks,
Jiri



--
Adrian Klaver
adrian.kla...@aklaver.com


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Monitoring and insight into NOTIFY queue

[Adrian Klaver]

On 02/19/2016 06:01 AM, Jiří Hlinka wrote:

Hello,

I'd like to ask you whether there is a way how to monitor and log
details about NOTIFY queue? What do you use for this prupose?

In the official documentation I'm unable to find a way how to monitor
NOTIFY queue in more detail, at least size of this queue, which is
critical in case of filling up the queue, which will lead to stopping
the NOTIFY queue functionality.


Well from here:

http://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/backend/commands/async.c;h=beef574076c257db0a868b39a946565185f6c53e;hb=refs/heads/REL9_5_STABLE

"There is one central queue in disk-based storage (directory pg_notify/),
with actively-used pages mapped into shared memory by the slru.c module.
All notification messages are placed in the queue and later read out
by listening backends."


and from here:

http://www.postgresql.org/docs/9.5/interactive/sql-notify.html

"The queue is quite large (8GB in a standard installation) ..."


I could see setting up file monitoring in pg_notify/ of the queue file size.



Thanks,
Jiri



--
Adrian Klaver
adrian.kla...@aklaver.com


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Monitoring and insight into NOTIFY queue

[Merlin Moncure]

On Fri, Feb 19, 2016 at 8:01 AM, Jiří Hlinka  wrote:
> Hello,
>
> I'd like to ask you whether there is a way how to monitor and log details
> about NOTIFY queue? What do you use for this prupose?
>
> In the official documentation I'm unable to find a way how to monitor NOTIFY
> queue in more detail, at least size of this queue, which is critical in case
> of filling up the queue, which will lead to stopping the NOTIFY queue
> functionality.

It used to be possible to do this with the (slow, locky) table based
notification mechanism.  Unfortunately FWICT it isn't now and we
really ought to expand functionality in that area.

I will say though that async notification should thought of as 'best
effort'...if you are laying essential communication processes on top
of it you need to have the listener respond and be prepare to retry.
Another thing, queue size paranoia aside (which is a good way to
consider things) I've never had the queue bust on me and I've beat on
it pretty hard.

merlin


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Replacement for Oracle Text

[Daniel Westermann]

>> 
>> I don't know about PLPerl(I'm pretty sure it could be used for this purpose, 
>> though.). On the other hand I've written code for this in Python which 
>> should 
>> be easy to adapt for PLPython, if necessary. 

>Right, so you would write a PL/Perl or PL/Python trigger function that 
>would populate the tsvector column on every INSERT or UPDATE. 

Thanks to all for your input 
Daniel 

[GENERAL] Monitoring and insight into NOTIFY queue

[Jiří Hlinka]

Hello,

I'd like to ask you whether there is a way how to monitor and log details
about NOTIFY queue? What do you use for this prupose?

In the official documentation I'm unable to find a way how to monitor
NOTIFY queue in more detail, at least size of this queue, which is critical
in case of filling up the queue, which will lead to stopping the NOTIFY
queue functionality.

Thanks,
Jiri

Re: [GENERAL] Replacement for Oracle Text

[Bruce Momjian]

On Fri, Feb 19, 2016 at 02:49:16PM +0100, s d wrote:
> On 19 February 2016 at 14:19, Bruce Momjian  wrote:
> >     Ah, no. That's not possible
> >
> >
> > ...not possible, Yet.
> >
> > PostgreSQL grows by adding the features people need and its changing
> rapidly. 
> 
> I wonder if PLPerl could be used to extract the words from a PDF
> document and create a tsvector column from it.
> 
>  I don't know about PLPerl(I'm pretty sure it could be used for this purpose,
> though.).  On the other hand I've written code for this in Python which should
> be easy to adapt for PLPython, if necessary.

Right, so you would write a PL/Perl or PL/Python trigger function that
would populate the tsvector column on every INSERT or UPDATE.

-- 
  Bruce Momjian  http://momjian.us
  EnterpriseDB http://enterprisedb.com

+ As you are, so once was I. As I am, so you will be. +
+ Roman grave inscription +


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Replacement for Oracle Text

[s d]

On 19 February 2016 at 14:19, Bruce Momjian  wrote:

> On Fri, Feb 19, 2016 at 11:53:26AM +, Simon Riggs wrote:
> > On 19 February 2016 at 11:46, Thomas Kellerer 
> wrote:
> >
> > Daniel Westermann schrieb am 19.02.2016 um 12:41:
> >  if I'd need to implement/replace Oracle Text (ww.oracle.com/
> > technetwork/testcontent/index-098492.html).
> > > What choices do I have in PostgreSQL (9.5+) ?
> > >
> > >>Postgres also has a full text search (which I find much easier to
> use
> > than Oracle's):
> > >>
> > >>http://www.postgresql.org/docs/current/static/textsearch.html
> > >
> > > Yes, i have seen this. Can this be used to index and search binary
> > documents, e.g. pdf ?
> >
> > Ah, no. That's not possible
> >
> >
> > ...not possible, Yet.
> >
> > PostgreSQL grows by adding the features people need and its changing
> rapidly.
>
> I wonder if PLPerl could be used to extract the words from a PDF
> document and create a tsvector column from it.
>
>
 I don't know about PLPerl(I'm pretty sure it could be used for this
purpose, though.).  On the other hand I've written code for this in Python
which should be easy to adapt for PLPython, if necessary.



Ezt az e-mailt egy Avast védelemmel rendelkező, vírusmentes számítógépről
küldték.
www.avast.com 
<#DDB4FAA8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Re: [GENERAL] Replacement for Oracle Text

[Bruce Momjian]

On Fri, Feb 19, 2016 at 11:53:26AM +, Simon Riggs wrote:
> On 19 February 2016 at 11:46, Thomas Kellerer  wrote:
> 
> Daniel Westermann schrieb am 19.02.2016 um 12:41:
>  if I'd need to implement/replace Oracle Text (ww.oracle.com/
> technetwork/testcontent/index-098492.html).
> > What choices do I have in PostgreSQL (9.5+) ?
> >
> >>Postgres also has a full text search (which I find much easier to use
> than Oracle's):
> >>
> >>http://www.postgresql.org/docs/current/static/textsearch.html
> >
> > Yes, i have seen this. Can this be used to index and search binary
> documents, e.g. pdf ?
> 
> Ah, no. That's not possible
> 
> 
> ...not possible, Yet.
> 
> PostgreSQL grows by adding the features people need and its changing rapidly. 

I wonder if PLPerl could be used to extract the words from a PDF
document and create a tsvector column from it.

-- 
  Bruce Momjian  http://momjian.us
  EnterpriseDB http://enterprisedb.com

+ As you are, so once was I. As I am, so you will be. +
+ Roman grave inscription +


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Replacement for Oracle Text

[Simon Riggs]

On 19 February 2016 at 11:46, Thomas Kellerer  wrote:

> Daniel Westermann schrieb am 19.02.2016 um 12:41:
>  if I'd need to implement/replace Oracle Text (
> ww.oracle.com/technetwork/testcontent/index-098492.html).
> > What choices do I have in PostgreSQL (9.5+) ?
> >
> >>Postgres also has a full text search (which I find much easier to use
> than Oracle's):
> >>
> >>http://www.postgresql.org/docs/current/static/textsearch.html
> >
> > Yes, i have seen this. Can this be used to index and search binary
> documents, e.g. pdf ?
>
> Ah, no. That's not possible


...not possible, Yet.

PostgreSQL grows by adding the features people need and its changing
rapidly.

-- 
Simon Riggshttp://www.2ndQuadrant.com/

PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

[GENERAL] How to analyze locking issues of the startup process on hot standby replica?

[Maxim Boguk]

Hi,

I analyze a strange case with the startup process on replica spend almost
all time in waiting state:
"postgres: startup process   recovering 00014A3E00BF waiting"
As a result recovery seriously lagged behind master (in range of hours).

Replica have hot_standby=on and almost always have some long running (in
range of minutes-ten minutes) select queries.
I expected to find some not granted locks in pg_locks on the standby
server, but select * from pg_locks where not granted; show no results.

Is there any way to look into the startup process and see what it waiting
for (less invasive than gdb).

PS: there are no DDL routinely run on the master (so there no need
accessexclusivelock on standby to apply ddl).

​Kind Regards,
Maksym​

-- 
Maxim Boguk
Senior Postgresql DBA
http://www.postgresql-consulting.com/

Phone RU: +7 910 405 4718
Phone AU: +61 45 218 5678

LinkedIn: http://www.linkedin.com/pub/maksym-boguk/80/b99/b1b
Skype: maxim.boguk
Jabber: maxim.bo...@gmail.com

"People problems are solved with people.
If people cannot solve the problem, try technology.
People will then wish they'd listened at the first stage."

Re: [GENERAL] Replacement for Oracle Text

[Andreas Joseph Krogh]

På fredag 19. februar 2016 kl. 12:41:49, skrev Daniel Westermann <
daniel.westerm...@dbi-services.com >:
>>Daniel Westermann schrieb am 19.02.2016 um 11:53:
>>> if I'd need to implement/replace Oracle Text 
(ww.oracle.com/technetwork/testcontent/index-098492.html).
  What choices do I have in PostgreSQL (9.5+) ?

 >Postgres also has a full text search (which I find much easier to use than 
Oracle's):
 >
 >http://www.postgresql.org/docs/current/static/textsearch.html

 Yes, i have seen this. Can this be used to index and search binary documents, 
e.g. pdf ?

 
What we do is extract plain-text from PFD/Word etc. clientside in the 
application, and then index that in the database.
Works very well.
 
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com 
www.visena.com 
 


 

Re: [GENERAL] Replacement for Oracle Text

[Thomas Kellerer]

Daniel Westermann schrieb am 19.02.2016 um 12:41:
 if I'd need to implement/replace Oracle Text 
 (ww.oracle.com/technetwork/testcontent/index-098492.html). 
> What choices do I have in PostgreSQL (9.5+) ?
> 
>>Postgres also has a full text search (which I find much easier to use than 
>>Oracle's):
>>
>>http://www.postgresql.org/docs/current/static/textsearch.html
> 
> Yes, i have seen this. Can this be used to index and search binary documents, 
> e.g. pdf ?

Ah, no. That's not possible

 



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Replacement for Oracle Text

[Daniel Westermann]

>>Daniel Westermann schrieb am 19.02.2016 um 11:53: 
>>> if I'd need to implement/replace Oracle Text 
>>> (ww.oracle.com/technetwork/testcontent/index-098492.html). 
 What choices do I have in PostgreSQL (9.5+) ? 

>Postgres also has a full text search (which I find much easier to use than 
>Oracle's): 
> 
>http://www.postgresql.org/docs/current/static/textsearch.html 

Yes, i have seen this. Can this be used to index and search binary documents, 
e.g. pdf ? 

Re: [GENERAL] Replacement for Oracle Text

[Thomas Kellerer]

Daniel Westermann schrieb am 19.02.2016 um 11:53:
> if I'd need to implement/replace Oracle Text 
> (ww.oracle.com/technetwork/testcontent/index-098492.html). 
> What choices do I have in PostgreSQL (9.5+) ?


Postgres also has a full text search (which I find much easier to use than 
Oracle's):

http://www.postgresql.org/docs/current/static/textsearch.html




-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Replacement for Oracle Text

[Daniel Westermann]

Hi, 

if I'd need to implement/replace Oracle Text 
(ww.oracle.com/technetwork/testcontent/index-098492.html). What choices do I 
have in PostgreSQL (9.5+) ? 

Regards 
Daniel 

Re: [GENERAL] sslcompression / PGSSLCOMPRESSION not behaving as documented?

[Shulgin, Oleksandr]

On Thu, Feb 18, 2016 at 11:37 PM, Jeff Janes  wrote:

> On Fri, Jan 16, 2015 at 10:34 AM, Maciek Sakrejda 
> wrote:
> > Thanks, everyone. That seems to be it. I still haven't gotten it to work
> (I
> > tried setting OPENSSL_DEFAULT_ZLIB=true in
> > /etc/postgresql/9.2/main/environment and restarting the server, then
> adding
> > the same env var when connecting with the client), but now that I know
> where
> > the problem is, I think I can work through it.
>
> Did you ever get it to work on Ubuntu?  If so, what did you have to do?
>
> OPENSSL_DEFAULT_ZLIB doesn't seem to do anything on Ubuntu 14.04.  It
> is suggested it should work on earlier versions
> (http://www.ubuntu.com/usn/USN-1898-1/) but there is no mention of it
> on newer versions.
>

I can confirm that this env var has the expected effect on Ubuntu 12.04,
but newer versions such 14.04 come with OpenSSL complied without zlib
altogether, so there is no way to enable this short of recompiling the
openssl lib, unfortunately.

--
Alex

Re: [GENERAL] Multiple databases and shared_buffers

[Karsten Hilbert]

On Thu, Feb 18, 2016 at 05:38:45PM -0500, Melvin Davidson wrote:

> From your questions, it appears you are a little weak on PostgreSQL
> Database Administration. I respectfully suggest you obtain a copy of the
> following book to get a clearer understandings of how things work.

The PostgreSQL documentation actually is a great read, too.

Karsten
-- 
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general