![]() Postgres | postgres | UTF8 | English_United States.1252 | English_United States.1252 | ![]() Name | Owner | Encoding | Collate | Ctype | Access privileges ![]() A quick demonstration should illustrate the error and support explaining why it occurs on the Windows OS.Īttempting to connect to the PostgreSQL database as a non- postgres user: This error doesn’t occur in Linux because you most likely connected as the postgres user before trying to connect to the PostgreSQL database. The reason you need to restart the Windows CLI is that the %PATH% environment variable is inherited at startup and doesn’t change in an open Windows CLI shell.Īnother common mistake some users make, at least those who have used an older version of the psql utility on a Linux distribution (or “distro”), is to type psql without any arguments to become the superuser. While it won’t do any harm, it’s best to follow the new convention or style.ĬRITICAL NOTE: The rest of the post assumes you have set the correct %PATH% environment variable or added it to your System’s Path environment variable and restarted the Windows CLI after adding it through the GUI tool. If you were to put the semicolon between the %PATH% and new directory path there would be two semicolons together. Set PATH=%PATH% C:\Program Files\PostgreSQL\14\bin įor those familiar with Windows CLI navigation in prior releases, the convention is to append a semicolon at the end of the item added to the %PATH% environment variable. Set PATH= % PATH % C:\Program Files\PostgreSQL\14\bin
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |