- 1 year ago
What causes "More is not recognized..." error when running Postgresql 11 on a Windows machine?
The error message "More is not recognized..." typically occurs when there is a problem with the PATH
environment variable on your Windows machine.
When you run a command in the command prompt, Windows searches for the executable file in the directories specified in the PATH
variable. If the command is not found in any of these directories, you will see the "is not recognized..." error.
To resolve this issue, you can try the following steps:
Verify that the PostgreSQL binaries are installed in the correct location. By default, PostgreSQL installs its binaries in the
C:\Program Files\PostgreSQL\11\bin
directory. Ensure that this directory exists and contains the necessary files.Check your system's
PATH
environment variable. Open a command prompt and typeecho %PATH%
to view the current value of thePATH
variable. Look for the PostgreSQL bin directory (C:\Program Files\PostgreSQL\11\bin
) in the output. If it's missing, you need to add it to thePATH
variable.- Open the System Properties dialog by pressing Win + Pause/Break or right-clicking on "This PC" and selecting "Properties".
- Click on "Advanced system settings" on the left-hand side.
- In the System Properties dialog, click on the "Environment Variables" button.
- In the "System variables" section, scroll down to find the
PATH
variable, select it, and click on the "Edit" button. - Add the PostgreSQL bin directory (
C:\Program Files\PostgreSQL\11\bin
) to thePATH
variable, separating it from existing entries with a semicolon (;). - Click "OK" to save the changes.
After modifying the
PATH
variable, open a new command prompt and try running the PostgreSQL command again to see if the error is resolved.
By ensuring that the PostgreSQL binaries are installed correctly and adding the PostgreSQL bin directory to the PATH
variable, you should be able to resolve the "is not recognized..." error and run PostgreSQL commands successfully.