フィードアグリゲーター

Interview with Sebastian Feldmann

planet PHP - 2019-06-25(火) 22:31:00
カテゴリー: php

Postgresの最新事情をアップデート。EDB Postgres Vision Tokyo 2019開催!

www.postgresql.jp news - 2019-06-25(火) 13:00:01
Postgresの最新事情をアップデート。EDB Postgres Vision Tokyo 2019開催! senda 2019/06/25 (火) - 13:00
カテゴリー: postgresql

Mark Wong: PDXPUG July Meetup at OSCON: New things coming to Postgres 12

planet postgresql - 2019-06-25(火) 08:31:25

Note location for the July meeting is at OSCON!

When: 7-9pm Wednesday July 17, 2019
Where: Oregon Convention Center Room D135/136

New versions of PostgreSQL usually get released every fall with lots of improvements and new features. Come hear about some of the highlighted changes expected to come in the next new release!

This special edition meetup also welcomes any OSCON attendee.  Also come and meet the local Portland PostgreSQL user group to ask any PostgreSQL related questions!
カテゴリー: postgresql

Installing The Latest PHP on Ubuntu

planet PHP - 2019-06-25(火) 00:23:00

In the past I’ve written up installing various versions of PHP on new releases of Ubuntu, or for new releases of PHP. In those posts I’ve often recommended compiling PHP from scratch. However, compiling PHP from scratch is a serious chore, and keeping it up to date is even more of a serious responsibility. There […]

The post Installing The Latest PHP on Ubuntu appeared first on BrandonSavage.net.

カテゴリー: php

Jobin Augustine: Managing Multiple PostgreSQL Instances on Ubuntu/Debian

planet postgresql - 2019-06-24(月) 23:46:14
Introduction

Those DBAs who are experts in one database system look for other database systems to have “similar features”. It is a human tendency to look at any new technology and compare it with a world they are familiar with. Most of the time, I keep addressing Oracle DBAs who are looking for similar features or setup in PostgreSQL, but this time it is for MySQL DBA. MySQL historically ships mysqld_multi to manage multiple instances of MySQL on a server. Even though this is not a core feature in MySQL, but rather a wrapper, I understand that it is something widely used and my college Fernando blogged about it.

In a discussion a few months back, one of my friends asked how PostgreSQL manages multiple instances and I agreed to write on that as it will be useful for anyone who looks for a similar setup. In short, the answer is that the PostgreSQL community manages it using wrapper scripts and the Linux service manager. During this time, systemd started becoming a standard among Linux distros and every Linux package started relying on it for service management. To my surprise, some of the MySQL packages started removing mysqld_multi from the bundle and started moving towards systemd as the way to manage multiple instances. So everything is getting converged to systemd in the new world. In this blog, I want to show how this can be done on Ubuntu/Debian Linux because all necessary wrapper scripts already exist on those distros as part of postgres-common package which gets installed by default with every PostgreSQL installation. Nothing prevents us from doing a similar wrapper on other Linux distros also.

$ dpkg -l | grep postgresql-common ii postgresql-common 201.pgdg18.10+1 all PostgreSQL database-cluster manager Default Installation

The default installation of PostgreSQL from apt repo of postgresql.org will contain postgresql-common backage for Debian/Ubuntu.

$ sudo apt install postgresql-11 Reading package lists... Done ... The following additional packages will be installed: libllvm7 libpq5 libsensors4 pgdg-ke[...]
カテゴリー: postgresql

The 7th Annual China PHP Conference

php.net - 2019-06-24(月) 20:01:22
カテゴリー: php

Bruce Momjian: Postgres 12 Features Presentation

planet postgresql - 2019-06-23(日) 19:00:01

Now that I have given a presentation about Postgres 12 features in Ibiza, I have made my slides available online.

カテゴリー: postgresql

Avinash Kumar: Hypothetical Indexes in PostgreSQL

planet postgresql - 2019-06-22(土) 03:02:17

At recent conferences, we have received a curious question from users who have used Oracle in the past and are now using PostgreSQL: “Do we have hypothetical indexes in PostgreSQL ?“. The answer to that question is YES. The true meaning of hypothetical is imaginary but not real. We can try creating indexes that are imaginary for the PostgreSQL optimizer which don’t exist in reality. Let’s look at some detailed examples.

How are hypothetical indexes helpful?

The execution time of an SQL in most of the relational databases depends on the cost of the execution. An optimizer chooses the plan that has the lowest cost, and thus considers further phases such as execute and fetch using that plan. One of the easiest ways of optimizing a well-written SQL is through appropriate indexes that are suitable for that query. An index may reduce the number of pages fetched from disk and may live in the cache due to its size (<<< table size). So, indexing is always a low-hanging fruit for admins and developers wishing to tune an SQL.

But often developers wish to see if an index can be really helpful. The only option available is to create the index and check to see if the queries are able to use it with a reduced cost. Creating the index may be fine if it is in a test environment, or a table that is not huge in size, but if for some reason you wish to see if an index can be helpful for an SQL without actually creating it, then you may test and try this extension to create hypothetical indexes.

PostgreSQL Extension for hypothetical indexes

In order to achieve the functionality of creating imaginary indexes in PostgreSQL, we need to use an extension named hypopg. This extension is made available in the PGDG repository from PostgreSQL 9.2 and works until the latest active release PostgreSQL 11.3. In order to create this extension, you may just use yum or apt depending on your linux distro or compile it from source.

Installing hypopg

In RedHat/CentOS

# yum install hypopg

For Debian/Ubuntu, you must make sure you have the development p

[...]
カテゴリー: postgresql

Vasilis Ventirozos: CVE-2019-10164 Who's affected and how to protect your systems.

planet postgresql - 2019-06-22(土) 02:01:00

Yesterday, 20th of June Postgres community released minor version updates for all supported versions. (11.4, 10.9, 9.6.14, 9.5.18, 9.4.23, 12Beta2)
As with any minor version, it is recommended to upgrade and keep your database to the latest minor version. But this release is a bit more important 
than others because it includes a fix about a recently discovered CVE (CVE-2019-10164) 
From the release notes:

"This release is made outside of the normal update release schedule as the security
vulnerability was determined to be critical enough to distribute the fix as quickly as possible.
Users who are running PostgreSQL 10, PostgreSQL 11, or the PostgreSQL 12 beta should upgrade as soon as possible."

In this post i'll talk about this CVE. What this all about, who is affected and how to protect your systems against it.

What is this all about. A system authenticated user could change their own password with a "special crafted password" that could crash your database server or, 
worst case, have the operating system user who owns postgres executing arbitrary code. This is a bug on SCRAM authentication mechanism 
which is why it only affects postgres version 10 and above. Reality is that on some operating systems, for example ubuntu, the default compiler options
should prevent code execution (see here) and since an attack can only happen from a user that is already authenticated, this user, with enough privileges 
could potentially come up with an SQL statement that could DOS or even bring the service down. 
Of course, this doesn't mean that if you trust your users you shouldn't upgrade, you definitely should.. 
The latest pg versions also fix a second attack in libpq, a library that is extensively used by almost all common postgres clients
psql, psycopg2 and pgadmin4 included. In this attack a user connected from a server that runs software that uses libpq, 
say psycopg2 or psql could crash the client or run arbitrary code by exploiting the SCRAM authentication process. 
In this case the exploitation will happen on the[...]
カテゴリー: postgresql

11.4, 10.9, 9.6.14, 9.5.18, 9.4.23 リリース (2019-06-20)

www.postgresql.jp news - 2019-06-21(金) 13:44:55
11.4, 10.9, 9.6.14, 9.5.18, 9.4.23 リリース (2019-06-20) harukat 2019/06/21 (金) - 13:44
カテゴリー: postgresql

Michael Paquier: Postgres 12 highlight - SQL/JSON path

planet postgresql - 2019-06-21(金) 12:58:34

Postgres ships in-core data types for JSON with specific functions and operators (json since 9.2, and jsonb which is a binary representation since 9.4). The upcoming Postgres 12 is becoming more complaint with the SQL specifications by introducing SQL/JSON path language, introduced mainly by the following commit:

commit: 72b6460336e86ad5cafd3426af6013c7d8457367 author: Alexander Korotkov <akorotkov@postgresql.org> date: Sat, 16 Mar 2019 12:15:37 +0300 Partial implementation of SQL/JSON path language SQL 2016 standards among other things contains set of SQL/JSON features for JSON processing inside of relational database. The core of SQL/JSON is JSON path language, allowing access parts of JSON documents and make computations over them. This commit implements partial support JSON path language as separate datatype called "jsonpath". The implementation is partial because it's lacking datetime support and suppression of numeric errors. Missing features will be added later by separate commits. Support of SQL/JSON features requires implementation of separate nodes, and it will be considered in subsequent patches. This commit includes following set of plain functions, allowing to execute jsonpath over jsonb values: * jsonb_path_exists(jsonb, jsonpath[, jsonb, bool]), * jsonb_path_match(jsonb, jsonpath[, jsonb, bool]), * jsonb_path_query(jsonb, jsonpath[, jsonb, bool]), * jsonb_path_query_array(jsonb, jsonpath[, jsonb, bool]). * jsonb_path_query_first(jsonb, jsonpath[, jsonb, bool]). This commit also implements "jsonb @? jsonpath" and "jsonb @@ jsonpath", which are wrappers over jsonpath_exists(jsonb, jsonpath) and jsonpath_predicate(jsonb, jsonpath) correspondingly. These operators will have an index support (implemented in subsequent patches). Catversion bumped, to add new functions and operators. Code was written by Nikita Glukhov and Teodor Sigaev, revised by me. Documentation was written by Oleg Bartunov and Liudmila Mantrova. The work was inspired by Oleg Bartunov. Discussion: https://postgr.es/m/[...]
カテゴリー: postgresql

Jonathan Katz: Explaining CVE-2019-10164 + PostgreSQL Security Best Practices

planet postgresql - 2019-06-21(金) 11:30:49

The PostgreSQL Global Development Group provided an out-of-cycle update release for all supported  to provide a fix for the CVE-2019-10164 vulnerability. This vulnerability only affects people running PostgreSQL 10, 11 or the 12 beta, and it is effectively remediated by simply upgrading all of your PostgreSQL installations to the latest versions.

What follows is some more insight about what this vulnerability is, the impact it can have in your environment, how to ensure you have patched all of your systems, and provide some PostgreSQL security best practices that could help mitigate the impact of this kind of vulnerability.

カテゴリー: postgresql

murze.be: ★ Sending and receiving webhooks in Laravel apps

phpdeveloper.org - 2019-06-21(金) 01:00:01

A webhook is a mechanism where an application can notify an other application that something has happened. Technically, the application sends an HTTP request to that other application. In this blog post, I'd like to introduce you to two packages that we recently released. The first is laravel-webhoo...

カテゴリー: php

Laravel News: Immutable PHP Currency Converter

phpdeveloper.org - 2019-06-21(金) 01:00:01
The gocanto/converter composer package by Gustavo Ocanto is an immutable PHP currency converter that’s data-agnostic. The post Immutable PHP Currency Converter appeared first on Laravel News. Join the Laravel Newsletter to ge...
カテゴリー: php

Derick Rethans: PHP Internals News: Episode 15: base_convert() Improvements

phpdeveloper.org - 2019-06-21(金) 01:00:01
PHP Internals News: Episode 15: base_convert() Improvements London, UK Thursday, June 20th 2019, 09:15 BST In this fifteenth episode of "PHP Internals News" I talk with Scott Dutton (Twitter, GitHub) about his base_convert() Improvements RF...
カテゴリー: php

Interview with Woody Gilk

planet PHP - 2019-06-20(木) 20:31:00
カテゴリー: php

11.4

postgresql.org - 2019-06-20(木) 09:00:00
11.4 is the latest release in the 11 series.
カテゴリー: postgresql

10.9

postgresql.org - 2019-06-20(木) 09:00:00
10.9 is the latest release in the 10 series.
カテゴリー: postgresql

ページ