Index: doc/src/sgml/Makefile
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/Makefile,v
retrieving revision 1.148
diff -c -c -r1.148 Makefile
*** doc/src/sgml/Makefile 12 Jun 2010 21:40:31 -0000 1.148
--- doc/src/sgml/Makefile 30 Jun 2010 19:06:22 -0000
***************
*** 93,107 ****
--- 93,111 ----
# The draft target creates HTML output in draft mode, without index (for faster build).
draft: postgres.sgml $(ALMOSTALLSGML) stylesheet.dsl
$(MKDIR_P) html
+ $(MKDIR_P) html/img
$(JADE.html.call) -V draft-mode $<
cp $(srcdir)/stylesheet.css html/
+ cp $(srcdir)/img/png/*.png html/img/
html: html-stamp
html-stamp: postgres.sgml $(ALLSGML) stylesheet.dsl
$(MKDIR_P) html
+ $(MKDIR_P) html/img
$(JADE.html.call) -i include-index $<
cp $(srcdir)/stylesheet.css html/
+ cp $(srcdir)/img/png/*.png html/img/
touch $@
# single-page HTML
Index: doc/src/sgml/backup.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/backup.sgml,v
retrieving revision 2.156
diff -c -c -r2.156 backup.sgml
*** doc/src/sgml/backup.sgml 7 Jun 2010 02:01:08 -0000 2.156
--- doc/src/sgml/backup.sgml 30 Jun 2010 19:06:22 -0000
***************
*** 798,803 ****
--- 798,817 ----
+
+
+
+ PITR - Base Backup
+
+
+
+
+
+ PITR - Base Backup
+
+
+
+
Some file system backup tools emit warnings or errors
if the files they are trying to copy change while the copy proceeds.
Index: doc/src/sgml/cvs.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/cvs.sgml,v
retrieving revision 1.52
diff -c -c -r1.52 cvs.sgml
*** doc/src/sgml/cvs.sgml 7 Dec 2009 19:19:56 -0000 1.52
--- doc/src/sgml/cvs.sgml 30 Jun 2010 19:06:22 -0000
***************
*** 42,47 ****
--- 42,62 ----
+
+
+ Lines of code
+
+
+
+
+
+ Lines of code
+
+
+
+
+
+
Our Wiki, and
,
Index: doc/src/sgml/high-availability.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/high-availability.sgml,v
retrieving revision 1.76
diff -c -c -r1.76 high-availability.sgml
*** doc/src/sgml/high-availability.sgml 28 Jun 2010 12:30:32 -0000 1.76
--- doc/src/sgml/high-availability.sgml 30 Jun 2010 19:06:22 -0000
***************
*** 671,676 ****
--- 671,690 ----
+
+
+
+ File-based log shipping
+
+
+
+
+
+ File-based log shipping
+
+
+
+
If you want to use streaming replication, fill in
primary_conninfo with a libpq connection string, including
***************
*** 746,751 ****
--- 760,779 ----
window.
+
+
+
+ Streaming replication - Record-based log shipping
+
+
+
+
+
+ Streaming replication (Record-based log shipping)
+
+
+
+
If you use streaming replication without file-based continuous
archiving, you have to set wal_keep_segments in the master
***************
*** 949,954 ****
--- 977,997 ----
+
+
+ File-based log shipping with pg_standby
+
+
+
+
+
+ File-based log shipping with pg_standby
+
+
+
+
+
+
Note that in this mode, the server will apply WAL one file at a
time, so if you use the standby server for queries (see Hot Standby),
there is a delay between an action in the master and when the
***************
*** 1146,1151 ****
--- 1189,1209 ----
noted below.
+
+
+
+ Hot-Standby
+
+
+
+
+
+ File-based log shipping with pg_standby
+
+
+
+
+
User's Overview
Index: doc/src/sgml/history.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/history.sgml,v
retrieving revision 1.31
diff -c -c -r1.31 history.sgml
*** doc/src/sgml/history.sgml 27 Apr 2009 16:27:35 -0000 1.31
--- doc/src/sgml/history.sgml 30 Jun 2010 19:06:22 -0000
***************
*** 216,220 ****
--- 216,235 ----
Details about what has happened in PostgreSQL since
then can be found in .
+
+
+
+
+ PostgreSQL history timeline
+
+
+
+
+
+ PostgreSQL history timeline
+
+
+
+
Index: doc/src/sgml/maintenance.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/maintenance.sgml,v
retrieving revision 1.105
diff -c -c -r1.105 maintenance.sgml
*** doc/src/sgml/maintenance.sgml 26 May 2010 23:55:51 -0000 1.105
--- doc/src/sgml/maintenance.sgml 30 Jun 2010 19:06:22 -0000
***************
*** 171,176 ****
--- 171,190 ----
+
+
+ Standard vacuum
+
+
+
+
+
+ Standard vacuum
+
+
+
+
+
The usual goal of routine vacuuming is to do standard VACUUMs
often enough to avoid needing VACUUM FULL. The
autovacuum daemon attempts to work this way, and in fact will
Index: doc/src/sgml/manage-ag.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/manage-ag.sgml,v
retrieving revision 2.62
diff -c -c -r2.62 manage-ag.sgml
*** doc/src/sgml/manage-ag.sgml 3 Apr 2010 07:22:55 -0000 2.62
--- doc/src/sgml/manage-ag.sgml 30 Jun 2010 19:06:23 -0000
***************
*** 409,414 ****
--- 409,428 ----
+
+
+ Tablespaces
+
+
+
+
+
+ Tablespaces
+
+
+
+
+
Tables, indexes, and entire databases can be assigned to
particular tablespaces. To do so, a user with the CREATE
privilege on a given tablespace must pass the tablespace name as a
Index: doc/src/sgml/start.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/start.sgml,v
retrieving revision 1.51
diff -c -c -r1.51 start.sgml
*** doc/src/sgml/start.sgml 19 Dec 2009 02:34:17 -0000 1.51
--- doc/src/sgml/start.sgml 30 Jun 2010 19:06:23 -0000
***************
*** 118,123 ****
--- 118,136 ----
come and go. (All of this is of course invisible to the user. We
only mention it here for completeness.)
+
+
+
+ PostgreSQL system architecture overview
+
+
+
+
+
+ PostgreSQL system architecture overview
+
+
+
Index: doc/src/sgml/storage.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/storage.sgml,v
retrieving revision 1.32
diff -c -c -r1.32 storage.sgml
*** doc/src/sgml/storage.sgml 16 Feb 2010 22:34:43 -0000 1.32
--- doc/src/sgml/storage.sgml 30 Jun 2010 19:06:24 -0000
***************
*** 125,130 ****
--- 125,144 ----
+
+
+ PostgreSQL File Layout
+
+
+
+
+
+ PostgreSQL File Layout
+
+
+
+
+
For each database in the cluster there is a subdirectory within
PGDATA/base, named after the database's OID in
pg_database. This subdirectory is the default location
***************
*** 559,564 ****
--- 573,592 ----
+
+
+
+ PostgreSQL Page Layout
+
+
+
+
+
+ PostgreSQL Page Layout
+
+
+
+
The first 24 bytes of each page consists of a page header