-
Notifications
You must be signed in to change notification settings - Fork 3
/
README-linux-x64.txt
199 lines (130 loc) · 7.42 KB
/
README-linux-x64.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
188
189
190
191
192
193
194
195
196
197
Welcome to Postgres Installer by 2ndQuadrant
============================================
Postgres Installer 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
. Kerberos
. ICU
. Perl
. Tcl
. LLVM
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__
Open terminal and type following commands
. Status: sudo service "__SRVC_NAME__" status
. Start: sudo service "__SRVC_NAME__" start
. Stop: sudo service "__SRVC_NAME__" stop
Connect to PostgreSQL via psql
==============================
. Open terminal
. Change directory: cd __PGHOME__/bin
. Connect with PostgreSQL by via psql client: ./psql -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
==================
Open terminal and follow these steps
. Change directory: cd __OMNIHOME__/omnidb-server
. Start OmniDB server: ./omnidb-server
. Port number will be shown inside the terminal once server is started
. Open your favorite browser and type in following URL to connect with OmniDB: http://localhost:Port_Number --default OmniDB port is 8000
. Once you can see the OmniDB login screen please enter following credentials
User name = admin
Password = admin
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 fuzzystrmatch; -- needed for postgis_tiger_geocoder
-- optional used by postgis_tiger_geocoder,
-- or can be used standalone
. 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
Set PostGIS DATA directory path by running following command inside PSQL.
. set postgis.gdal_datapath = '__PGHOME__/gdal';
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 terminal
. 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
==============
. Open terminal
. Connect to 'psql'
. Run query 'CREATE LANGUAGE pltcl;'
LLVM
====
Just-in-Time (JIT) compilation is the process of turning some form of interpreted program evaluation into a native program, LLVM has support for optimizing generated code. Some of the optimizations are cheap enough to be performed whenever JIT is used, while others are only beneficial for longer-running queries. long running queries that are CPU bound will benefit from JIT compilation
NOTE: LLVM is only avialable in PostgreSQL-11 and above
. create table t1 (id serial);
. insert INTO t1 (id) select * from generate_series(1, 10000000);
. set jit = 'on'; set jit_above_cost = 10; set jit_inline_above_cost = 10; set jit_optimize_above_cost = 10;
. explain analyze select count(*) from t1; -- See JIT section for results
. explain (analyze, verbose, buffers) select count(*) from t1; -- See JIT section for results
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