Manually installing PostgreSQL on Windows with a free-install version

Source: Internet
Author: User

PostgreSQL supports the administrator to manually install the database directly, providing users with greater convenience.
1. Download the free binary package on the PostgreSQL official website with the name similar to postgresql-*.*.*.*-binaries-no-installer.tar.gz. Download it locally and unzip it to a path.
2. Create the Data folder in the path directory to hold the information.
3. Start-and-run-->cmd into the command line. and CD to the Path\bin directory, execute the following command to initialize the database:

path\bin> initdb.exe-d path\data-e UTF8--locale=c

4. Register Pgsql as a Windows service for ease of operation and control:

path\bin> Pg_ctl.exe register-d path\data-n pgsql

where the-n parameter is used to set Pgsql as the name of the Windows service.

5. Start and close the database at the command line:

> net start pgsql (Open database)

> net stop pgsql (Close database)

Note: In order to avoid possible later in the sub-state large character set garbled problem, unified use UTF8 encoding.

Manually installing PostgreSQL on Windows with a free-install version

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.