-
Notifications
You must be signed in to change notification settings - Fork 3
/
README-windows.txt
187 lines (122 loc) · 6.7 KB
/
README-windows.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
Welcome to Postgres Installer by 2ndQuadrant
============================================
Postgres Installer by 2ndquadrant is a GUI based, user-friendly installer for PostgreSQL that is digitally signed and certified by 2ndQuadrant. The installer is currently available for PostgreSQL versions 9.5, 9.6, 10, 11, 12 and 13. Postgres Installer has the ability to run in graphical, command line, or quiet installation modes for Windows, macOS and Linux.
Features
========
Postgres Installer comes with features listed below. In addition to these, many are in pipeline and will be available in upcoming releases.
. OmniDB
. PostGIS
. OpenSSL
. Python3
. Zlib
. LDAP
. ICU
. Perl
. Tcl
For more details please visit.
https://www.2ndquadrant.com/en/resources/postgresql-installer-2ndquadrant/
Controlling PostgreSQL service
==============================
Once installer has completed installation successfully, following information should hold true for your platform.
. Service name: __SRVC_NAME__
NOTE: Open windows command prompt as administrator.
. Status: sc query "__SRVC_NAME__" | findstr /i "STATE"
--Above query should return RUNNING. If there is no output, it means PostgreSQL service is not running.
. Start: net start "__SRVC_NAME__"
. Stop: net stop "__SRVC_NAME__"
Connect to PostgreSQL via psql
==============================
Open windows command prompt
. Change directory: cd /d __PGHOME__\bin
. Connect with PostgreSQL by via psql client: psql.exe -U postgres -d postgres -p __PGPORT__
Type in your postgres superuser password. This should be the same as supplied during installation on Database Superuser Password screen
Once connected, you can key in SQL queries as you like. Please refer to psql documentation for help on using psql client.
https://www.postgresql.org/docs/9.4/static/app-psql.html
Connect to PostgreSQL via OmniDB
================================
OmniDB is an interactive and powerful, yet lightweight, browser-based database management tool. OmniDB allows users to manage multiple databases in a unified workspace with a user-friendly and fast-performing interface. Despite its light design, OmniDB is a reliable and comprehensive web tool with many facilitating characteristics to easily add, edit and manage multiple databases
NOTE: OmniDB being shipped as part of PostgreSQL-13 installers is not yet fully compatible with PostgreSQL-13 and therefore not all features in OmniDB are guaranteed to work. Work on PostgreSQL-13 compatibility is underway and will be made available in the upcoming releases of Postgres Installer.
Usage instructions
==================
. Change directory: __OMNIHOME__
. Double click on "omnidb-app.exe" to start OmniDB
For detailed instructions on usage please visit: https://omnidb.org/en/documentation-en/
For more OmniDB details and features please visit
. https://www.2ndquadrant.com/en/resources/omnidb/
. https://www.omnidb.org/en/
Getting started with PostGIS
============================
PostGIS is a spatial database extender for PostgreSQL object-relational database. It add support for geographic objects allowing location queries to be run in SQL.
Some of the extensions required for PostGIS.
. CREATE EXTENSION postgis;
. CREATE EXTENSION postgis_sfcgal;
. CREATE EXTENSION fuzzystrmatch; -- needed for postgis_tiger_geocoder
-- optional used by postgis_tiger_geocoder,
-- or can be used standalone
. CREATE EXTENSION address_standardizer;
. CREATE EXTENSION address_standardizer_data_us;
. CREATE EXTENSION postgis_tiger_geocoder;
. CREATE EXTENSION postgis_topology;
NOTE: GDAL DATA will need to be configured manually based on where you have placed it. Path to default GDAL DATA directory is listed below:
. __PGHOME__\gdal-data
Set PostGIS DATA directory path by running following command inside PSQL.
. set postgis.gdal_datapath = '__PGHOME__\gdal-data';
Please refer to PostGIS documentation here (https://postgis.net/docs/postgis_gdal_datapath.html) on how you can configure GDAL DATA directory for your platform.
Please visit PostGIS official website for more details about PostGIS.
https://postgis.net/
Introduction to ICU
===================
ICU stands for International Components for Unicode. It provide the ability to handle postgres database and run queries on your local language i,e.
. English
. French
. German
. Italian
And many more of course. You can run query below to see which languages are supported
NOTE: Database encoding needs to be set before using ICU.
. create database db_name ENCODING 'UTF-8';
. select * from pg_collation;
NOTE: ICU is not supported on PostgreSQL 9.5 and 9.6
Introduction to Perl
====================
PL/Perl (Procedural Language/Perl) is a procedural language supported by the PostgreSQL RDBMS.
PL/Perl, as an imperative programming language, allows more control than the relational algebra of SQL. Programs created in the PL/Perl language are called functions and can use most of the features that the Perl programming language provides,
Setting up Perl
===============
. Open 'cmd' as an administrator
. Go to __PGHOME__\bin
. serverctl.vbs restart
. Connect to 'psql'
. Run query 'CREATE LANGUAGE plperl;'
And you are done now you can create any function that you want
Introduction to Tcl
===================
PL/Tcl is a loadable procedural language for the PostgreSQL database system that enables the Tcl language to be used to write functions and trigger procedures.
Setting up Tcl
==============
NOTE: If you have already restart the service via "serverctl.vbs" then please skip first 3 steps.
. Open 'cmd' as an administrator
. Go to __PGHOME__\bin
. serverctl.vbs restart
. Connect to 'psql'
. Run query 'CREATE LANGUAGE pltcl;'
Want to learn more about PostgreSQL?
====================================
The Postgres Learning Center from 2ndQuadrant is place to connect, gather ideas, and enhance knowledge about open source PostgreSQL.
Explore interactive webinars, hands-on training and courses, insightful videos, technical whitepapers, and best-selling PostgreSQL books.
Please use the link below to access PostgreSQL Learning Center
https://www.2ndquadrant.com/en/postgres-learning-center/?utm_campaign=Postgres%20Learning%20Center&utm_source=installer&utm_medium=readme
Bug Reports and Feedback
========================
For bug reports and feedback, please contact via pginstaller@2ndquadrant.com or use our contact form on our Postgres Installer page:
https://www.2ndquadrant.com/en/resources/postgresql-installer-2ndquadrant/
Contact Us
==========
2ndQuadrant Ltd
7200 The Quorum
Oxford Business Park North
Oxford, OX4 2JZ
United Kingdom
Phone: +44 870 766 7756
Fax: +44 870 838 1077
Email: info@2ndQuadrant.com
For detailed queries please visit our website: https://2ndQuadrant.com