[GENERAL] Spelling dictionaries

2017-11-10 Thread hmidi slim
Hi, I'm using Full Text search and I'm interested on using spelling dictionary. I found a website that has a special functionality, for example when I enter the word 'activities' it gives me the suggestions containing this word. But when I enter the word 'activityns' it returns 'No result for 'acti

Re: [GENERAL] Spelling dictionaries

2017-11-10 Thread Arthur Zakirov
On Fri, Nov 10, 2017 at 10:16:06AM +0100, hmidi slim wrote: > Hi, > I'm using Full Text search and I'm interested on using spelling dictionary. > I found a website that has a special functionality, for example when I > enter the word 'activities' it gives me the suggestions containing this > word.

[GENERAL] Client Authentication methods

2017-11-10 Thread chiru r
Hi All, I am trying to understand the Authentication method in pg_hba.conf file (password & md5) in PostgreSQL database server. I am assuming that the user provides the connection string host/usser/password,then client will go and contact the DB server pg_hba.conf file in memory without carrying

Re: [GENERAL] Client Authentication methods

2017-11-10 Thread Berend Tober
chiru r wrote: Hi All, I am trying to understand the Authentication method in pg_hba.conf file (password & md5) in PostgreSQL database server. I am assuming that the user provides the connection string host/usser/password,then client will go and contact the DB server pg_hba.conf file in memo

Re: [GENERAL] Spelling dictionaries

2017-11-10 Thread hmidi slim
What about pg_similarity https://github.com/eulerto/pg_similarity. Do you have any idea about this? 2017-11-10 10:36 GMT+01:00 Arthur Zakirov : > On Fri, Nov 10, 2017 at 10:16:06AM +0100, hmidi slim wrote: > > Hi, > > I'm using Full Text search and I'm interested on using spelling > dictionary. >

Re: [GENERAL] Client Authentication methods

2017-11-10 Thread Peter J. Holzer
On 2017-11-10 08:25:24 -0500, chiru r wrote: > I am trying to understand the Authentication method in pg_hba.conf file > (password & md5) in PostgreSQL database server.  > > I am assuming that the user provides the  connection string host/usser/ > password,then client will go and contact the DB se

[GENERAL] archive_command not being executed

2017-11-10 Thread Eric D
I have a standby db server (SB1) that will soon become the master. SB1 is set up with streaming replication from the current master. I'm trying to set up a third server (SB2) as a slave/standby to SB1, so that when SB1 becomes the master, there will be a standby for it. First step is to get W

Re: [GENERAL] archive_command not being executed

2017-11-10 Thread Paul Jungwirth
On 11/10/2017 09:10 AM, Eric D wrote: I have a standby db server (SB1) that will soon become the master. SB1 is set up with streaming replication from the current master. I'm trying to set up a third server (SB2) as a slave/standby to SB1, so that when SB1 becomes the master, there will be a st

[GENERAL] Postgres 10.1 fails to start: server did not start in time

2017-11-10 Thread Adam Brusselback
Hey all, I am in the process of upgrading to Postgres 10, and am having trouble getting my streaming replica working. OS: Debian 9.2 Version: 10.1 I have my primary backed up using pgbackrest, and I restore that to my replica. It generates a recovery.conf which has a restore command for the WAL

Re: [GENERAL] Postgres 10.1 fails to start: server did not start in time

2017-11-10 Thread Tom Lane
Adam Brusselback writes: > I am in the process of upgrading to Postgres 10, and am having trouble > getting my streaming replica working. > OS: Debian 9.2 > Version: 10.1 > I have my primary backed up using pgbackrest, and I restore that to my > replica. It generates a recovery.conf which has a r

Re: [GENERAL] Postgres 10.1 fails to start: server did not start in time

2017-11-10 Thread Adam Brusselback
> You might want to increase pg_ctl's wait timeout for this situation, > since the default's evidently too little. However ... Got it, thanks. > ... pg_ctl itself wouldn't decide to forcibly shut down the server > if the timeout expired. It merely stops waiting and tells you so. > It seems like

Re: [GENERAL] Postgres 10.1 fails to start: server did not start in time

2017-11-10 Thread Joe Conway
On 11/10/2017 01:01 PM, Adam Brusselback wrote: >> You might want to increase pg_ctl's wait timeout for this situation, >> since the default's evidently too little. However ... > Got it, thanks. > >> ... pg_ctl itself wouldn't decide to forcibly shut down the server >> if the timeout expired. It

Re: [GENERAL] Postgres 10.1 fails to start: server did not start in time

2017-11-10 Thread Tom Lane
Adam Brusselback writes: >> You might want to increase pg_ctl's wait timeout for this situation, >> since the default's evidently too little. However ... > Got it, thanks. >> ... pg_ctl itself wouldn't decide to forcibly shut down the server >> if the timeout expired. It merely stops waiting a

Re: [GENERAL] Because PostgreSQL is compiling in old versions of OS?

2017-11-10 Thread DrakoRod
Oh!! Jose Maria TJ wrote > You're wrong, that are gcc versions, not OS versions. > > For example in my CentOS 6 Box > > cat /etc/redhat-release > CentOS release 6.9 (Final) > > gcc -v > [...trimmed...] > gcc versión 4.4.7 20120313 (Red Hat 4.4.7-18) (GCC) You're right!. Is the GGC version, n