Windows PostGIS (compressed edition) installation

Source: Internet
Author: User
Tags psql postgis server port


PostGIS Installation

1. Software download

Postgresql-9.6.1-1-windows-x64-binaries.zip

https://www.postgresql.org/download/windows/

Postgis-bundle-pg96-2.3.1x64.zip

http://download.osgeo.org/postgis/windows/pg96/


2. Unzip the Postgresql.zip

Unzip the postgresql-9.6.1-1-windows-x64-binaries.zip to the installation directory you want (D:\GreenSoftware\PostgreSQL961), it is best not to have Chinese or space,


3. Create a data storage directory (D:\GreenSoftware\PostgreSQL961\data)


4. Initializing the database

D:\GreenSoftware\PostgreSQL961\bin\initdb.exe-D D:\GreenSoftware\PostgreSQL961\data-E UTF8--locale=chinese


5. Start the database in one of two ways

5.1 First way: Registering as a Windows service mode

5.1.1 Registration Service

D:\GreenSoftware\PostgreSQL961\bin\pg_ctl.exe register-d D:\GreenSoftware\PostgreSQL961\data-Npgsql

-n indicates that the Windows service name is Pgsql;


5.1.2 Start Service

net start Pgsql

If your installation is not an error, you should be able to get up now.


5.1.3 Close Service

net stop Pgsql


5.1.4 Uninstall Service

D:\GreenSoftware\PostgreSQL961\bin\pg_ctl.exe unregister-d D:\GreenSoftware\PostgreSQL961\data-Npgsql


5.2 Second way: Direct start mode

5.2.1 Start

D:\GreenSoftware\PostgreSQL961\bin\pg_ctl.exe Start-w-D D:\GreenSoftware\PostgreSQL961\data


5.2.2 off

D:\GreenSoftware\PostgreSQL961\bin\pg_ctl.exe Stop-w-D D:\GreenSoftware\PostgreSQL961\data


6 Creating a Database

D:\GreenSoftware\PostgreSQL961\bin\createdb.exe-E UTF8 Geodb

D:\GreenSoftware\PostgreSQL961\bin\dropdb.exe Geodb


7 Creating a user

D:\GreenSoftware\PostgreSQL961\bin\createuser.exe-s-R Postgres

There will be an option to create a superuser, create a superuser named Postgres;

How to use:

CreateUser [Options] ... [User Name]

Options:

-C, connection limit for--connection-limit=n role (default: No Limit)

-D,--createdb this role can create a new database

-D,--no-createdb this role is not available to create a new database

-E,--echo Show commands sent to the server

-E,--encrypted password encrypted storage

-I, the--inherit role can inherit the permissions of the role it belongs to

(This is the default)

-I,--no-inherit role does not inherit permissions

-L,--login role can log on (this is the default)

-L,--no-login role cannot log on

-N,--unencrypted password unencrypted storage

-P,--pwprompt assigning a password to the new role

-R,--createrole This role can create a new role

-R,--no-createrole This role does not have permissions to create other roles

-S,--superuser role will be super user

-S, the--no-superuser role cannot be a super user

--HELP Display this help message, and then exit

--version output version information, and then exit

Join options:

-H, the host name or socket directory of the machine where the--host=hostnam database server resides

-p,--port=port database server port number

-U,--username=username join user (not the user name to be created)

-W,-no-password never prompt to enter a password

-W,--password Force prompt for password

If-D,-R,-R,-S,-S, and ROLENAME are not specified, an interactive prompt will be used

You.

Bug report to <[email Protected]>.

Example 1:>createuser-p-d-u postgres dan

Explanation:-P (uppercase) is to specify a password for the new user;-D says whether the role can create a database;-U (uppercase) The current operation is issued by which user; The last Dan is the name of the new user.

Add:

View users in the system: SELECT * from Pg_user;

Delete a User: Drop the user Dan, where Dan is the username

D:\GreenSoftware\PostgreSQL961\bin\dropuser.exe Postgres


7.1 Modifying user passwords

7.1.1 First way: Apply the Psql command

D:\GreenSoftware\PostgreSQL961\bin\psql.exe Postgres

postgres=# alter user postgres with password ' GIS ';

postgres-# \q


7.1.2 Second way: To modify with Pgadmin

With Pgadmin connection to the server, you can directly modify the password;


8 Unzip the Postgis-bundle-pg96-2.3.1x64.zip

Unzip the postgis-bundle-pg96-2.3.1x64.zip to a directory without Chinese or white space.


9 Modify Makepostgisdb_using_extensions.bat File


10 importing spatial data into PostGIS


11 displaying spatial data in PostGIS


12 Handling Extranet Access

1. Modify the D:\GreenSoftware\PostgreSQL961\data\pg_hba.conf file

Add the following text:

Host All 192.168.1.0/24 MD5


2. Modify the D:\GreenSoftware\PostgreSQL961\data\postgresql.conf file

Add the following text:

Will

#listen_addresses = ' 127.0.0.1 '

Switch

listen_addresses = ' * '


Problem:

1.

Compressed version of the PostgreSQL10.0 installation is complete, the pgadmin always error when opening the "the application server could not be contacted."

Because 1 empty files are missing:

Pgadmin 4/venv/lib/site-packages/backports/__init__.py

Create a pgadmin to work properly!

Windows PostGIS (compressed edition) installation

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.