Shulou(Shulou.com)05/31 Report--

This article mainly introduces the method of using Windows to install PostgreSQL, which is very detailed and has a certain reference value. Friends who are interested must read it!

Now when it comes to free databases, the first thing that comes to mind for most people is MySQL. Indeed, MySQL has been used in many fields in China, especially in website construction. However, in fact, the most powerful, feature-rich, and complex free database should be PostgreSQL. The following editor explains how to use Windows to install PostgreSQL?

How to install PostgreSQL using Windows

Download PostgreSQL for Windows

Log in to http://www.postgresql.org/ftp/binary/v8.1.0/win32/ and download the latest version: postgresql-8.1.0-1.zip with a file size of 20.4m and support for multilingual installation.

Start installation

After downloading the installation file to your local location, unpack the package with the unzip tool, and then double-click postgresql-8.1.msi to start the installation wizard, just like any other Windows application.

How to install PostgreSQL using Windows

The first is to choose the language used in the installation process, the author found one side did not find Chinese, had to choose to be able to read and understand English ^ _ ^. In addition, you can select the option at the bottom to write a detailed installation log to the current installation directory to troubleshoot the installation, or you can read about its installation process.

The next step is to select the option to install the content, which is divided into four parts, namely, database server side, user interface, database driver and development module. You can choose to install according to your needs. In order to know more, the author installed all four parts. It is also important to note here that the data directory option can only be installed in a partition in NTFS format. If you want to install in a partition in another format, you need to run Initdb.exe manually after installation.

Tip: if you prefer to use a graphical interface to manage and manipulate the database, you can choose to install pgAdminIII in the user interface.

Then there is the service configuration, where you can run the database server as a system service for Windows, which is a sign that Postgresql is starting to support Windows installation.

The above is all the contents of this article entitled "how to install PostgreSQL using Windows". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.