24x7, 365 Enterprise services since 1997
The snap packages for 9.3.15, 9.4.10, 9.5.5 and 9.6.1 are now available. To install them:
sudo snap install postgresql$version
Where $version is one of 93, 94, 95 or 96.
The snap packages for PostgreSQL are a community project being lead by Command Prompt. You can visit the repo at github.
To learn more about snap packages please visit the Ubuntu snapcraft developer FAQ.
A #postgresql user today asked:
noob question - trying to write a Dockerfile that runs postgres... how do I get the effect of a non-interactive `service postgresql initdb` call?
Anyone who uses PostgreSQL knows of the best client available: psql. This is the client that ships with PostgreSQL. Yes it is a command line client (which turns some people off) but that also means that it is the most efficient at everyday tasks for a DBA. What a lot of people don't know is that psql is rather configurable. Here is an example:
Problem 1: I want my …
This is a test table from an Oracle to Postgres migration. The table has had a dozen or so columns removed for the illustration of this test case. I did not design this table but the customer is fixing it (adding proper primary key, changing to boolean and integer where appropriate etc...).
Column | Type | Modifiers -------------------+-----------------------------+-------------------- costcenterid | numeric | not null costcenterno | character varying(100) …
I have updated my Rich in the Jungle presentation with new pricing for AWS vs. Softlayer. Things haven't changed much, in terms of raw performance per dollar (which is not the only qualifier). Softlayer is clearly the winner.
Once upon a time FOSS was about Freedom. It was about exposing equality within source code. It allowed everyone equal rights and equal access to the technology they were using. An idea that if you were capable, you could fix code or pay someone to fix code. An ideology that there was something greater than yourself and that there was an inherent right built into what it is to be …
As the PostgreSQL community continues down its path of world domination I can't help but wonder whether the various PostgreSQL companies are going to survive the changes. Once upon a time there was an undercurrent of understanding that what was good for the community was good for the company. Whatever company that may be. However, over the last few years it seems that has changed. It seems there is more …
My slides from my presentation and PgConf.US 2016:
While attending the hallway track, I was talking to …