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 1sRyTV-002fz6-Lv for pgsql-general@arkaria.postgresql.org; Thu, 11 Jul 2024 18:25: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 1sRyTT-00H5aU-NX for pgsql-general@arkaria.postgresql.org; Thu, 11 Jul 2024 18:24: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 1sRyTT-00H5aJ-C7 for pgsql-general@lists.postgresql.org; Thu, 11 Jul 2024 18:24:59 +0000 Received: from mail-oo1-xc2d.google.com ([2607:f8b0:4864:20::c2d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sRyTQ-001Zff-SZ for pgsql-general@lists.postgresql.org; Thu, 11 Jul 2024 18:24:58 +0000 Received: by mail-oo1-xc2d.google.com with SMTP id 006d021491bc7-5c69848ca98so663761eaf.2 for ; Thu, 11 Jul 2024 11:24:56 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1720722296; x=1721327096; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=Sb6EtqLu7CRbYc30oZCwppFauaWW4Ipd6VJEGZd0044=; b=R0qgkHgUb5sTfTCSz24wsnWfjngBH2rw5ChHvFdoMP6ndwUppy57KHhNol3faupCUH 0zyq9oFL0BRdPC3UQ90OM7DPZtlOwOCtKNOeEsrts355wF9nzTko+M4j91AIaeP02kfG sosI0ACU6OV0odicyOBtP1dVazqa/BVSwbjbw/6tNEnlN+ITpi+WHnoGDxGEIPOekU6E fjsnzXpTYZzDK5ivxRmn1j5KCHAE8/Z2EAB8Pzw/rStRJ/jtcSwZwAcHkbIxHzGX83Eh H5fSfyUhSRAFE2w/Ib/rLv74ZBklfC8TFAvuW/HsP4Qy//49fXMS8gxBc7pSZnsos25b qsEA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1720722296; x=1721327096; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=Sb6EtqLu7CRbYc30oZCwppFauaWW4Ipd6VJEGZd0044=; b=YjgIphTxFBRMcKN57dHlLy1ZuRAvI+hpSV5UcXwDl4C/+/Q3EcuKyUCqX8Dfo8G8fF v6K91yinec8nq7j1akD4pyot02gqUlBat5tkzqDM1RGSl57sCEV4X2qVKIiPQXmloD2E ObeLCNybn9wPgJz+GCSUTNRKO3X6US4ulG66hju1qFWjVCFGdx3Jh7DXvizQJvlsJovm bg23ohOEmFn8PhA2fj8HBHYMYcjaLRoNYa/LinuOpz9pJrIx2KOX35OSFpBebKiijSzZ 8K114B0t1EkP/DiJmzx+Cg6X4Bip7l++8144sslxL38aUptxZEz/a6Jfb2GdAW+20g0F TYTw== X-Forwarded-Encrypted: i=1; AJvYcCVtR3UTGv3fy4f5guWwoqJAJ/X6tMd8O4UcQ0VQWTb8gb/rNCujdy9PWm9RwCEf8ktJmpkk25jTcFfbxsgYq7TKEu1lPO5rNiRu5+1cVLDP5tXx X-Gm-Message-State: AOJu0Ywx+bZJTrNAh3JNSSIvt1LT+akwYTA7q1Q4CLbjg+Zyz36MLhNq dyH5hg917Xk9L5LAVbSEeMchwGOiklK+zgxwxu0o3Dr7I3E/zNCPoOSoGsjRmnGNciwYqgVhV0D lVBsDJ04BDQ5jhzZsi00eJbKABt0= X-Google-Smtp-Source: AGHT+IG3c6+aP8EXc5T8DIkrDCWb6l+gTBCC6r5ybo9fnv4+UCSWloLDfow2Hvp4lQipZLUrqOXvNJJP18ESBqhk2cQ= X-Received: by 2002:a05:6820:179a:b0:5c6:9320:4f1e with SMTP id 006d021491bc7-5c693204f51mr12465270eaf.6.1720722296210; Thu, 11 Jul 2024 11:24:56 -0700 (PDT) MIME-Version: 1.0 References: <21E2962B-6905-462C-8C12-6E9454CD26FC@meddatainc.com> <97d1dbfd-6e7b-4019-828f-489ccd6e7eae@aklaver.com> In-Reply-To: From: "David G. Johnston" Date: Thu, 11 Jul 2024 11:24:19 -0700 Message-ID: Subject: Re: Running psql in a docker container To: H Cc: Adrian Klaver , PostgreSQL Users Mailing List Content-Type: multipart/alternative; boundary="000000000000390aee061cfce151" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000390aee061cfce151 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thu, Jul 11, 2024 at 11:16=E2=80=AFAM H wrote: > What is the proper syntax for pgsql 16 for this? I could not get the > example given in the docs to work... > The documentation says this still works: su - postgres -c "/usr/pgsql-16/bin/initdb -D /var/lib/pgsql/16/data/ -E 'UTF-8' --lc-collate=3D'en_US.UTF-8' --lc-ctype=3D'en_US.UTF-8'" If it isn't for you please show the evidence of the non-working-ness. David J. --000000000000390aee061cfce151 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Thu, Jul 11, 2024 at 11:16=E2=80=AFAM H <agents@meddatainc.com> wrote:
What is the proper syntax for pgsql 16 for this? I could no= t get the example given in the docs to work...

The documentation says this still works:

=C2= =A0su - postgres -c "/usr/pgsql-16/bin/initdb -D /var/lib= /pgsql/16/data/ -E 'UTF-8' --lc-collate=3D'en_US.UTF= -8' --lc-ctype=3D'en_US.UTF-8'"

If= it isn't for you please show the evidence of the non-working-ness.

David J.

--000000000000390aee061cfce151--