Re: [GENERAL] Replacement for Oracle Text

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,

Re: [GENERAL] Replacement for Oracle Text

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

Re: [GENERAL] Replacement for Oracle Text

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

Re: [GENERAL] Replacement for Oracle Text

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 >>

Re: [GENERAL] Monitoring and insight into NOTIFY queue

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

Re: [GENERAL] Replacement for Oracle Text

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

Re: [GENERAL] Charlotte Postgres User Group

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

Re: [GENERAL] Live steraming replication setup issue!

Below is recovery.conf on slave #--- # STANDBY SERVER PARAMETERS #--- # # standby_mode # # When standby_mode is enabled, the PostgreSQL server will work

Re: [GENERAL] Live steraming replication setup issue!

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?

Re: [GENERAL] Monitoring and insight into NOTIFY queue

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

Re: [GENERAL] Monitoring and insight into NOTIFY queue

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

Re: [GENERAL] Monitoring and insight into NOTIFY queue

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

Re: [GENERAL] Replacement for Oracle Text

>> >> 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

[GENERAL] Monitoring and insight into NOTIFY queue

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

Re: [GENERAL] Replacement for Oracle Text

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 >

Re: [GENERAL] Replacement for Oracle Text

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

Re: [GENERAL] Replacement for Oracle Text

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/ >

Re: [GENERAL] Replacement for Oracle Text

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+) ? > >

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

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

Re: [GENERAL] Replacement for Oracle Text

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

Re: [GENERAL] Replacement for Oracle Text

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

Re: [GENERAL] Replacement for Oracle Text

>>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

Re: [GENERAL] Replacement for Oracle Text

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):

[GENERAL] Replacement for Oracle Text

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?

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 > >

Re: [GENERAL] Multiple databases and shared_buffers

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