Profile

Cover photo
Verified name
17,339 followers|412,253 views
AboutPostsPhotosVideos

Stream

PostgreSQL

Shared publicly  - 
 
PostgreSQL 9.5.2, 9.4.7, 9.3.12, 9.2.16, and 9.1.21 are out.  Particularly important to read the release notes if you're on 9.5: http://www.postgresql.org/about/news/1656/
The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 9.5.2, 9.4.7, 9.3.12, 9.2.16, and 9.1.21. This release fixes two security issues and one index corruption issue in version 9.5. It also contains a variety of bug fixes for ...
46
17
Add a comment...

PostgreSQL

Shared publicly  - 
 
PostgreSQL 9.5.1, 9.4.6, 9.3.11, 9.2.15, and 9.1.20 are out.
The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 9.5.1, 9.4.6, 9.3.11, 9.2.15, and 9.1.20. This release fixes two security issues, as well as several bugs found over the last four months. Users vulnerable to the security ...
61
13
Add a comment...

PostgreSQL

Shared publicly  - 
 
PostgreSQL 9.5 is finally here!
7 JANUARY 2016: The PostgreSQL Global Development Group announces the release of PostgreSQL 9.5. This release adds UPSERT capability, Row Level Security, and multiple Big Data features, which will broaden the user base for the world's most advanced database. With these new capabilities, ...
162
64
Holger Müller's profile photoTomasz Rybak's profile photoTim Sailer's profile photoIgnacio Vásquez's profile photo
8 comments
 
Can I Call function with dynamic schema name?
example: name_schema.table.
Add a comment...

PostgreSQL

Shared publicly  - 
 
PostgreSQL 9.5 beta 2 is now out.  Please help test it to make sure we get everything fixed ready for final release.
The PostgreSQL Global Development Group announces today that the second beta release of PostgreSQL 9.5 is available for download. This release should contain all features and APIs which will be in the final release with few, if any, changes. Users should begin testing their applications against ...
65
10
Add a comment...

PostgreSQL
owner

News  - 
 
PostgreSQL 9.5 is now in beta.  Please help test it.
15
1
Add a comment...

PostgreSQL
owner

News  - 
 
Latest minor versions of PostgreSQL are now available for download.  It's recommended everyone update as soon as possible.
5
1
Add a comment...

PostgreSQL

Shared publicly  - 
 
Latest minor versions of PostgreSQL are now available for download.  It's recommended everyone update as soon as possible.
29
6
Add a comment...
Have them in circles
17,339 people
akmal hussin's profile photo
Wenderson Rodrigues Malheiros's profile photo
miltz5's profile photo
Polla Fattah's profile photo
Federico Gallo's profile photo
Xabier Ochotorena's profile photo
Nikola Stojanoski's profile photo
Min Wang's profile photo
dreamscookie's profile photo

Communities

PostgreSQL
owner

News  - 
 
 
PostgreSQL 9.5 is finally here!
7 JANUARY 2016: The PostgreSQL Global Development Group announces the release of PostgreSQL 9.5. This release adds UPSERT capability, Row Level Security, and multiple Big Data features, which will broaden the user base for the world's most advanced database. With these new capabilities, ...
8 comments on original post
31
4
Add a comment...

PostgreSQL

Shared publicly  - 
 
PostgreSQL 9.5 is almost here! Expect it later this week. Here's what you can expect.
(This page is currently under development ahead of the release of PostgreSQL 9.5). This page contains an overview of PostgreSQL Version 9.5's features, including descriptions, testing and usage information, and links to blog posts containing further information. See also PostgreSQL 9.5 Open ...
105
25
Koclok aja's profile photoAleksey Izmailov's profile photovictor noagbodji's profile photo
5 comments
 
+Aleksey Izmailov ikr? : )
Add a comment...

PostgreSQL

Shared publicly  - 
 
Which PostgreSQL 9.5 feature are you most looking forward to? (sorry, can only list 5 on these polls)
443 votes  -  votes visible to Public
IMPORT FOREIGN SCHEMA
11%
Row-level security policies
9%
INSERT ... ON CONFLICT DO NOTHING/UPDATE
45%
GROUPING SETS, CUBE and ROLLUP
11%
JSONB-modifying operators and functions
24%
30
7
Faustin Gashakamba's profile photoBruno Baguette's profile photoAnton Petrusevich's profile photo
16 comments
 
+Bruno Baguette what for? is it useful for psql? probably, but even there not much -- i haven't event thought about it for 7 years since i switched from mysql to postgresql.
Add a comment...

PostgreSQL

Shared publicly  - 
 
PostgreSQL 9.5 is now in beta.  Please help test it.
68
22
Tony Alves's profile photovictor noagbodji's profile photoHolger Jakobs's profile photo
3 comments
 
The alpha 1 was already good.
Add a comment...

PostgreSQL
owner

News  - 
 
PostgreSQL 9.5 Alpha 2 has been released.  We need as many testers as possible to ensure the functionality works and makes sense before going to beta.
12
5
Add a comment...
People
Have them in circles
17,339 people
akmal hussin's profile photo
Wenderson Rodrigues Malheiros's profile photo
miltz5's profile photo
Polla Fattah's profile photo
Federico Gallo's profile photo
Xabier Ochotorena's profile photo
Nikola Stojanoski's profile photo
Min Wang's profile photo
dreamscookie's profile photo
Communities
Story
Tagline
The world's most advanced open source database.
Introduction

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation.

An enterprise class database, PostgreSQL boasts sophisticated features such as Multi-Version Concurrency Control (MVCC), point in time recovery, tablespaces, asynchronous replication, nested transactions (savepoints), online/hot backups, a sophisticated query planner/optimizer, and write ahead logging for fault tolerance. It supports international character sets, multibyte character encodings, Unicode, and it is locale-aware for sorting, case-sensitivity, and formatting. It is highly scalable both in the sheer quantity of data it can manage and in the number of concurrent users it can accommodate. There are active PostgreSQL systems in production environments that manage in excess of 4 terabytes of data.