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 1qRiVv-002iWk-Jp for pgsql-general@arkaria.postgresql.org; Fri, 04 Aug 2023 00:17:55 +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 1qRiVt-001Cyl-MC for pgsql-general@arkaria.postgresql.org; Fri, 04 Aug 2023 00:17:54 +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 1qRiVt-001Cyc-Bq for pgsql-general@lists.postgresql.org; Fri, 04 Aug 2023 00:17:53 +0000 Received: from mail-vs1-xe36.google.com ([2607:f8b0:4864:20::e36]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qRiVr-000REP-46 for pgsql-general@lists.postgresql.org; Fri, 04 Aug 2023 00:17:53 +0000 Received: by mail-vs1-xe36.google.com with SMTP id ada2fe7eead31-4478ea3ac05so684501137.2 for ; Thu, 03 Aug 2023 17:17:50 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1691108269; x=1691713069; h=subject:to:content-language:user-agent:mime-version:date:message-id :from:from:to:cc:subject:date:message-id:reply-to; bh=M8YY+HNK/QkfXPJydcwrsvj3tSnNPdKbfl3mk42RVJA=; b=nkvubL5DpbpPOQukR9vAh0rTxb9xf/i5ENf0UPXXJvRISHNZwJbmq+hEqZQtecTa7t VAqWJRTSUJH/6IhQ37nxf3BSPmhY8ZBJgZd0tXXrMc9JYtaFPsph4J9CqYnFp20iGjQ6 QV80A5nbUexzSSu2XyRm1pQhE8G9mUn/8YrPv5cIBigyCa9u9OjphUC9+WLU708Xe4wo kZIYE6LC+sEkEFFaktSu/QxOdYtDQxUKg8I9SRh6VsqO6NIlEqQL73t8QKjzT/uLSujw zbZ2R4KvvLMQPR6gFCGlwpAKaBDc+EmH6glaXvuUmjYjqGgQixrRNi97OIfO5azJwga/ Nt4A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1691108269; x=1691713069; h=subject:to:content-language:user-agent:mime-version:date:message-id :from:x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=M8YY+HNK/QkfXPJydcwrsvj3tSnNPdKbfl3mk42RVJA=; b=kUNJpKAk0/leICzErqlOLlQfH8xx3ER7x3xVuLsKmCQiOCMOvD/D113DAh6jTV1c+N RPQ9cVF+GiCHcjGDb3+InsQT35fRCwMjM4RxTd1bJOhOGGG9W7TJV+ONVKYa8fwIa4Sz M9dVzShlVszPElY6KIGy1AWngmNAy7vmtZJYXkoOR7BSdWc3Aqq18g8IOAzg4Gx1dAwP 9IFKn0XOTap5oA/RnUnNtmb3sTlUazN5JQt6e20nT5JmKbJ8PU543v7k8wsSGvCdp4PR Vjf3IKeh9wwmYIAiC9hj4pue1dgvSQDgA9Xn12XibexLVJLBoaVeS2ZSM+bMmHvdu1UY //+g== X-Gm-Message-State: AOJu0YxVRlSk/fueWTq+IglDgkho4U6r1iHvZRMPLZ/pu9mrhsCKII7W CHoc+lE0EnvmrwXHT07T/HIXg5cN4OscGg== X-Google-Smtp-Source: AGHT+IFs5VOV7h0xbgHTwOgTK/S34sChR3lACPjBSC40tZzA4TxXoLbY1ouCBs1vqgGuDYQTFsKC7Q== X-Received: by 2002:a67:db02:0:b0:447:8e20:6e2e with SMTP id z2-20020a67db02000000b004478e206e2emr256567vsj.34.1691108268868; Thu, 03 Aug 2023 17:17:48 -0700 (PDT) Received: from [192.168.2.170] ([67.70.150.114]) by smtp.gmail.com with ESMTPSA id f28-20020a0caa9c000000b006255bcfca88sm278728qvb.7.2023.08.03.17.17.47 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 03 Aug 2023 17:17:48 -0700 (PDT) From: Amn Ojee Uw X-Google-Original-From: Amn Ojee Uw Content-Type: multipart/alternative; boundary="------------JeZBrAEXucZ2VYsKxxHzsuO3" Message-ID: Date: Thu, 3 Aug 2023 20:17:38 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.13.1 Content-Language: en-US To: pgsql-general@lists.postgresql.org Subject: role "my_account" does not exist 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. --------------JeZBrAEXucZ2VYsKxxHzsuO3 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Hello! Following this web page , I have tried to create a new role/user, but to no avail. After typing the following command : /*createuser --interactive --pwprompt*/ I get the following questions: Enter name of role to add: company_name Enter password for new role: xxxxxxx Enter it again: xxxxxxx Shall the new role be a superuser? (y/n) y Than this error is displayed : */createuser: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" /**/ /**/failed: FATAL:  role "my_debian_login_account_name" does not exist/* How/ever, this issue is not really relevant/, per se, since I am able to create roles once I log in PostgreSQL-15. Nonetheless, if the service exist, why not usu it. If the services exist and is not working, could it be that there is a problem that will come apparent later on, when unlike now, it would be during a critical moment. Thus the question, what can I do to resolve this issue? Is there something I am missing? Thanks --------------JeZBrAEXucZ2VYsKxxHzsuO3 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit

Hello!

Following this web page, I have tried to create a new role/user, but to no avail.

After typing the following command : createuser --interactive --pwprompt I get the following questions:

Enter name of role to add: company_name
Enter password for new role: xxxxxxx
Enter it again: xxxxxxx
Shall the new role be a superuser? (y/n) y

Than this error is displayed :
createuser: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432"
failed: FATAL:  role "my_debian_login_account_name" does not exist

However, this issue is not really relevant, per se, since I am able to create roles once I log in PostgreSQL-15. Nonetheless, if the service exist, why not usu it. If the services exist and is not working, could it be that there is a problem that will come apparent later on, when unlike now, it would be during a critical moment. Thus the question, what can I do to resolve this issue?
Is there something I am missing?


Thanks


--------------JeZBrAEXucZ2VYsKxxHzsuO3--