A series of problems and solutions for the novice installation of PostgreSQL (the problem is very large)

Source: Internet
Author: User
Tags postgresql postgis



System WIN10, installing PostgreSQL and PostGIS.



Initially installed in the official website to download the PostgreSQL9.5 version, encountered a lot of problems, and later replaced by 9.4.4, experienced 3 days, finally installed successfully.



Quietly said: I think I am about to have all the problems should not have encountered the T-T, very heart tired ...












Here are some of the specific errors, as well as my forum and Bo asked users to help solve the process record:


    • keyword #firewall # #error running Netsh.ese advfirewall#
    • This error is about the firewall, at the beginning of the problem, we all feel that there is no firewall issues.
      The problem is that I disabled the firewall a few days ago, causing the rule write to fail.
    • workaround : Turn on the Firewall service in system services. (Note is in the service)











*************************************************************************************************************** **************************************************



Then meet a series of problems, try too much unclear, including folder permissions, need to give users Full Control permissions .


    • After installing PostgreSQL, there was a problem installing PostGIS with "have to is installed to thePostgreSQL folder" and terminated the installation.
    • workaround : Set the installation path for PostGIS to be identical to PostgreSQL ! (same level to PostgreSQL bin directory)
      For example, the installation path for my PostGIS is D:\Program files\postgresql\9.4












































*************************************************************************************************************** **********************************************



There is also a failure to create a spatial database such as the last occurrence of PostGIS in the installation spatial databases creation failed


    • workaround : 1. I change the version to 9.4.4 and its corresponding PostGIS
      2. Run as administrator during installation
      3.postgresql installation, data does not select the default path, not the xxxx\postgresql\9.4 path
      4.postgresql installation, manually select the language as Simplified Chinese, not the default.
      The above for the various solutions seen on the Internet to pay attention to, do not know which works, no validation.





*************************************************************************************************************** *********************************************



Even if you encounter so many problems, and finally successfully installed, in the run Pgadimin, there is a problem ... T T



After you connect to the server and enter the password, the following error occurs. Authentication failed.


  • keyword #Error connecting to the server# #用户 password Authentication failed #
  • Later on, I felt that the problem was really big. About user rights for the WIN10 system . ("Xia" is the native login user name)
  • After the online review, 1. A video has the same problem, the original installation path from the C-drive to the D-Disk will not have this problem.
    But it didn't work for me.
    2. Create a local user Postgres, giving administrator privileges. (Method self-Baidu)
  • workaround : I log on to the computer with the newly created local user, the installation is smooth, the connection is successful . Everything is perfect!
    But with the user I used to log in to Windows, all the same as usual. (I really don't know why O (╥﹏╥) o)
    In the spirit or want to use the original user, easy to view the original user information ideas, I uninstalled the software.
    A new issue occurred while reinstalling. ╮(╯▽╰)╭ See the next one.





*************************************************************************************************************** ********************************************












I finally met the problem!!!!

When reinstalling PostgreSQL, quote Failed to load SQL modules into the database cluster during PostgreSQL installation error.
This problem Baidu can feel the companion has changed a lot. O (* ̄︶ ̄*) o


  • Workaround :
  • 1. Install the incomplete PostgreSQL software through the installation directory of the Uninstall-postgresql.exe to uninstall completely.

    2. Create a Windows local user named Postgres, have a tutorial online (refer to https://www.ithome.com/html/win10/237491.htm), set the local user's password (useful below), and set it as an administrator. Then in the folder where you want to install PostgreSQL (such as a new folder named PostgreSQL on D-Disk), right-click Properties-Security-edit-Add, add PostgreSQL user to "group or user name", and set it to Full Control permissions.

    3. Restart the computer, still log in with your original local account, and then open the cmd command line input: Runas/user:postgres cmd.exe.

    Then enter your local user postgres password (just set, note is not your database login password), command line on the password is not visible, so to blind lose correctly Oh ~ then you will see "try to jump to the user named" Postgres ' open cmd command line, wait for about half a minute, will pop up a new cmd command line input box, type the address, go to open the installation package of Postgresql.exe under your existing folder.

    4. Then, step-by-step, just pay attention to the installation directory settings in the folder you just added Postgres Local users.


    Original: 77620907

  • there is another point to note: For example, I installed the software on the D drive, in advance to create the good one folder under the path, set permissions, and do not forget to add new users to the folder in the user group ,
  • and give it full access. (I don't know if that's necessary, but I did)

  • The original is also translated from foreign netizens, foreign users original answer: 50457624
  • Read the original English answer, the author said that after the installation is successful, the newly created local user postgres deleted, I actually can install the practice,

  • However, when running Pgadmin is still an old problem, authentication fails. Instead, it runs under the Postgres user and can connect successfully. such as ↓




  • Enter the password, the connection is successful!!? 's Finger licking (°▽°) Dentetsu?











Not a summary summary


    • Finally, it can be used under the original user login, but run the software under other users from the command line.
    • I still don't understand why the newly created local user and the original user have the same permissions, but there are different results.
    • In some places to see a foreign user write the reason, probably is the installation system changes the location of users, resulting in the install when the system will be incorrectly identified. I don't quite understand, and I think my users location is the default. Hope to have an understanding of the netizen can give answers. ^_^
    • Do not know this way to run later use will not appear inconvenient, then say it later (⊙︿⊙)





A series of problems and solutions for the novice installation of PostgreSQL (the problem is very large)


Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.