1 {%extends
"base/base.html" %}
3 {%block title%}The world's most advanced open source database{%endblock%}
5 <meta name=
"description" content=
"The official site for PostgreSQL, the world's most advanced open source database" />
8 <div class=
"jumbotron jumbotron-fluid pg-jumbotron">
9 <div class=
"container">
10 <h1 class=
"text-white pg-jumbotron-header">PostgreSQL: The World's Most Advanced Open Source Relational Database
</h1>
12 <div class=
"col text-center">
13 <a class=
"btn btn-light btn-rounded" role=
"button" href=
"/download/">Download
<i class=
"fa fa-arrow-right" aria-hidden=
"true"></i></a>
14 <a class=
"btn btn-light btn-rounded" role=
"button" href=
"/about/">New to PostgreSQL?
</a>
19 <!-- END Jumbotron -->
20 <div class=
"container margin">
21 <!-- Start First Feature Row -->
25 <div class=
"col-lg-6 feature">
26 <img src=
"/media/img/about/press/elephant.png" alt=
"PostgreSQL Elephant Logo">
27 <h2>New to PostgreSQL?
</h2>
30 PostgreSQL is a powerful, open source object-relational database system with over
30 years of active development
31 that has earned it a strong reputation for reliability, feature robustness, and performance.
34 There is a wealth of information to be found describing how to
<a href=
"{{link_root}}/download/">install
</a> and
<a href=
"{{link_root}}/docs/">use
</a> PostgreSQL through the
<a href=
"{{link_root}}/docs/">official documentation
</a>.
35 The PostgreSQL community provides many helpful places to become familiar with the technology, discover how it works, and find
36 career opportunities. Reach out to the community
<a href=
"{{link_root}}/community/">here
</a>.
39 <a href=
"{{link_root}}/about/" title=
"Read More"><button type=
"button" class=
"btn btn-center btn-primary">Read More
</button></a>
44 <div class=
"col-lg-6 feature">
45 <i class=
"fas fa-download"></i>
46 <h2>Latest Releases
</h2>
50 2019-
10-
03 - PostgreSQL
12 Released!
54 The PostgreSQL Global Development Group today announced the release of
55 <a href=
"/about/news/1976/">PostgreSQL
12</a>, the latest version of
56 the world's
<a href=
"/">most advanced open source database
</a>.
59 <a href=
"/docs/12/release-12.html">PostgreSQL
12 enhancements
</a>
60 include notable improvements to query
61 performance, particularly over larger data sets, and overall space
62 utilization. This release provides application developers with new
64 <a href=
"/docs/current/functions-json.html#FUNCTIONS-SQLJSON-PATH">SQL/JSON path expression
</a>
65 support, optimizations for how common table expression (
<code>WITH
</code>)
66 queries are executed, and
<a href=
"/docs/current/ddl-generated-columns.html">generated columns
</a>.
69 The PostgreSQL community continues to support the extensibility and
70 robustness of PostgreSQL, with further additions to
71 internationalization, authentication, and providing easier ways to
72 administrate PostgreSQL. This release also introduces the
73 <a href=
"/docs/current/tableam.html">pluggable table storage interface
</a>,
74 which allows developers to create their own methods for storing data.
77 For more information, please see the
78 <a href=
"/docs/12/release-12.html">release notes
</a>.
79 <a href=
"/download/">Download PostgreSQL
12 here
</a>.
82 {% for v in versions %}
83 <li class=
"{% cycle '' 'pg-bg-gray' %}"><strong>{{ v.numtree }}.{{ v.latestminor }}
</strong> · {{ v.reldate|date:
"Y-m-d" }}
· <a href=
"/docs/{{ v.numtree }}/{{ v.relnotes }}">Notes
</a></li>
87 <a href=
"{{link_root}}/download/" title=
"Download"><button type=
"button" class=
"btn btn-center btn-primary">Download
</button></a>
88 <a href=
"{{link_root}}/support/versioning/" title=
"Why Upgrade?"><button type=
"button" class=
"btn btn-center btn-outline-secondary btn-inline-block">Why Upgrade?
</button></a>
89 <a href=
"{{link_root}}/support/security/" title=
"Security"><button type=
"button" class=
"btn btn-center btn-outline-secondary btn-inline-block">Security
</button></a>
94 <!-- END First Feature Row -->
95 <!-- Start Second Feature Row -->
98 <div class=
"col-lg-6 feature">
99 <i class=
"fas fa-calendar-alt"></i>
100 <h2>Upcoming Events
</h2>
103 {% for event in events %}
104 <li class=
"{% cycle '' 'pg-bg-gray' %} {% if not event.badged%}non-badged{% endif %}">
105 {% if event.badged %}
106 <img src=
"/media/img/PostgreSQL_Badge1.svg" class=
"community" alt=
"PostgreSQL Community Event">
108 {{ event.displaydate|safe }}
· <a href=
"/about/event/{{ event.id }}/">{{ event.title }}
</a>
113 <img src=
"/media/img/PostgreSQL_Badge1.svg" class=
"community" alt=
"PostgreSQL Community Event">
114 indicates that an event is recognised under the
<a href=
"/community/recognition/#conferences">community event guidelines
</a> and is directly helping the PostgreSQL community.
117 <a href=
"/about/events/" title=
"Check Schedule"><button type=
"button" class=
"btn btn-center btn-primary btn-inline-block">Check Schedule
</button></a>
118 <a href=
"/account/events/new/" title=
"Add Your Event"><button type=
"button" class=
"btn btn-center btn-primary btn-inline-block">Add Your Event
</button></a>
122 <div class=
"col-lg-6 feature">
123 <i class=
"fas fa-envelope"></i>
124 <h2>Mailing Lists
</h2>
127 The PostgreSQL
<a href=
"https://lists.postgresql.org" target=
"_blank">mailing lists
</a> enable you to interact with active community participants on subjects related to the development of PostgreSQL, discovering how to use PostgreSQL, or learning about upcoming events and product releases.
130 In order to manage your mailing list subscription, you need a
<a href=
"{{link_root}}/account/">PostgreSQL community account
</a>.
<a href=
"{{link_root}}/account/">Signing up
</a> is easy and gives you direct access to the
<a href=
"{{link_root}}/community/">global PostgreSQL community
</a>.
133 <a href=
"https://lists.postgresql.org" title=
"Subscribe"><button type=
"button" class=
"btn btn-center btn-primary">Subscribe
</button></a>
134 <a href=
"https://www.postgresql.org/list/" title=
"View Archives"><button type=
"button" class=
"btn btn-center btn-primary">View Archives
</button></a>
138 <!-- END Second Feature Row -->
141 <div class=
"container-fluid">
143 <div class=
"col-lg-6 cta cta-3"></div>
144 <div class=
"col-lg-6 cta-text">
145 <h2>Learning Opportunities Ahead
</h2>
146 <p class=
"text-left">
147 Want to learn more about PostgreSQL and help build the community? Come to one of the many events, local user groups,
& training sessions where you can meet experienced PostgreSQL users and enhance your database skills.
149 <a href=
"{{link_root}}/about/events/" title=
"Browse Events"><button type=
"button" class=
"btn btn-light btn-rounded">Browse Events
</button></a>
150 <a href=
"{{link_root}}/community/user-groups/" title=
"Browse User Groups"><button type=
"button" class=
"btn btn-light btn-rounded">Browse User Groups
</button></a>
156 <div class=
"container">
158 <div class=
"col-lg-7">
159 <h2 class=
"centered-lines">Latest News
</h2>
160 <!-- Featured Post -->
163 <a href=
"/about/news/1976/">PostgreSQL
12 Released
</a>!
166 <li><i class=
"far fa-clock"></i> 2019-
10-
03</li>
167 <!--<li><i class="far fa-comments"></i> 0</li>-->
171 The PostgreSQL Global Development Group today announced the release of
172 <a href=
"/about/news/1976/">PostgreSQL
12</a>, the latest version of
173 the world's
<a href=
"/">most advanced open source database
</a>.
176 <a href=
"/docs/12/release-12.html">PostgreSQL
12 enhancements
</a>
177 include notable improvements to query
178 performance, particularly over larger data sets, and overall space
179 utilization. This release provides application developers with new
181 <a href=
"/docs/current/functions-json.html#FUNCTIONS-SQLJSON-PATH">SQL/JSON path expression
</a>
182 support, optimizations for how common table expression (
<code>WITH
</code>)
183 queries are executed, and
<a href=
"/docs/current/ddl-generated-columns.html">generated columns
</a>.
186 The PostgreSQL community continues to support the extensibility and
187 robustness of PostgreSQL, with further additions to
188 internationalization, authentication, and providing easier ways to
189 administrate PostgreSQL. This release also introduces the
190 <a href=
"/docs/current/tableam.html">pluggable table storage interface
</a>,
191 which allows developers to create their own methods for storing data.
194 <li><a href=
"/about/news/1976/">Release Announcement
</a></li>
195 <li><a href=
"/about/press/">PostgreSQL
12 Press Kit
& Translations
</a></li>
196 <li><a href=
"/docs/12/release-12.html">PostgreSQL
12 Release Notes
</a></li>
197 <li><a href=
"/download/">Download
</a></li>
199 <a href=
"/about/newsarchive/" title=
"Archives"><button type=
"button" class=
"btn btn-primary btn-center btn-inline-block">Browse Archives
</button></a>
200 <a href=
"/account/news/new/" title=
"Submit News"><button type=
"button" class=
"btn btn-primary btn-center btn-inline-block">Submit News
</button></a>
202 <div class=
"col-lg-5">
203 <div class=
"sidebar">
209 <h3><a href=
"/about/news/{{ n.id }}/">{{ n.title }}
</a></h3>
211 <li><i class=
"far fa-clock"></i> {{ n.displaydate }} by {{ n.org.name }}
</li>
216 <!-- END Archives -->
222 <div class=
"container margin">
224 <div class=
"col-md-12">
225 <h2 class=
"centered-lines"><span>PLANET POSTGRESQL
</span></h2>
226 <div class=
"feature"><i class=
"fas fa-globe"></i></div>
229 <!-- First Row Planet PostgreSQL -->
231 <!-- First Column First Row Planet PostgreSQL -->
232 {%for post in planet %}
233 <div class=
"col-md-4">
234 <div class=
"text-center">
235 <h3><a href=
"{{ post.url }}">{{ post|planet_title }}
</a></h3>
237 <li><i class=
"far fa-comments"></i> {{ post|planet_author }}
</li>
238 <li><i class=
"far fa-clock"></i> {{ post.date }}
</li>
244 <!-- END First Row Planet PostgreSQL -->
246 <div class=
"col-sm-12">
247 <a href=
"https://planet.postgresql.org" title=
"Browse Archives" target=
"_blank"><button type=
"button" class=
"btn btn-center btn-primary">Browse Archives
</button></a>
251 <!-- SUBMIT A BUG -->
252 <div class=
"container-fluid">
254 <div class=
"col-lg-6 cta-text">
255 <h2>Seeing unexpected behavior?
</h2>
257 The PostgreSQL community takes pride in releasing software that will reliably store your data. If you believe you've discovered a bug, please click the button below and follow the instructions on how to submit a bug.
259 <a href=
"/account/submitbug/" title=
"Submit a Bug"><button type=
"button" class=
"btn btn-light btn-rounded">Submit a Bug
</button></a>
261 <div class=
"col-lg-6 cta cta-2"></div>
264 <!-- END SUBMIT A BUG -->