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 1qQmZk-000xkh-9D for pgsql-general@arkaria.postgresql.org; Tue, 01 Aug 2023 10:26:01 +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 1qQmZi-005Y4A-6t for pgsql-general@arkaria.postgresql.org; Tue, 01 Aug 2023 10:25:59 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qQmZh-005Y42-Sx for pgsql-general@lists.postgresql.org; Tue, 01 Aug 2023 10:25:59 +0000 Received: from mail-ua1-x929.google.com ([2607:f8b0:4864:20::929]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qQmZg-000A0S-PN for pgsql-general@lists.postgresql.org; Tue, 01 Aug 2023 10:25:58 +0000 Received: by mail-ua1-x929.google.com with SMTP id a1e0cc1a2514c-794cddcab71so1902703241.1 for ; Tue, 01 Aug 2023 03:25:56 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1690885555; x=1691490355; h=in-reply-to:to:references:content-language:subject:user-agent :mime-version:date:message-id:from:from:to:cc:subject:date :message-id:reply-to; bh=99VC/BiMKsGBFyGN2K2hCj+dSvs+KohlMwruFxbyon8=; b=kUk8zUNTrhrPtBlZpa6r8lcMQcwpZcIGEmCdCYmqafPjxAv5Ac/BjnZCXWTH/jhzFg aT9e8gU/PZViHS1w1T9L15mf0fu9oSEQCxSLhP9+GGfNWpuIe9UIdPiY8wDlcVi/M5Cp lD9aFVj+6hZPxZyksrxkHlJ1QvGUffYAhLiqyrNoo423sohiJED2YI04bNAvaXAQNHL7 F3WVUmQKs6id7n1fsxE4TYvxqmBKzanKcv26O0SToado48z4mTzHbEM7JXZdWD9ETRIc RJ4JK9bcC9czwvEIioddkejqmEwHuf3HNRLa7/dMM6nmQYjjuzpVQ9C1SykyFJh2p9wp aCEQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1690885555; x=1691490355; h=in-reply-to:to:references: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=99VC/BiMKsGBFyGN2K2hCj+dSvs+KohlMwruFxbyon8=; b=mD4XtqK9p7TpPhzPEjvxqiJsR+FPa7LDO+k68tA4dFAS3Af5EsX+5hvKoVNWZ5WaVI YtPjV0SteSe5++PhA6fhCnLgpawT8VRj+/Ga6pzeVwxMisP6PwgTD3cWtWfi+5Ftfbt3 CsMJ5KgrRVladm5i+K1QolRbejNfBdVhRKd8Qp2db0sft8CUenGzLPfZB0DYmXXxj7O6 wxDhcY7h8k+Gom/weZa2BV4WrIm9Dn8YmHtzdFMf3ohIpo7VZyM94MTegYQu0TMvm9m+ REmOfky5nikoYWCp2AooBGIX25G9gMjH6hhUFLdmMEGstSa2ndpOYQDQOBlBTs+p5rAy F4zA== X-Gm-Message-State: ABy/qLZ7I1bSd4yLJAA3/8EZ3u9UzwzSnkecWz91CYXcGLQX6trMCod1 7H4JKRBQ7dkBDK/Ba9IiCpFOm8V43zhUjQ== X-Google-Smtp-Source: APBJJlEAkkohwe7p2vX3PyH5i5okn37dKHFA4f3RIrfSLMDNbv/SemM/E206GEwwszafmYgI1jweeA== X-Received: by 2002:a67:ff09:0:b0:443:4e7d:c8db with SMTP id v9-20020a67ff09000000b004434e7dc8dbmr1826589vsp.2.1690885555426; Tue, 01 Aug 2023 03:25:55 -0700 (PDT) Received: from [192.168.2.170] (bras-base-bmtnon1319w-grc-34-67-70-150-114.dsl.bell.ca. [67.70.150.114]) by smtp.gmail.com with ESMTPSA id h5-20020a0cf445000000b00631eaf8b9e5sm3526260qvm.138.2023.08.01.03.25.54 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 01 Aug 2023 03:25:55 -0700 (PDT) From: Amn Ojee Uw X-Google-Original-From: Amn Ojee Uw Content-Type: multipart/alternative; boundary="------------0VxfJIdPrei48uRi2EcrSCoi" Message-ID: Date: Tue, 1 Aug 2023 06:25:54 -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 References: <97d77785-22a0-5d48-9582-4a7beb2dc14f@gmail.com> To: pgsql-general@lists.postgresql.org In-Reply-To: <97d77785-22a0-5d48-9582-4a7beb2dc14f@gmail.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------0VxfJIdPrei48uRi2EcrSCoi Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit _*Addendum*_ I tried this, but to no avail : /*sudo systemctl start postgresql*/ On 8/1/23 6:22 a.m., 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? > > Thanks in advance. > --------------0VxfJIdPrei48uRi2EcrSCoi Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit

Addendum

I tried this, but to no avail : sudo systemctl start postgresql

On 8/1/23 6:22 a.m., 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?

Thanks in advance.

--------------0VxfJIdPrei48uRi2EcrSCoi--