Re: pg_service file questions

Ron <ronljohnsonjr@xxxxxxxxx> · Tue, 20 Jun 2023 03:27:28 -0500



    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:
      
        
              Is pg_service.conf and
                .pg_service.conf (with a dot at the front) different
                files?
              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.
              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.