Re: The postgres server don't work

2022-01-08 Thread Дмитрий Иванов
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

Re: create database hangs forever on WSL - autovacuum deadlock?

2022-01-08 Thread Alicja Kucharczyk
sob., 8 sty 2022 o 22:40 Thomas Munro napisał(a): > On Sat, Jan 8, 2022 at 8:11 PM Alicja Kucharczyk > wrote: > > this is postgres running on windows wsl: PostgreSQL 14.1 (Ubuntu > 14.1-1.pgdg18.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu > 7.5.0-3ubuntu1~18.04) 7.5.0, 64-bit > > Is t

Re: The postgres server don't work

2022-01-08 Thread 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 ch

Re: The postgres server don't work

2022-01-08 Thread Mohammed falih
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 ha

Re: The postgres server don't work

2022-01-08 Thread Adrian Klaver
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

Re: The postgres server don't work

2022-01-08 Thread Adrian Klaver
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

Re: The postgres server don't work

2022-01-08 Thread Adrian Klaver
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

Re: Why not used standart SQL commands?

2022-01-08 Thread Andreas 'ads' Scherbaum
On Sat, Jan 8, 2022 at 7:25 PM Ali Koca wrote: > Hello, > > I'm seeing \dt used for "show tables", \l used for "show databases". Why > not standart SQL syntax words? Why specified PostgreSQL commands? > I can't figure out that. > As others pointed out, "show databases" and "show tables" are not

Re: Why not used standard SQL commands?

2022-01-08 Thread Thomas Kellerer
Ali Koca schrieb am 08.01.2022 um 19:25: I'm seeing \dt used for "show tables", \l used for "show databases". Why not standart SQL syntax words? Why specified PostgreSQL commands? I can't figure out that. The only thing the SQL standard defines to gain access to information about tables, schema

Re: create database hangs forever on WSL - autovacuum deadlock?

2022-01-08 Thread Thomas Munro
On Sat, Jan 8, 2022 at 8:11 PM Alicja Kucharczyk wrote: > this is postgres running on windows wsl: PostgreSQL 14.1 (Ubuntu > 14.1-1.pgdg18.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu > 7.5.0-3ubuntu1~18.04) 7.5.0, 64-bit Is this WSL1 (some kind of Linux system call emulator running o

Re: md5 issues Postgres14 on OL7

2022-01-08 Thread Tom Lane
Michael Paquier writes: > [ v3-0001-Improve-error-reporting-for-cryptohashes.patch ] This is looking pretty solid to me. Just a couple of nitpicks: * In most places you initialize variables holding error strings to NULL: + const char *logdetail = NULL; but there are three or so spots th

Re: The postgres server don't work

2022-01-08 Thread Adrian Klaver
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 ha

Re: Why not used standart SQL commands?

2022-01-08 Thread Tom Lane
[ please keep the mailing list cc'd ] Ali Koca writes: > How? I'm newbie There is an ISO SQL standard, and "show" isn't in it. Every SQL implementation has its own extensions of the standard, as well as quirks and deviations from the standard. It sounds like you're used to mysql's extensions .

Re: Why not used standart SQL commands?

2022-01-08 Thread Adrian Klaver
On 1/8/22 10:25, Ali Koca wrote: Hello, I'm seeing \dt used for "show tables", \l used for "show databases". Why not standart SQL syntax words? Why specified PostgreSQL commands? I can't figure out that. AFAIK, SHOW TABLES is a MySQL thing. See here: https://www.sqltutorial.org/sql-list-all-

Re: Why not used standart SQL commands?

2022-01-08 Thread Tom Lane
Ali Koca writes: > I'm seeing \dt used for "show tables", \l used for "show databases". Why > not standart SQL syntax words? Why specified PostgreSQL commands? > I can't figure out that. "show tables" isn't standard either. regards, tom lane

Re: Why not used standart SQL commands?

2022-01-08 Thread David G. Johnston
On Saturday, January 8, 2022, Ali Koca wrote: > Hello, > > I'm seeing \dt used for "show tables", \l used for "show databases". Why > not standart SQL syntax words? Why specified PostgreSQL commands? > I can't figure out that. Less characters to type (and remember). Assuming psql is available

Why not used standart SQL commands?

2022-01-08 Thread Ali Koca
Hello, I'm seeing \dt used for "show tables", \l used for "show databases". Why not standart SQL syntax words? Why specified PostgreSQL commands? I can't figure out that. Ali

Re: How are md5.h: pg_md5_hash() function and below functions working?

2022-01-08 Thread Adrian Klaver
On 1/8/22 05:21, Ali Koca wrote: I can't understand functions in md5.h, these are seemingly little bit weird. Such as: /* Utilities common to all the MD5 implementations, as of md5_common.c */ extern bool pg_md5_hash(const void *buff, size_t len, char *hexsum); extern bool p

How are md5.h: pg_md5_hash() function and below functions working?

2022-01-08 Thread Ali Koca
I can't understand functions in md5.h, these are seemingly little bit weird. Such as: /* Utilities common to all the MD5 implementations, as of md5_common.c */ extern bool pg_md5_hash(const void *buff, size_t len, char *hexsum); extern bool pg_md5_binary(const voi

The postgres server don't work

2022-01-08 Thread Mohammed falih
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 onl