~ubuntu-branches/ubuntu/trusty/postgresql-9.3/trusty-proposed

« back to all changes in this revision

Viewing changes to doc/src/sgml/html/pgupgrade.html

  • Committer: Package Import Robot
  • Author(s): Martin Pitt
  • Date: 2014-07-24 16:13:59 UTC
  • mfrom: (1.1.8)
  • Revision ID: package-import@ubuntu.com-20140724161359-uk325qfv03euxuuh
Tags: 9.3.5-0ubuntu0.14.04.1
* New upstream bug fix release: (LP: #1348176)
  - pg_upgrade: Users who upgraded to version 9.3 using pg_upgrade may have
    an issue with transaction information which causes VACUUM to eventually
    fail. These users should run the script provided in the release notes to
    determine if their installation is affected, and then take the remedy
    steps outlined there.
  - Various data integrity and other bug fixes.
  - Secure Unix-domain sockets of temporary postmasters started during make
    check.
    Any local user able to access the socket file could connect as the
    server's bootstrap superuser, then proceed to execute arbitrary code as
    the operating-system user running the test, as we previously noted in
    CVE-2014-0067. This change defends against that risk by placing the
    server's socket in a temporary, mode 0700 subdirectory of /tmp.
  - See release notes for details:
    http://www.postgresql.org/about/news/1534/
* Remove pg_regress patches to support --host=/path, obsolete with above
  upstream changes and not applicable any more.
* Drop tcl8.6 patch, applied upstream.
* Add missing logrotate test dependency.

Show diffs side-by-side

added added

removed removed

Lines of Context:
9
9
REV="MADE"
10
10
HREF="mailto:pgsql-docs@postgresql.org"><LINK
11
11
REL="HOME"
12
 
TITLE="PostgreSQL 9.3.4 Documentation"
 
12
TITLE="PostgreSQL 9.3.5 Documentation"
13
13
HREF="index.html"><LINK
14
14
REL="UP"
15
15
TITLE="Server Applications"
26
26
HTTP-EQUIV="Content-Type"
27
27
CONTENT="text/html; charset=ISO-8859-1"><META
28
28
NAME="creation"
29
 
CONTENT="2014-03-17T19:42:29"></HEAD
 
29
CONTENT="2014-07-21T19:26:29"></HEAD
30
30
><BODY
31
31
CLASS="REFENTRY"
32
32
><DIV
44
44
VALIGN="bottom"
45
45
><A
46
46
HREF="index.html"
47
 
>PostgreSQL 9.3.4 Documentation</A
 
47
>PostgreSQL 9.3.5 Documentation</A
48
48
></TH
49
49
></TR
50
50
><TR
98
98
><DIV
99
99
CLASS="REFNAMEDIV"
100
100
><A
101
 
NAME="AEN155206"
 
101
NAME="AEN156043"
102
102
></A
103
103
><H2
104
104
>Name</H2
109
109
><DIV
110
110
CLASS="REFSYNOPSISDIV"
111
111
><A
112
 
NAME="AEN155212"
 
112
NAME="AEN156049"
113
113
></A
114
114
><H2
115
115
>Synopsis</H2
159
159
><DIV
160
160
CLASS="REFSECT1"
161
161
><A
162
 
NAME="AEN155233"
 
162
NAME="AEN156070"
163
163
></A
164
164
><H2
165
165
>Description</H2
228
228
><DIV
229
229
CLASS="REFSECT1"
230
230
><A
231
 
NAME="AEN155249"
 
231
NAME="AEN156086"
232
232
></A
233
233
><H2
234
234
>Options</H2
575
575
><DIV
576
576
CLASS="REFSECT1"
577
577
><A
578
 
NAME="AEN155395"
 
578
NAME="AEN156232"
579
579
></A
580
580
><H2
581
581
>Usage</H2
744
744
>     <TT
745
745
CLASS="COMMAND"
746
746
>pg_upgrade</TT
747
 
> will connect to the old and new servers several times,
748
 
     so you might want to set authentication to <TT
749
 
CLASS="LITERAL"
750
 
>trust</TT
751
 
>
752
 
     or <TT
 
747
> will connect to the old and new servers several
 
748
     times, so you might want to set authentication to <TT
753
749
CLASS="LITERAL"
754
750
>peer</TT
755
 
> in <TT
 
751
>
 
752
     in <TT
756
753
CLASS="FILENAME"
757
754
>pg_hba.conf</TT
758
 
>, or if using
759
 
     <TT
760
 
CLASS="LITERAL"
761
 
>md5</TT
762
 
> authentication, use a <TT
 
755
> or use a <TT
763
756
CLASS="FILENAME"
764
757
>~/.pgpass</TT
765
758
> file
952
945
>     If you modified <TT
953
946
CLASS="FILENAME"
954
947
>pg_hba.conf</TT
955
 
> to use <TT
956
 
CLASS="LITERAL"
957
 
>trust</TT
958
 
>,
959
 
     restore its original authentication settings.  It might also be
960
 
     necessary to adjust other configurations files in the new cluster to
961
 
     match the old cluster, e.g. <TT
 
948
>, restore its original settings.
 
949
     It might also be necessary to adjust other configuration files in the new
 
950
     cluster to match the old cluster, e.g. <TT
962
951
CLASS="FILENAME"
963
952
>postgresql.conf</TT
964
953
>.
1146
1135
><DIV
1147
1136
CLASS="REFSECT1"
1148
1137
><A
1149
 
NAME="AEN155529"
 
1138
NAME="AEN156363"
1150
1139
></A
1151
1140
><H2
1152
1141
>Notes</H2
1271
1260
><DIV
1272
1261
CLASS="REFSECT2"
1273
1262
><A
1274
 
NAME="AEN155560"
 
1263
NAME="AEN156394"
1275
1264
></A
1276
1265
><H3
1277
1266
>Limitations in Upgrading from PostgreSQL 8.3</H3
1379
1368
><DIV
1380
1369
CLASS="REFSECT1"
1381
1370
><A
1382
 
NAME="AEN155590"
 
1371
NAME="AEN156424"
1383
1372
></A
1384
1373
><H2
1385
1374
>See Also</H2