Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qQy3M-0007Lg-UT for pgsql-general@arkaria.postgresql.org; Tue, 01 Aug 2023 22:41:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qQy2M-000iTZ-K6 for pgsql-general@arkaria.postgresql.org; Tue, 01 Aug 2023 22:40:18 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qQy2M-000iTR-8G for pgsql-general@lists.postgresql.org; Tue, 01 Aug 2023 22:40:18 +0000 Received: from mail-qv1-xf33.google.com ([2607:f8b0:4864:20::f33]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qQy2J-000212-77 for pgsql-general@lists.postgresql.org; Tue, 01 Aug 2023 22:40:17 +0000 Received: by mail-qv1-xf33.google.com with SMTP id 6a1803df08f44-63cff46ddb8so1650346d6.1 for ; Tue, 01 Aug 2023 15:40:14 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1690929613; x=1691534413; h=content-transfer-encoding:in-reply-to:references:to :content-language:subject:user-agent:mime-version:date:message-id :from:from:to:cc:subject:date:message-id:reply-to; bh=73gmfNXdE087rflNDl9gMsSWyOLE1tL96jWLCup8KyE=; b=acdl+IdjYZeYobCA1oJtrYUtHcjTWAMHpnIq/7qRXZgXublwbv4fMwnafWRy8G6aZ9 Gs35SrULasmSIMsLfcFtFriQeVKaIgRrSt65iitu1DYvx+Mf1fQjnAhrA866fcDUr+EQ RYy4bTqDac951b5eLH2taAWlyugnq9QYbJqCuyqFxMy6A8xpks0KTFZTl39ldwafgv/v fbLm2BAR/T3srkuOWBvwVKCFniCyQi4xHAHqsIGdwnk8F9YGjJ9WCqXNGB7GIRYJFTqP 9obQKSZuv5qimokZsnv6kDZw2w7h21/MkUMexO7CDN1et3EXztwl/f0MnhbMQgAKXgJq 40RA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1690929613; x=1691534413; h=content-transfer-encoding:in-reply-to:references:to :content-language:subject:user-agent:mime-version:date:message-id :from:x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=73gmfNXdE087rflNDl9gMsSWyOLE1tL96jWLCup8KyE=; b=UP5Dxdg+WtcbOfxm+tGzLcZW5VTNO2yOltrcnXzAqdT4aU/yWHtsbRAh/Z4FG2RNO5 i9g5q7gcDDmzvUb206K0VQQ9NGJAf1B0jxYKI0MiLw8QeOnNs4isoEI1oWVQje0TQkZU fW+/U45tR+751Iia58xz6T3Z/RZ6OZVcfvWvG3Xf+VlpcPwXoc0HC75aEB+7KnF6xVpD sDaxKwBYAl24nxnuTQE4tcSKdqGjyeWM73Ral0pbMcIjgxJd6yY4aTo2rA/pXd5EQLSa NxSpLs5eL5SvB+aq/F1xkuTOdcNQ3nO7oFQ0qbhud6ha6oxJT2sIJ1yHzGXCoWGJO+Ab 720g== X-Gm-Message-State: ABy/qLZbf6R+YeNmeO3ybqGHMahcYSA3iSBUjmRWBwkhdkv7J7bVclbh OMT5c5qEHmwZ43XwELVcSYA= X-Google-Smtp-Source: APBJJlHlcQTFCmVssBT7le600QIiBYCXuj6dgv2mU7S8N252MHb4LpFOj3n0bxyKcTaUebBsfh8zxA== X-Received: by 2002:a05:6214:508e:b0:62d:ddeb:3770 with SMTP id kk14-20020a056214508e00b0062dddeb3770mr17538362qvb.0.1690929613201; Tue, 01 Aug 2023 15:40:13 -0700 (PDT) Received: from [192.168.2.170] ([67.70.150.114]) by smtp.gmail.com with ESMTPSA id h13-20020a0cab0d000000b00635eeb8a4fcsm4999008qvb.114.2023.08.01.15.40.12 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 01 Aug 2023 15:40:12 -0700 (PDT) From: Amn Ojee Uw X-Google-Original-From: Amn Ojee Uw Message-ID: Date: Tue, 1 Aug 2023 18:40:03 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.13.1 Subject: Re: error: connection to server on socket... Content-Language: en-US To: Adrian Klaver , pgsql-general@lists.postgresql.org References: <97d77785-22a0-5d48-9582-4a7beb2dc14f@gmail.com> <863bf07c-6993-ce36-f260-6749ab327632@aklaver.com> <148c784c-8eac-0bae-43c9-f819d265e288@gmail.com> <11ee7173-cfb6-7f4c-c17b-dcced24e2bc9@aklaver.com> In-Reply-To: <11ee7173-cfb6-7f4c-c17b-dcced24e2bc9@aklaver.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Thank you Adrian. It Worked!!! On 8/1/23 2:55 p.m., Adrian Klaver wrote: > On 8/1/23 11:42, Amn Ojee Uw wrote: >> Ah! Adrean, here is something interesting. >> >> /*pg_lsclusters*/ displays the following information >> >> /*Ver Cluster Port Status                Owner    Data >> directory              Log file*//* >> *//*12  main    5432 down,binaries_missing postgres >> /var/lib/postgresql/12/main >> /var/log/postgresql/postgresql-12-main.log*//* >> *//*15  main    5433 online                postgres >> /var/lib/postgresql/15/main /var/log/postgresql/postgresql-15-main.log*/ >> >> What is version 12 is doing there, I thought that I had completely >> removed it and replaced it with version 15!! > > You didn't, read: > > https://www.postgresql.org/message-id/20230731125247.puiaz7fjkfvljdwy%40alvherre.pgsql > > > and > > https://www.postgresql.org/message-id/33f0fc61-2d0f-60bd-e0ed-4cada3c30301@aklaver.com > > > The clue is "binaries_missing". > > You remove(ed) all the files except the conf files. > > >> Should I remove that log file? > > Run: > > sudo apt purge postgresql-12 > > That will take care of removing all the conf files. > > > To connect you need to specify the correct port, 5433 or do: > > sudo vi /etc/postgresql/15/main/postgresql.conf > > and change > > port = 5433 > > to > > port = 5432 > > Then restart the server. > > You then need to spend some time at the links in this message: > > https://www.postgresql.org/message-id/c1ad730a-a84a-ae97-2f23-6891cb06ef26%40aklaver.com > > >> >> Regarding /pf@pfortin.com/ assertion, I am working with a _/Debian >> 12/_ machine and /*ls -l /tmp/.s.PGSQL.5432*/ >> displays the following error message : /*ls: cannot access >> '/tmp/.s.PGSQL.5432': No such file or directory*/ >> >> As for Tomas Pospisek questions : >> * as which user are you doing that (you can see that via `id`)? >> >>     Due to matters of security let us assume that the output is : >>     /*id*//* >>     *//*uid=1000(my_account) gid=1000(my_account) >> groups=1000(my_account),24(cdrom),25(floppy),27(sudo),29(audio),30(dip),44(video),46(plugdev),100(users),*/ >> /*106(netdev),111(bluetooth),113(lpadmin),116(scanner),122(postgres),1001(tomcat)*/ >> >> * in which directory are you executing it  (you can see that via `pwd`)? >> >>     /*/home/*//*my_account*/ >> >> * what is the home directory of the postgres user (you can see that >> via `grep postgres /etc/passwd`) /* >> */ >> >>     /*~$ grep postgres /etc/passwd*//* >>     *//*postgres:x:113:122:PostgreSQL >>     administrator,,,:/var/lib/postgresql:/bin/bash*/ >> >> * what does `ls -ld /var/run/postgresql/; ls -l >> /var/run/postgresql/.s.PGSQL.5432` show? >> >>     /*ls -ld /var/run/postgresql/*//* >>     *//*drwxrwsr-x 2 postgres postgres 100 Jul 31 20:45 >>     /var/run/postgresql/*/ >> >>     /*ls -l /var/run/postgresql/.s.PGSQL.5432*//* >>     *//*ls: cannot access '/var/run/postgresql/.s.PGSQL.5432': No such >>     file or directory*/ >> >> >> - what does `journalctl -xeu postgresql` say? >> >>     /*sudo journalctl -xeu postgresql*//* >>     *//*[sudo] password for *//*/**//*my_account*/: *//* >>     *//*░░ Support: https://www.debian.org/support*//* >>     *//*░░ *//* >>     *//*░░ A start job for unit postgresql.service has begun >> execution.*//* >>     *//*░░ *//* >>     *//*░░ The job identifier is 3496.*//* >>     *//*Jul 31 20:45:13 *//*tree.com systemd[1]: Finished >>     postgresql.service - PostgreSQL R>*//* >>     *//*░░ Subject: A start job for unit postgresql.service has finished >>     successfully*//* >>     *//*░░ Defined-By: systemd*//* >>     *//*░░ Support: https://www.debian.org/support*//* >>     *//*░░ *//* >>     *//*░░ A start job for unit postgresql.service has finished >>     successfully.*//* >>     *//*░░ *//* >>     *//*░░ The job identifier is 3496.*//* >>     *//*lines 4-16/16 (END)*/ >> >> - what does `tail -n 20 >> /var/log/postgresql/postgresql-*-qgisclouddb.log` show? >> >>     /*sudo tail -n 20 >> /var/log/postgresql/postgresql-*-qgisclouddb.log*//* >>     *//*tail: cannot open >>     '/var/log/postgresql/postgresql-*-qgisclouddb.log' for reading: No >>     such file or directory*/ >> >> >> I hope I was able to answer all the interesting questions posted as >> reply to my original post. >> >> /Thanks folks, I really appreciate the time you have dedicated to my >> question./ >> >> >> On 8/1/23 10:35 a.m., Adrian Klaver wrote: >>> On 8/1/23 03:22, Amn Ojee Uw wrote: >>>> Using the following command on my Debian 12 machine: >>>> >>>> /*sudo apt-get install postgresql postgresql-15 >>>> postgresql-client-common postgresql-common postgresql-contrib >>>> postgresql-doc phppgadmin >>>> */ >>>> >>>> >>>> and following the instruction on this >>>> web page I have >>>> installed PostgreSQL-15. >>>> The installation went smooth, until the following command was issued : >>>> >>>> /*sudo -u postgres psql*/ >>>> >>>> ... I get an error message that reads: >>>> >>>> /*could not change directory to "/home/my_account": Permission >>>> denied*//* >>>> *//*psql: error: connection to server on socket >>>> "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or >>>> directory*//* >>>> *//*    Is the server running locally and accepting connections on >>>> that socket?*/ >>>> >>>> What can I do to resolve this issue? >>> >>> Run >>> >>> pg_lsclusters >>> >>> and see what port the server is running on. >>> >>>> >>>> Thanks in advance. >>>> >>> >