How am I supposed to use a scoop program in an elevated shell?

[ekawatani]

I want to install postgresql via scoop and set it up as a service. After I installed postgresql, I got this notes:

register it as a service by running 'pg_ctl register -N PostgreSQL' from an elevated shell.

But, when I opened my terminal in admin mode and try to run it, the pg_ctl command was not found. How am I supposed to do this?

[HUMORCE]

❯ scoop install postgresql
Installing '7zip19.00-helper' (19.00) [64bit] from main bucket
7z1900-x64.msi (1.7 MB) [=================================================================================================] 100%
Checking hash of 7z1900-x64.msi ... ok.
Extracting 7z1900-x64.msi ... done.
Linking ~\scoop\apps\7zip19.00-helper\current => ~\scoop\apps\7zip19.00-helper\19.00
Creating shim for '7z1900-helper'.
'7zip19.00-helper' (19.00) was installed successfully!
Installing 'postgresql' (15.1) [64bit] from main bucket
Loading postgresql-15.1-1-windows-x64-binaries.zip from cache
Checking hash of postgresql-15.1-1-windows-x64-binaries.zip ... ok.
Running pre_install script...
Linking ~\scoop\apps\postgresql\current => ~\scoop\apps\postgresql\15.1
Creating shortcut for pgAdmin 4 (pgAdmin4.exe)
Persisting data
Running post_install script...
'postgresql' (15.1) was installed successfully!
Notes
-----
Run run 'pg_ctl start' or 'pg_ctl stop' to start and stop the database or
register it as a service by running 'pg_ctl register -N PostgreSQL' from an elevated shell.
Default superuser login: postgres, password: <blank>
~ took 22s
❯ Get-Command pg_ctl

CommandType     Name                                               Version    Source
-----------     ----                                               -------    ------
Application     pg_ctl.exe                                         15.0.1.22… C:\Users\humorce\scoop\apps\postgresql\current\bin\p…

~
❯ pg_ctl --version
pg_ctl (PostgreSQL) 15.1

Cannot reproduce.

• Close entire Windows Terminal process(this case) and retry.
• Run direct:

❯ cd (scoop prefix postgresql)
❯ .\bin\pg_ctl.exe --version
pg_ctl (PostgreSQL) 15.1

Troubleshooting:

...
"env_add_path": "bin",
...

Please check that ...\postgresql\current\bin is added to $env:PATH.

[HUMORCE]

scoop install sudo 
scoop install gsudo

[HUMORCE]

I am not sure what your actual question is, but you mentioned:

when I opened my terminal in admin mode and try to run it, the pg_ctl command was not found. How am I supposed to do this?

pg_ctl can be found in any session when I reproduce this.

[ekawatani]

@HUMORCE I opened PowerShell, run scoop install postgresql. Then, I have access to pg_ctl inside this shell. This works as expected. But, when I open PowerShell in admin mode, then pg_ctl doesn't exist. It seems I had to use sudo from the non-elevated shell.

By the way, the user where I'm logged in is not a admin user. (If you are on Windows 11, go to Settings > Accounts > Email & accounts, then you can add a non-admin user. That's how I added mine.) Maybe this has something to do with it.

[HUMORCE]

Install postgresql in user A(non-admin) and run it through user B(admin)? then you get the prompt: not found (in PATH).

Operations requiring elevated privileges must be performed by admin user.(in this case: creating service)

https://github.com/ScoopInstaller/Scoop/wiki/Global-Installs

[ekawatani]

Thanks for clarifying. For now, I decided to do exactly that. I installed using the admin account.