summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
2012-09-06Update syntax shown for \copy to match new syntax for COPY.Robert Haas
Etsuro Fujita
2012-09-05Fix typo in information_schema documentation.Tom Lane
Shigeru Hanada
2012-09-05Make one last copy-editing pass over the 9.2 release notes.Tom Lane
Also, set the release date to 2012-09-10, since we're pretty well committed to that now.
2012-09-04Document that pg_upgrade requires PGHOST be set for any pre-9.1 serversBruce Momjian
with a socket directory mismatch with the new server. Backpatch to 9.2.
2012-09-04Mention basebackup-from-slave next to cascading replicationMagnus Hagander
2012-09-03Fix pg_upgrade to cope with non-default unix_socket_directory scenarios.Tom Lane
When starting either an old or new postmaster, force it to place its Unix socket in the current directory. This makes it even harder for accidental connections to occur during pg_upgrade, and also works around some scenarios where the default socket location isn't usable. (For example, if the default location is something other than "/tmp", it might not exist during "make check".) When checking an already-running old postmaster, find out its actual socket directory location from postmaster.pid, if possible. This dodges problems with an old postmaster having a configured location different from the default built into pg_upgrade's libpq. We can't find that out if the old postmaster is pre-9.1, so also document how to cope with such scenarios manually. In support of this, centralize handling of the connection-related command line options passed to pg_upgrade's subsidiary programs, such as pg_dump. This should make future changes easier. Bruce Momjian and Tom Lane
2012-09-02Update URLs that pointed to sun.com; either repoint them or removeBruce Momjian
them.
2012-09-02Add small doc mention that libpq is named after POSTQUEL.Bruce Momjian
2012-09-01Revert doc patch 305557984dd964ac397c6752e9d0f14646b60f15 as the valuesBruce Momjian
are sometimes signed, sometimes unsigned.
2012-09-01Fix broken link in installation.sgml.Tom Lane
Linking to other parts of the manual doesn't work when building the standalone INSTALL document.
2012-09-01Cross-link to doc build requirements from install requirements.Robert Haas
Jeff Janes
2012-09-01More documentation updates for LATERAL.Tom Lane
Extend xfunc.sgml's discussion of set-returning functions to show an example of using LATERAL, and recommend that over putting SRFs in the targetlist. In passing, reword func.sgml's section on set-returning functions so that it doesn't claim that the functions listed therein are all the built-in set-returning functions. That hasn't been true for a long time, and trying to make it so doesn't seem like it would be an improvement. (Perhaps we should rename that section?) Both per suggestions from Merlin Moncure.
2012-08-31psql: Reduce compatibility warningPeter Eisentraut
Only warn when connecting to a newer server, since connecting to older servers works pretty well nowadays. Also update the documentation a little about current psql/server compatibility expectations.
2012-08-31In pg_upgade, document that the port numbers must be different whenBruce Momjian
checking an old running server.
2012-08-30Clarify FreeBSD instructions in pg_test_timing.Bruce Momjian
Josh Kupershmidt
2012-08-30Properly document that SIGTERM is OK for users to use on a postgresBruce Momjian
session, now that pg_terminate_backend() uses it. Josh Kupershmidt
2012-08-30Revert 1fbc30f1dca6624c01a9a6a9ff711a7036c68532 because theBruce Momjian
--enable-shared is about Plyton's configure, not ours.
2012-08-30Remove doc mention of --enable-shared, per Tom.Bruce Momjian
2012-08-30Document that max_locks_per_transaction might need to be increased forBruce Momjian
queries on parent tables, per suggestion from Josh Berkus.
2012-08-30Fix checkpoint_timeout documentation to reflect current behavior.Robert Haas
Jeff Janes
2012-08-30Document that log_autovacuum_min_duration can be used to monitorBruce Momjian
autovacuum activity. Per report from Marc Mamin
2012-08-30Document how to prevent PostgreSQL itself from exhausting memory.Robert Haas
The existing documentation in Linux Memory Overcommit seemed to assume that PostgreSQL itself could never be the problem, or at least it didn't tell you what to do about it. Per discussion with Craig Ringer and Kevin Grittner.
2012-08-30Document that COPY OUT requires an absolute pathname.Robert Haas
As suggested by Etsuro Fujita, but with somewhat different wording.
2012-08-30Remove old documentation warnings about the use of bigint.Bruce Momjian
2012-08-30Document that xslt-related RPMs may be needed to build docs.Robert Haas
2012-08-29Document that NOTIFY events are visible to all users.Bruce Momjian
2012-08-28Adjust pg_test_timing to show shortest test durations first, placeBruce Momjian
percentage column before count column. Docs updated.
2012-08-28Update doc mention of how to compute bigint advisory lock value, per TomBruce Momjian
Lane's correction.
2012-08-27Document how to create advisory lock "bigint" values in SQL.Bruce Momjian
David E. Wheeler
2012-08-27Improve a couple of 9.2 release note entries.Tom Lane
Clarify the compatibility notes about EXTRACT() and about statistics timing columns.
2012-08-27Add section IDs to subsections of syntax.sgml that lacked them.Tom Lane
This is so that these sections will have stable HTML tags that one can link to, rather than things like "AEN1902". Perhaps we should mount a campaign to do this everywhere, but I've found myself pointing at syntax.sgml subsections often enough to be sure it's useful here.
2012-08-27Document the lack of reading the PGDATABASE environment variable inBruce Momjian
pg_restore.
2012-08-26Update FreeBSD kernel configuration documentation.Bruce Momjian
Brad Davis
2012-08-26Clarify documentation that primary key and unique constraints are copiedBruce Momjian
for CREATE TABLE LIKE ... INCLUDING INDEXES. Per report from david.sahagian@emc.com
2012-08-25Document clearly that psql \! parameter interpretation limitations areBruce Momjian
the same as \copy.
2012-08-24Some spelling adjustments in release notesPeter Eisentraut
2012-08-24Normalize some British spellingsPeter Eisentraut
2012-08-24Put options on man page and in help output in slightly better orderPeter Eisentraut
2012-08-23Fix typo in example.Heikki Linnakangas
2012-08-23Add instructions for setting up documentation tool chain on Mac OS XPeter Eisentraut
2012-08-22Remove overly-pessimistic statement about constraint exclusion.Tom Lane
As of 9.2, constraint exclusion should work okay with prepared statements: the planner will try custom plans with actual values of the parameters, and observe that they are a lot cheaper than the generic plan, and thus never fall back to using the generic plan. Noted by Tatsuhito Kasahara.
2012-08-22Make a cut at a major-features list for 9.2.Tom Lane
This is open to debate of course, but it's past time we had *something* here.
2012-08-22Make an editorial pass over the 9.2 release notes.Tom Lane
A very large number of small improvements ...
2012-08-22Fix erroneous documentation of synchronous_commit = remote_write.Tom Lane
The docs claimed that this mode only waits for the standby to receive WAL data, but actually it waits for the data to be written out to the standby's OS; which is a pretty significant difference because it removes the risk of crash of the walreceiver process.
2012-08-22Fix typo.Bruce Momjian
2012-08-22Document that pg_reload_conf() is also an easy way to reload theBruce Momjian
configuration file.
2012-08-21Update 9.2 release notes to reflect commits to date.Tom Lane
I was unable to entirely resist the temptation to copy-edit related entries, but will save most of that for a separate pass.
2012-08-21Add a note to the MVCC chapter that some things aren't transactional.Robert Haas
Craig Ringer, slightly edited by me.
2012-08-17Copy-editing for recent window-functions documentation rewrite.Tom Lane
Fix grammar, put back some removed information, rearrange for clarity.
2012-08-16Update 'int' protocol documentation mention to be "signed", per requestBruce Momjian
from Dmitriy Igrishin