<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <HTML ><HEAD ><TITLE >Release 9.4.3</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK REV="MADE" HREF="mailto:pgsql-docs@postgresql.org"><LINK REL="HOME" TITLE="PostgreSQL 9.6.10 Documentation" HREF="index.html"><LINK REL="UP" TITLE="Release Notes" HREF="release.html"><LINK REL="PREVIOUS" TITLE="Release 9.4.4" HREF="release-9-4-4.html"><LINK REL="NEXT" TITLE="Release 9.4.2" HREF="release-9-4-2.html"><LINK REL="STYLESHEET" TYPE="text/css" HREF="stylesheet.css"><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1"><META NAME="creation" CONTENT="2018-10-16T23:40:43"></HEAD ><BODY CLASS="SECT1" ><DIV CLASS="NAVHEADER" ><TABLE SUMMARY="Header navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="4" ALIGN="center" VALIGN="bottom" ><A HREF="index.html" >PostgreSQL 9.6.10 Documentation</A ></TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="top" ><A TITLE="Release 9.4.4" HREF="release-9-4-4.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="10%" ALIGN="left" VALIGN="top" ><A HREF="release.html" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="60%" ALIGN="center" VALIGN="bottom" >Appendix E. Release Notes</TD ><TD WIDTH="20%" ALIGN="right" VALIGN="top" ><A TITLE="Release 9.4.2" HREF="release-9-4-2.html" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><DIV CLASS="SECT1" ><H1 CLASS="SECT1" ><A NAME="RELEASE-9-4-3" >E.43. Release 9.4.3</A ></H1 ><DIV CLASS="FORMALPARA" ><P ><B >Release date: </B >2015-06-04</P ></DIV ><P > This release contains a small number of fixes from 9.4.2. For information about new features in the 9.4 major release, see <A HREF="release-9-4.html" >Section E.46</A >. </P ><DIV CLASS="SECT2" ><H2 CLASS="SECT2" ><A NAME="AEN139999" >E.43.1. Migration to Version 9.4.3</A ></H2 ><P > A dump/restore is not required for those running 9.4.X. </P ><P > However, if you are upgrading from a version earlier than 9.4.2, see <A HREF="release-9-4-2.html" >Section E.44</A >. </P ></DIV ><DIV CLASS="SECT2" ><H2 CLASS="SECT2" ><A NAME="AEN140004" >E.43.2. Changes</A ></H2 ><P ></P ><UL ><LI ><P > Avoid failures while <CODE CLASS="FUNCTION" >fsync</CODE >'ing data directory during crash restart (Abhijit Menon-Sen, Tom Lane) </P ><P > In the previous minor releases we added a patch to <CODE CLASS="FUNCTION" >fsync</CODE > everything in the data directory after a crash. Unfortunately its response to any error condition was to fail, thereby preventing the server from starting up, even when the problem was quite harmless. An example is that an unwritable file in the data directory would prevent restart on some platforms; but it is common to make SSL certificate files unwritable by the server. Revise this behavior so that permissions failures are ignored altogether, and other types of failures are logged but do not prevent continuing. </P ><P > Also apply the same rules in <TT CLASS="LITERAL" >initdb --sync-only</TT >. This case is less critical but it should act similarly. </P ></LI ><LI ><P > Fix <CODE CLASS="FUNCTION" >pg_get_functiondef()</CODE > to show functions' <TT CLASS="LITERAL" >LEAKPROOF</TT > property, if set (Jeevan Chalke) </P ></LI ><LI ><P > Fix <CODE CLASS="FUNCTION" >pushJsonbValue()</CODE > to unpack <TT CLASS="TYPE" >jbvBinary</TT > objects (Andrew Dunstan) </P ><P > This change does not affect any behavior in the core code as of 9.4, but it avoids a corner case for possible third-party callers. </P ></LI ><LI ><P > Remove <SPAN CLASS="APPLICATION" >configure</SPAN >'s check prohibiting linking to a threaded <SPAN CLASS="APPLICATION" >libpython</SPAN > on <SPAN CLASS="SYSTEMITEM" >OpenBSD</SPAN > (Tom Lane) </P ><P > The failure this restriction was meant to prevent seems to not be a problem anymore on current <SPAN CLASS="SYSTEMITEM" >OpenBSD</SPAN > versions. </P ></LI ></UL ></DIV ></DIV ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE SUMMARY="Footer navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="release-9-4-4.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.html" ACCESSKEY="H" >Home</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="release-9-4-2.html" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >Release 9.4.4</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="release.html" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >Release 9.4.2</TD ></TR ></TABLE ></DIV ></BODY ></HTML >