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 1tyXcE-0087FM-Tl for pgsql-docs@arkaria.postgresql.org; Sat, 29 Mar 2025 14:56:54 +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 1tyXcC-00C4kQ-Vb for pgsql-docs@arkaria.postgresql.org; Sat, 29 Mar 2025 14:56:52 +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 1tyXcC-00C4jV-O4 for pgsql-docs@lists.postgresql.org; Sat, 29 Mar 2025 14:56:52 +0000 Received: from mail-pl1-x632.google.com ([2607:f8b0:4864:20::632]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tyXcA-001oSs-26 for pgsql-docs@lists.postgresql.org; Sat, 29 Mar 2025 14:56:51 +0000 Received: by mail-pl1-x632.google.com with SMTP id d9443c01a7336-227b828de00so57351855ad.1 for ; Sat, 29 Mar 2025 07:56:50 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1743260210; x=1743865010; darn=lists.postgresql.org; h=in-reply-to:references:to:from:subject:cc:message-id:date :content-transfer-encoding:mime-version:sender:from:to:cc:subject :date:message-id:reply-to; bh=kyx7zjWXhnDwgNDrHdC6JakSv9GZPOd/sm1cPm3pe/U=; b=dOsYE2i2d6OuhByLvNGtFFE1ZoGBI4J6g+KWuH1aXS+d7Xe0RmSQsgFsi5AzchO052 sjZ9pIPdhseFJ5GkGFJx9zivOGHvNNhbYXvWqtlu6DZFE/Y6azUgEY0SxrovqUJubASu SI0CNn0pCf6SeHq8PDWrsYihcxo5jn6q7aTQomEFJLSzDMLiTANolrvm9z/OJQcqnqOY r+5qqDgezpaQkQZ56J0Tjb0aOgI4+WjLByCwc+PnTqrGruJYkvRKcPIOvSUISJgTfDu7 OImdK4Rjkb2eZ9l043KwWLokYey1w4on1I/uM6UuJ7hWQoNdmnPRiodIYMgWSa2XqZXf 5l7A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1743260210; x=1743865010; h=in-reply-to:references:to:from:subject:cc:message-id:date :content-transfer-encoding:mime-version:sender:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=kyx7zjWXhnDwgNDrHdC6JakSv9GZPOd/sm1cPm3pe/U=; b=OIZH1YdqGOzFN8+/GB25Bb+kcBCfNxTY86Ayl7ZLxJgEMIZsXAdAbOyuvp3S5iLFBX x9vVKgvreenZIuHi0BovfR8HqGEBJcPa8Hr379Pw868xJSxXG8ROaqgY7Tj7kbGWp/Fm PqR7bLpIoDoGmCp1xiz6Mnudc7ZvaatbRmKsdO3mk74+t70ixAabw9Jprkh/+n1WXPiI Z/1HZ1jC8GjOjWmFxM/lMRM7ppsaV5CtD7FxsSJ6v0SsA+1T4vzU8dI5HuBqj7m/ZH6N uHjvlPdS5vOi6E3MwlXzoHhwMf5Q1b/aKSpB3RXhjjCTq6YvvWo7XiYJGtjJ60RbNxb2 bwEQ== X-Gm-Message-State: AOJu0YwUlbXi+141oW4PLN/ekvirzji7f4OCKOJLlHZWEiMzP1/5XMJ0 s9rW1pt9kZWtAgR6ssBiw/zvQcH/ttBTwYJEbuE+6FhlBHwg6CSZ X-Gm-Gg: ASbGncuzM34fbUkeLL/KQytwAU0YDYrbfGtEKy0RpNF+jQmhQALzZuIZCYxGrejzjiU 8/uQ/dR/DVgrNtuIE4DuCYUSFQquB2QGSd+buCFVzcw9rkCKVtPluox3sGWamcu6N4AaAUzd3y2 3Ukz5JmpnajJVnlwM4kBTmp5laX9CjWXrQazhGzOwojdIwEKNjSKlJe6WxygTKGt73yq0puramj 3l8h0pIGvpA42dXOPHIcrhMs1odvM7vkSj3ecBZ+kCxHFE0AAU70WYCmdfmsCndumHrT59dguJ3 QVxxhVR+QexG/PndL0c9wzjwJKwfJNXBBKXrf7yha6x6as5pDRvZslXD X-Google-Smtp-Source: AGHT+IGgsHGvLxuls2wjUJw9dJUX0avMmgpVTVhi67njgA+BXv6BmPMHIrWyVTpbKVODChtMO/Knfw== X-Received: by 2002:a05:6a00:a27:b0:736:476b:fcd3 with SMTP id d2e1a72fcca58-7398047c382mr5143302b3a.24.1743260209507; Sat, 29 Mar 2025 07:56:49 -0700 (PDT) Received: from localhost ([2601:644:8000:ee20:c090:a7c:4bd8:1550]) by smtp.gmail.com with ESMTPSA id d2e1a72fcca58-73970e22418sm3771404b3a.61.2025.03.29.07.56.48 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sat, 29 Mar 2025 07:56:49 -0700 (PDT) Sender: Gurjeet Singh Mime-Version: 1.0 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=UTF-8 Date: Sat, 29 Mar 2025 07:56:48 -0700 Message-Id: Cc: Subject: Re: Creating first database From: "Gurjeet Singh" To: "Tom Lane" , X-Mailer: aerc 0.20.1 References: <174322916469.674.13909966511923455324@wrigleys.postgresql.org> <2689845.1743256570@sss.pgh.pa.us> In-Reply-To: <2689845.1743256570@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sat Mar 29, 2025 at 6:56 AM PDT, Tom Lane wrote: > PG Doc comments form writes: >> In the Getting Started section of the documentation which would be used = by a >> new user immediately after installing PostgreSQL, the user is asked to r= un >> $ createdb mydb >> If the database is correctly installed, this first command to be run by = the >> new user inevitably fails with the error: >> createdb: error: connection to server at "localhost" (::1), port 5432 >> failed: FATAL: password authentication failed for user "Mark" > We can't really hope to document everything that every packager does > in the community Postgres documentation, not least because they seldom > inform us. I suppose it might be helpful to add something along the > lines of "if you are using a pre-packaged version of Postgres, please > consult the packager's documentation". Given that the 'Installation' subsection, before the 'Creating a Database' subsection within Getting Started, covers the various way Postgres may be installed, and covers that environment variables may need to be tweaked to accommodated the differences, I don't feel the subsequent sections need to repeat how to deal with different types of installations. Best regards, Gurjeet https://Gurje.et