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 1qPBCs-00ADPe-3s for pgsql-general@arkaria.postgresql.org; Fri, 28 Jul 2023 00:19:45 +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 1qPBCq-00CZpK-AV for pgsql-general@arkaria.postgresql.org; Fri, 28 Jul 2023 00:19:44 +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 1qPBCp-00CZpC-WA for pgsql-general@lists.postgresql.org; Fri, 28 Jul 2023 00:19:44 +0000 Received: from mail-qk1-x72a.google.com ([2607:f8b0:4864:20::72a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qPBCl-001wco-5J for pgsql-general@lists.postgresql.org; Fri, 28 Jul 2023 00:19:42 +0000 Received: by mail-qk1-x72a.google.com with SMTP id af79cd13be357-7673180224bso120941385a.0 for ; Thu, 27 Jul 2023 17:19:39 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1690503577; x=1691108377; h=subject:to:content-language:user-agent:mime-version:date:message-id :from:from:to:cc:subject:date:message-id:reply-to; bh=2Xb+9aTbxlLj5zOG3eac0W6sOZmNQnJm8AfbOaYHMX8=; b=OhncqdVLeTpzmMtb9qNcvKISq5rbe3RR2EEyXm88FymLu2Ii5+p0SuynTD19BUpheu /iKYAqMD4T3SHxMRI1YWCD6s/jJM5v6b6A93B5r5cJUwEfUonq0UPjH5qL12rklT4zBn 9AA3TWr981zgk4voaS/MvhOxB2aLSjq3bV1AknF80TgcIWFYMcYmCbaUxhEfmTuYuC30 8NuxuIeTL3nUn/LEiKZhIQ0dh6G8KSiRKDwwkKB41E7K3wj1Xp+QBOPhgbjggyFqU+q+ qoFSoaiBGTF7uLq7DWAafF9DTD9AAD59IITmRkLSAZcySbToZQrWjzF3dD7zua17xNgS g0VQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1690503577; x=1691108377; 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=2Xb+9aTbxlLj5zOG3eac0W6sOZmNQnJm8AfbOaYHMX8=; b=UzRN2XpTciqEURiWl2EHBJJZBVCUAmQNY2fLSsbZClM/7ynReMgjIzUOm4DewuNoBc peSGoVxGvKEi2MNcyA9m4H2BXUFCtcAtpX5OrlX8ZkZD+qi6Fle8SDxfKI2EZYRyJrd2 iRL1xbELMqbq772xPlnPqDI6G7PBu0E87L8ccjzIoIjFhl+9dLdD4asMnuokrtcQytE8 9pPKSkvtuJU9LjZzqANlB2BJ+lMCDCJcjVaAED1UHybhpIFCJm6OXlLQ7E/6jKADYc8x H/JTDLtJyeZ8R2mbVRGaLPaqkARz+WdaAIEemXVAvsBUQ8jgFmxV4b/XgbmNMHsalQvS iIHg== X-Gm-Message-State: ABy/qLZofBOUijqSNU2nLUFrYLi3fiBkZMwqwVWw8AtATULEw2U7Snnv PrHZMWuYvRH9vEunMLQ/sciZ+yxj38GXfw== X-Google-Smtp-Source: APBJJlEpLhNzbZQPpFvdUQv37/1aa4Q5cDWPnFvhmYG7zW2Ekl9Q5zOWCTds+no4uvA10+r7clAZZA== X-Received: by 2002:a05:620a:298c:b0:767:b4c0:45a1 with SMTP id r12-20020a05620a298c00b00767b4c045a1mr1290781qkp.66.1690503576878; Thu, 27 Jul 2023 17:19:36 -0700 (PDT) Received: from [192.168.2.170] ([67.70.150.114]) by smtp.gmail.com with ESMTPSA id k24-20020a05620a143800b00767e669d5d6sm755507qkj.50.2023.07.27.17.19.36 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 27 Jul 2023 17:19:36 -0700 (PDT) From: Amn Ojee Uw X-Google-Original-From: Amn Ojee Uw Content-Type: multipart/alternative; boundary="------------105k5kVw2LJomdYm01QJ6lYu" Message-ID: Date: Thu, 27 Jul 2023 20:19:27 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.13.0 Content-Language: en-US To: pgsql-general@lists.postgresql.org Subject: PostgreSQL - How to login with my Linux user account 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. --------------105k5kVw2LJomdYm01QJ6lYu Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit I'd like to log into my newly installed PostgreSQL [ PostgreSQL 12.15 (Debian 12.15-1.pgdg120+1) ] using my linux account. In trying to do that this web page suggest that I enter : psql -d mydb -U myuser -W However, that command requires a database_name (mydb), and PosgreSQL 12.15 being so freshly installed does not yet have any database created by me. How would you suggest I circumvent this challenge? Mind you that, using the postgres account I have created other accounts. Role name | Attributes | Member of -----------+------------------------------------------------------------+----------- chispa | Superuser | {} pedro | Superuser | {} postgres | Superuser, Create role, Create DB, Replication, Bypass RLS | {} Thanks in advance. --------------105k5kVw2LJomdYm01QJ6lYu Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit

I'd like to log into my newly installed PostgreSQL [ PostgreSQL 12.15 (Debian 12.15-1.pgdg120+1) ] using my linux account.
In trying to do that this web page suggest that I enter :

psql -d mydb -U myuser -W

However, that command requires a database_name (mydb), and PosgreSQL 12.15 being so freshly installed does not yet 
have any database created by me.

How would you suggest I circumvent this challenge?

Mind you that, using the postgres account I have created other accounts.


Role name |                         Attributes                         | Member of 
-----------+------------------------------------------------------------+-----------
 chispa    | Superuser                                                  | {}
 pedro     | Superuser                                                  | {}
 postgres  | Superuser, Create role, Create DB, Replication, Bypass RLS | {}


Thanks in advance.

--------------105k5kVw2LJomdYm01QJ6lYu--