i added Arabic Dictionary but how I know i'm using it
Greetings Dear I hope you are fine and doing well. I have a created a dictionary in postgres successfully but how may I know that I'm using it? because I'm doing now queries and the results are the same before I created the dictionary I downloaded an rar folder that I supposed its a dictionary i copied a files called th_ar.dat and ar.aff and pasted them in tsearch folder in postgres folder and renamed them as the_ar.dict and th_ar.affix as the documentation in postgres told me https://www.postgresql.org/docs/current/textsearch-dictionaries.html#TEXTSEARCH-ISPELL-DICTIONARY I created the dictionary by this query CREATE TEXT SEARCH DICTIONARY arabic_dict ( TEMPLATE = ispell, DictFile = th_ar, AffFile = th_ar, Stopwords = arabic); and as you know the purpose in dictionary is like when you're searching for an example a "house" the results will also retrieve a records with "home" because it's a synonymous but when I run queries nothing happens so my questions are 1)is there anything I should do before do the query to use the dictionary? 2) is there any chance that I'm doing something wrong ? please mention them? 3) how i know that the dictionary I'm using is correct ? thank you for your efforts my best regards
Re: i added Arabic Dictionary but how I know i'm using it
Hello Dear sorry for the late reply your response helped me to finish the feature successfully thank you for your efforts my best regards On Wed, 17 Aug 2022, 6:59 pm Laurenz Albe, wrote: > On Wed, 2022-08-17 at 14:33 +0300, Mohammed falih wrote: > > I created the dictionary by this query > > CREATE TEXT SEARCH DICTIONARY arabic_dict ( > > TEMPLATE = ispell, > >DictFile = th_ar, > > AffFile = th_ar, > > Stopwords = arabic); > > and as you know the purpose in dictionary is like when you're searching > for an > > example a "house" the results will also retrieve a records with "home" > because > > it's a synonymous but when I run queries nothing happens > > That would be a "synonym dictionary": > > https://www.postgresql.org/docs/current/textsearch-dictionaries.html#TEXTSEARCH-SYNONYM-DICTIONARY > An Ispell dictionary normalizes words, for example by removing suffixes for > plural and case. > > > You'd have to create a synonym file yourself. > > Yours, > Laurenz Albe >
The postgres server don't work
Hello Mr/Mrs I hope you are fine and doing well I have a problem with the postgres server first my operating system is windows 10 pro and my postgres version is 13 this problem i have tried to solve it for more than two weeks and nothing changed lastly I have formatted the laptop and downloaded only PostgreSQL program and it worked well for less than a hour then its server broken the error says in sql shell " could not connect to server: Connection refused (0x274D/10061) Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432?" I changed the port and nothing different yes this problem is happening regularly but with me nothing solved it I tried to go to configuration files (the pg_hba.conf ( I added a line in the last host all all 0.0.0.0/0 md5) and in postgresql.conf file (the listening addresses was already to :"*") also I when I try to start the server from service tab says the postgres service cannot restart it says that "some services stop automatically if they are not in use by other services or programs and when I check it in the event viewer there is an error says "FATAL: XX000: C:\Program Files\PostgreSQL\13\bin\postgres.exe: could not locate matching postgres executable LOCATION: getInstallationPaths, d:\pginstaller_13.auto\postgres.windows-x64\src\backend\postmaster\postmaster.c:1489" and maybe you need to know that after I finish installing the postgre program I haven't installed the stack builder and when I run the sql shell for first time there were a problem says "Console code page (437) differs from Windows code page (1252) 8-bit characters might not work correctly. See psql reference page "Notes for Windows users" and I solved this problem by go to registry editor/HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/command processor and there i have entered a new string value called Autorun and its value is chcp 1252 I hope you’ll help me to fix this problem because I have many tasks I couldn't do because the postgres problem thank you for your efforts my best regards
Re: The postgres server don't work
I mean by broken that when I run psql shell or padding I receive this error " " could not connect to server: Connection refused (0x274D/10061) Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432?" and about the log file , usually this problem happens after my laptop turned off or restart so last line in the log file is "database system is shut down" and no matter how many times I tried by restart the laptop nothing changes the ex files are all in their right location , and I tried both ways in regular running and as administrator and nothing different yes the postgres.exe is exist there and about the console code problem ,yes maybe this error is related to the client but I realized that after I make this solution and make restart to the laptop , the postgres begins to not working ,maybe this was a coincidence I don't know thank you for your efforts On Sat, 8 Jan 2022, 9:45 pm Adrian Klaver, wrote: > On 1/7/22 10:05, Mohammed falih wrote: > > Hello Mr/Mrs > > I hope you are fine and doing well > > I have a problem with the postgres server > > first my operating system is windows 10 pro > > and my postgres version is 13 > > this problem i have tried to solve it for more than two weeks and > > nothing changed > > lastly I have formatted the laptop and downloaded only PostgreSQL > > program and it worked well for less than a hour then its server broken > > Questions and comments inline below. > > Define broken? > > In other words what does the Postgres log show in the period from when > it ran to when it did not? > > > the error says in sql shell " could not connect to server: Connection > > refused (0x274D/10061) > > Is the server running on host "localhost" (::1) and accepting > > TCP/IP connections on port 5432?" > > I changed the port and nothing different > > yes this problem is happening regularly but with me nothing solved it > > The issue is the below where it could not find the executable. Are you > starting the service as an administrator? > > > > > I tried to go to configuration files (the pg_hba.conf ( I added a line > > in the last > > host all all 0.0.0.0/0 <http://0.0.0.0/0> md5) > > and in postgresql.conf file (the listening addresses was already to :"*") > > > > also I when I try to start the server from service tab says > > the postgres service cannot restart > > it says that "some services stop automatically if they are not in use by > > other services or programs > > and when I check it in the event viewer there is an error says > > "FATAL: XX000: C:\Program Files\PostgreSQL\13\bin\postgres.exe: could > > not locate matching postgres executable LOCATION: getInstallationPaths, > > > d:\pginstaller_13.auto\postgres.windows-x64\src\backend\postmaster\postmaster.c:1489" > > Does this path C:\Program Files\PostgreSQL\13\bin\postgres.exe actually > exist? > > > > > and maybe you need to know that after I finish installing the postgre > > program I haven't installed the stack builder and when I run the sql > > shell for first time there were a problem says "Console code page (437) > > differs from Windows code page (1252) > > 8-bit characters might not work correctly. See psql reference > > page "Notes for Windows users" > > This has to do with the psql client not the server. > > > and I solved this problem by go to registry > > editor/HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/command processor > > and there i have entered a new string value called Autorun and its value > > is chcp 1252 > > > > I hope you’ll help me to fix this problem because I have many tasks I > > couldn't do because the postgres problem > > > > thank you for your efforts > > my best regards > > > > > -- > Adrian Klaver > adrian.kla...@aklaver.com >
Re: The postgres server don't work
yes I think the service doesn't even start I have only the default protection that comes with the operating system wow the postgres started working!! but the problem came back that talks about console code " WARNING: Console code page (437) differs from Windows code page (1252) 8-bit characters might not work correctly. See psql reference page "Notes for Windows users" for details." On Sun, 9 Jan 2022, 2:18 am Adrian Klaver, wrote: > On 1/8/22 14:47, Mohammed falih wrote: > > I mean by broken that when I run psql shell or padding I receive this > > error " " could not connect to server: Connection > > refused (0x274D/10061) > > Is the server running on host "localhost" (::1) and accepting > >TCP/IP connections on port 5432?" > > > > and about the log file , usually this problem happens after my laptop > > turned off or restart > > so last line in the log file is "database system is shut down" > > and no matter how many times I tried by restart the laptop nothing > changes > > I am not following '...usually this problem happens after my laptop > turned off or restart...'. This would seem to imply that the service > does start sometimes. Is that the case? > > > > > the ex files are all in their right location , and I tried both ways in > > regular running and as administrator and nothing different > > > > yes the postgres.exe is exist there > > Do you have an Anti-Virus program running on this machine? > > > > > and about the console code problem ,yes maybe this error is related to > > the client but I realized that after I make this solution and make > > restart to the laptop , the postgres begins to not working ,maybe this > > was a coincidence I don't know > > Then undo the changes and see what happens? I sort of doubt it is the > issue though. > > > > > thank you for your efforts > > On Sat, 8 Jan 2022, 9:45 pm Adrian Klaver, > > -- > Adrian Klaver > adrian.kla...@aklaver.com >
Re: The postgres server don't work
thank you for your efforts
I added chcp 1252 line
but when I try to save the changes . an error pop out says "you don't have
the permission to open this file ,see the owner of the file or an
administrator to obtain permission"
even though I went to properties/security/mylaptopaccount and made it full
control
On Sun, 9 Jan 2022, 7:18 am Дмитрий Иванов, wrote:
> Such gross changes should not be made to the registry. You changed the
> settings of the whole system for the needs of one console. This will affect
> many services and console applications.
> You need to find a shortcut in the start menu.
> "C:\ProgramData\Microsoft\Windows\Start Menu\Programs\PostgreSQL 12\SQL
> Shell (psql).lnk"
> By the right click, select "Change" and add to the batch file an
> indication of the need to change the code page, save.
> Here is an example of a standard script:
>
> @echo off
> *chcp 1251*
> REM Copyright (c) 2012-2020, EnterpriseDB Corporation. All rights reserved
> REM PostgreSQL server psql runner script for Windows
>
> SET server=localhost
> SET /P server="Server [%server%]: "
>
> SET database=postgres
> SET /P database="Database [%database%]: "
>
> SET port=5999
> SET /P port="Port [%port%]: "
>
> SET username=postgres
> SET /P username="Username [%username%]: "
>
> for /f "delims=" %%a in ('chcp ^|find /c "932"') do @ SET
> CLIENTENCODING_JP=%%a
> if "%CLIENTENCODING_JP%"=="1" SET PGCLIENTENCODING=SJIS
> if "%CLIENTENCODING_JP%"=="1" SET /P PGCLIENTENCODING="Client Encoding
> [%PGCLIENTENCODING%]: "
>
> REM Run psql
> "C:\Program Files\PostgreSQL\12\bin\psql.exe" -h %server% -U %username% -d
> %database% -p %port%
>
> pause
>
> --
> Regards, Dmitry!
>
>
> вс, 9 янв. 2022 г. в 05:19, Mohammed falih :
>
>> yes I think the service doesn't even start
>>
>> I have only the default protection that comes with the operating system
>>
>> wow the postgres started working!! but the problem came back that talks
>> about console code " WARNING: Console code page (437) differs from
>> Windows code page (1252)
>>
>> 8-bit characters might not work correctly. See psql reference
>> page "Notes for Windows users" for details.
>>
>>
Re: The postgres server don't work
yes sorry I wrote this sentence before try the solution you offered yes by deleting the changes (the Autorun) and thank you so much for your efforts ,I have gone through this solution before but didn't help me to solve the problem ,when I go to command prompt as administrator and insert chcp 1252 the command says 1252 is activated and changed the font from the properties/font then click apply then open the sql shell the error still there even though the font look looks different than before On Sun, 9 Jan 2022, 2:40 am Adrian Klaver, wrote: > On 1/8/22 15:29, Mohammed falih wrote: > > yes I think the service doesn't even start > > Yet below you said it does. > > > > > I have only the default protection that comes with the operating system > > > > wow the postgres started working!! but the problem came back that talks > > Did you revert the change you made earlier to get it to work? > > > > about console code " WARNING: Console code page (437) differs from > > Windows code page (1252) > > > > 8-bit characters mightnot work correctly. See psql reference > > page "Notes for Windows users"for details." > > > > So follow the instructions here : > > https://www.postgresql.org/docs/current/app-psql.html > > " > Notes for Windows Users > > psql is built as a “console application”. Since the Windows console > windows use a different encoding than the rest of the system, you must > take special care when using 8-bit characters within psql. If psql > detects a problematic console code page, it will warn you at startup. To > change the console code page, two things are necessary: > > Set the code page by entering cmd.exe /c chcp 1252. (1252 is a code > page that is appropriate for German; replace it with your value.) If you > are using Cygwin, you can put this command in /etc/profile. > > Set the console font to Lucida Console, because the raster font > does not work with the ANSI code page. > " > > In the terminal before running psql do: > > cmd.exe /c chcp 1252 > > > > -- > Adrian Klaver > adrian.kla...@aklaver.com >
Re: The postgres server don't work
yes exactly I added chcp 1252 line but when I try to save the changes . an error pop out says "you don't have the permission to open this file ,see the owner of the file or an administrator to obtain permission" even though I went to properties/security/myaccount and made it full control On Sun, 9 Jan 2022, 2:51 am Adrian Klaver, wrote: > On 1/8/22 15:29, Mohammed falih wrote: > > yes I think the service doesn't even start > > > > I have only the default protection that comes with the operating system > > > > wow the postgres started working!! but the problem came back that talks > > about console code " WARNING: Console code page (437) differs from > > Windows code page (1252) > > > > 8-bit characters mightnot work correctly. See psql reference > > page "Notes for Windows users"for details." > > > > I don't use Windows anymore so I am going from memory here. In the > Windows menu there should be an entry for Postgres and its sub-programs. > One of those should be named something like psql or database shell. > Click on that, it will run a shell script that prompts you for > connection information and if I remember correctly also takes care of > the above issue. > > > -- > Adrian Klaver > adrian.kla...@aklaver.com >
Re: The postgres server don't work
It worked ! thank you so much , all of you for your efforts and time best wishes to you On Sun, 9 Jan 2022, 3:51 pm Дмитрий Иванов, wrote: > You need to open the folder containing the file and (you must be an > administrator) > Open the file in an editor running as an administrator. > OR > Right click on the file "C:\Program > Files\PostgreSQL\12\scripts\runpsql.bat" -> Properties-> Security. Select > the "Users" group, click "Change" and give write access, click apply. > Starting with Windows 10, the "Program Files" folder is not writable for > regular users and administrators, not in administrator mode. > If all this is difficult for you, just copy the file to your desktop, edit > and run, it will be the same. > -- > Regards, Dmitry! > > > вс, 9 янв. 2022 г. в 15:16, Mohammed falih : > >> thank you for your efforts >> I added chcp 1252 line >> but when I try to save the changes . an error pop out says "you don't >> have the permission to open this file ,see the owner of the file or an >> administrator to obtain permission" >> even though I went to properties/security/mylaptopaccount and made it >> full control >> >> >>
