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 1qPBOx-00AEKR-91 for pgsql-general@arkaria.postgresql.org; Fri, 28 Jul 2023 00:32:15 +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 1qPBOv-00Chc4-MH for pgsql-general@arkaria.postgresql.org; Fri, 28 Jul 2023 00:32:13 +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 1qPBOt-00Chbs-Vb for pgsql-general@lists.postgresql.org; Fri, 28 Jul 2023 00:32:13 +0000 Received: from out4-smtp.messagingengine.com ([66.111.4.28]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qPBOh-000mjE-Sw for pgsql-general@lists.postgresql.org; Fri, 28 Jul 2023 00:32:11 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailout.nyi.internal (Postfix) with ESMTP id 33DB75C018A; Thu, 27 Jul 2023 20:31:56 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute5.internal (MEProxy); Thu, 27 Jul 2023 20:31:56 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:content-transfer-encoding:content-type:content-type:date:date :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:sender:subject:subject:to:to; s=fm2; t= 1690504316; x=1690590716; bh=JDW5IiK9j5rRdz5AdGNMBWLLx2AjjKM9BUQ c3toC8fM=; b=OcT1z7bEn/gntEWMYphuIhZMsZAlMDeIcxK1a3o7IoAdhaCYz69 tmE6nh3b3HN6I17vaQWwWMtl9rI7J5GxFztVmVNyitOOssY4Lb5pZ+8kr+x3L9Zh 4uhlquDc/zvhJL9qUXsEOQQa3HDss4j7OyuiQpZd9XtGy/FaC+qWVaRMoc1wPrzR eo/fypI2en+l333/G0J3Rdw7NywveMhYTrtGGIC/zh5dX67bgQsMep8Hfvp9aQU+ knIjk2xvwCGVpsSaxk+kIzqxxjyp4LiIkQ3m8zaqA0pknx84/B8wQ1eZRtWMa5EA sj9w8hy0nZCoGVwvOXFwnFVPluOYs+lrVOg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:sender:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t=1690504316; x= 1690590716; bh=JDW5IiK9j5rRdz5AdGNMBWLLx2AjjKM9BUQc3toC8fM=; b=R +G8XDpXiLxbBuhi4Sf2k0dbAL/u4itas2AeSQvGdJjetSgeNFUNFAv79GzFoowvo YsYhCNsUVVfGUOufcyrVw7BARP5br9GHoAWxlARcUICenXy9VTjEcCdwKODA1Zx0 IuWYtf0n2Gqk/YHFORwMq917Yg/hxD+ciQhjhN621w4b13ALnxmHa3nQ2G1e3oe6 C3X7qGwEXbjOqzMNFhylOkT3DttuQ8CR5UgUThMYF0MgMKJgC3ZrId2afeoyRi8M ABqGMsUe2Xv6PpJK1kqdMFPGu5yUsLajwRlK/fBpBqn3L2dMFtzkzsXMMVAE0zlA uZL2ynGJyu1nB6QgeIzhw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedviedrieehgdefgecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecunecujfgurhepkfffgggfuffvfhfhjggtgfesthejre dttdefjeenucfhrhhomheptegurhhirghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhl rghvvghrsegrkhhlrghvvghrrdgtohhmqeenucggtffrrghtthgvrhhnpeetveehffffie dvkeejhfdvjeehvddtffeugeevfffgfeeuhfffgfffgffgkeeffeenucffohhmrghinhep rghlvhhinhgrlhgvgigrnhguvghrrdgtohhmpdhpohhsthhgrhgvshhqlhdrohhrghenuc evlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrughrihgr nhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhm X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 27 Jul 2023 20:31:55 -0400 (EDT) Message-ID: <943ea752-bf4a-bcba-d2c5-95cfd31e2733@aklaver.com> Date: Thu, 27 Jul 2023 17:31:54 -0700 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.13.0 Subject: Re: PostgreSQL - How to login with my Linux user account To: Amn Ojee Uw , pgsql-general@lists.postgresql.org References: Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 7/27/23 17:19, Amn Ojee Uw wrote: > 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? The tutorial https://www.postgresql.org/docs/current/tutorial.html would be a good place to start. From said tutorial: https://www.postgresql.org/docs/current/tutorial-createdb.html createdb mydb Which in turn leads to: https://www.postgresql.org/docs/current/app-createdb.html > > 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. > -- Adrian Klaver adrian.klaver@aklaver.com