Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qBWi9-0002gK-4m for pgsql-general@arkaria.postgresql.org; Tue, 20 Jun 2023 08:27:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qBWi6-0003TI-A4 for pgsql-general@arkaria.postgresql.org; Tue, 20 Jun 2023 08:27:34 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qBWi5-0003T8-S9 for pgsql-general@lists.postgresql.org; Tue, 20 Jun 2023 08:27:33 +0000 Received: from mail-yw1-x1132.google.com ([2607:f8b0:4864:20::1132]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qBWi3-003aQM-0G for pgsql-general@lists.postgresql.org; Tue, 20 Jun 2023 08:27:33 +0000 Received: by mail-yw1-x1132.google.com with SMTP id 00721157ae682-5700e993f37so80844947b3.0 for ; Tue, 20 Jun 2023 01:27:30 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1687249649; x=1689841649; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:from:to:cc:subject:date:message-id :reply-to; bh=AXPNzUpi+FwUhrxUXwsUJHYjlCkFXJ48UsSoCHwFBeQ=; b=mvZiGjtGfZQzm6mmssRBXi9LRI9/VrdezhYkEc5ZU2s/8DBGYWHia8rOQmX8m3hNK4 NQWOA8pu6EGg8qaQUfGhBIJG8OWALfgYnoKHZv4j27eXfbbofFnNSChb+pIU+VUbRpuk ZcnejM4djJKoyUEKwIR55UKs/JVhHWSgWZWdrv5etR6vKV//ad7g1oHmOUc4MXkCEN5L KNBS3Hrc72eJcPtJFsGcfxzEyrtqP0WJqVBpMMuSSlY2kRQ+a+dd6MXtObDIavKmB3v4 LKCUfm869F/z1Foz/BeaRKz6QlQIaAsfQQueappegN2MB0WIr7kA+JBDXIAkF8sGljJN 7yKA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1687249649; x=1689841649; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=AXPNzUpi+FwUhrxUXwsUJHYjlCkFXJ48UsSoCHwFBeQ=; b=cs7OZBsHs9e9FV28tNG5ECrnk24ByVMXuRI55dRAzBes7EKVLp4SAOgU1OGiQSt1WP vEZFOxpvaa/nnc3Y16pZtSlSlapHI7cWoweZOKBlaH/hyBior7LnUXtqxZ89NB+ZQtZS 5gfZ3BW376NRlaeJ3+u63sD5JqFQFyipP+njZv4RK+nG9CGXBLOxnAMTvtEk+3o2joD+ /atAOyVYMpMtd63cwOHiLxHZMEgSWcGsIMEoV1SOZEFaVSH+rCXHH5jhNuz5acy+IXu2 GtVtk6EnHQsMmDBwA+c/C2uIf4FPTAtmDd00e7IxAz8D7u2iTJuusFpZZyf3u9WYzkHt Ay/A== X-Gm-Message-State: AC+VfDxsJYRHu9dCryo6UG+Z0/DNsHcQpofEb3p51y0IeOySYXueCKy6 EZXMt6fAojbLLsq7zzotSbzGeoo4DRQ= X-Google-Smtp-Source: ACHHUZ6qtjEib00o0aWrnAAzd7OsXLUDO0idxIR28hEaH29i9WbM1j6U96bTPGmUrFob3qfov9KYJA== X-Received: by 2002:a0d:d54b:0:b0:570:364b:aed6 with SMTP id x72-20020a0dd54b000000b00570364baed6mr11776449ywd.12.1687249648853; Tue, 20 Jun 2023 01:27:28 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:e18f:d5cd:212b:24c8? ([2600:1700:bd2c:b810:e18f:d5cd:212b:24c8]) by smtp.googlemail.com with ESMTPSA id e65-20020a0dc244000000b0056cffe97a11sm398601ywd.13.2023.06.20.01.27.28 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 20 Jun 2023 01:27:28 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------4LCjhkTY9vZOFefRGBUE9fHV" Message-ID: <260b572f-8da1-1c40-c0fc-cf0c65a8b0ef@gmail.com> Date: Tue, 20 Jun 2023 03:27:28 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.11.0 Subject: Re: pg_service file questions Content-Language: en-US To: pgsql-general@lists.postgresql.org References: From: Ron In-Reply-To: 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. --------------4LCjhkTY9vZOFefRGBUE9fHV Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit On 6/20/23 01:11, JUN ZHI wrote: > Hi, > > I was scanning through the postgresql documentations when i came across > this webpage: PostgreSQL: Documentation: 15: 34.17. The Connection Service > File  . I am > fairly new to database and i have a few questions regarding this: > > 1. Is pg_service.conf and .pg_service.conf (with a dot at the front) > different files? > 2. The documentation stated that the .pg_service.conf is named > %APPDATA%\postgresql.pg_service.conf on windows which is a directory i > can not find. > 3. The documentation also stated that we can check for the sysconfigdir > environment variable and point it to somewhere else, but when i > checked for the sysconfigdir path, it is pointing to > C:/PROGRA~1/POSTGR~1/15/etc which again, is a directory i can not find > : to be specific, i can not find the etc file stated in the pathing. > > So where should i put this pg_service file and does it link with the > database itself? %APPDATA% is normally hidden to users.  Here's how to show it? https://support.microsoft.com/en-us/windows/view-hidden-files-and-folders-in-windows-97fbc472-c603-9d90-91d0-1166d1d9f4b5 -- Born in Arizona, moved to Babylonia. --------------4LCjhkTY9vZOFefRGBUE9fHV Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit On 6/20/23 01:11, JUN ZHI wrote:
Hi,

I was scanning through the postgresql documentations when i came across this webpage: PostgreSQL: Documentation: 15: 34.17. The Connection Service File . I am fairly new to database and i have a few questions regarding this:

  1. Is pg_service.conf and .pg_service.conf (with a dot at the front) different files?
  2. The documentation stated that the .pg_service.conf is named %APPDATA%\postgresql.pg_service.conf on windows which is a directory i can not find.
  3. The documentation also stated that we can check for the sysconfigdir environment variable and point it to somewhere else, but when i checked for the sysconfigdir path, it is pointing to C:/PROGRA~1/POSTGR~1/15/etc which again, is a directory i can not find : to be specific, i can not find the etc file stated in the pathing.
So where should i put this pg_service file and does it link with the database itself?

%APPDATA% is normally hidden to users.  Here's how to show it?

https://support.microsoft.com/en-us/windows/view-hidden-files-and-folders-in-windows-97fbc472-c603-9d90-91d0-1166d1d9f4b5

--
Born in Arizona, moved to Babylonia.
--------------4LCjhkTY9vZOFefRGBUE9fHV--