summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
2011-02-01Properly capitalize hyphenated words in documentation titles.Bruce Momjian
2011-02-01Clarify documentation to state that "zero_damaged_pages" does not forceBruce Momjian
data to disk, so the table or index should be recreated before the parameter is turned off again.
2011-02-01Document that effective cache size does not assume data remains in theBruce Momjian
cache between queries.
2011-02-01Document that Slony can do upgrades easier _because_ it supportsBruce Momjian
replication between different Postgres major versions.
2011-02-01Clarify pg_upgrade install instructions, per suggestion from Robert Haas.Bruce Momjian
2011-02-01Add missing period "." in pg_upgrade documentation.Bruce Momjian
2011-02-01Re-classify ERRCODE_DATABASE_DROPPED to 57P04Simon Riggs
2011-02-01Add a link from client_encoding parameter to the list of character setsItagaki Takahiro
in documentation. Thom Brown
2011-01-31Improve docs for pg_authid encryption description with better markup andBruce Momjian
a mention of unencrypted passwords.
2011-01-31In pg_authid.rolpassword docs, make "md5" appear as a literal.Bruce Momjian
2011-01-31Support LIKE and ILIKE index searches via contrib/pg_trgm indexes.Tom Lane
Unlike Btree-based LIKE optimization, this works for non-left-anchored search patterns. The effectiveness of the search depends on how many trigrams can be extracted from the pattern. (The worst case, with no trigrams, degrades to a full-table scan, so this isn't a panacea. But it can be very useful.) Alexander Korotkov, reviewed by Jan Urbanski
2011-02-01Create new errcode for recovery conflict caused by db drop on master.Simon Riggs
Previously reported as ERRCODE_ADMIN_SHUTDOWN, this case is now reported as ERRCODE_T_R_DATABASE_DROPPED. No message text change. Unlikely to happen on most servers, so low impact change to allow session poolers to correctly handle this situation. Tatsuo Ishii, edits by me, review by Robert Haas
2011-01-31Remove spurious word, spotted by Thom Brown.Heikki Linnakangas
2011-01-31Update pg_upgrade docs to mention its use in a less risk-warning way,Bruce Momjian
and update the pg_upgrade docs to mention its reliance on no changes to the storage format (the later based on Robert Haas's patch).
2011-01-31Fix SGML markup for upgrade doc addition.Bruce Momjian
2011-01-31Update docs on building for Windows to accomodate current reality.Andrew Dunstan
Document how to build 64 bit Windows binaries using the MinGW64 tool set. Remove recommendation against using Mingw as a build platform. Be more specific about when Cygwin is useful and when it's not, in particular note its usefulness for running psql, and add a note about building on Cygwin in non-C locales. Per recent discussions.
2011-01-31Move upgrade instructions into its own section under "Server Setup andBruce Momjian
Operation", merged from upgrade sections in "Installation from Source Code" and "Backup and Restore". This now gives a single place for all upgrade information.
2011-01-31Support multiple concurrent pg_basebackup backups.Heikki Linnakangas
With this patch, pg_basebackup doesn't write a backup_label file in the data directory, so it doesn't interfere with a pg_start/stop_backup() based backup anymore. backup_label is still included in the backup, but it is injected directly into the tar stream. Heikki Linnakangas, reviewed by Fujii Masao and Magnus Hagander.
2011-01-30Add option to include WAL in base backupMagnus Hagander
When included, this makes the base backup a complete working "clone" of the initial database, ready to have a postmaster started against it without the need to set up any log archiving or similar. Magnus Hagander, reviewed by Fujii Masao and Heikki Linnakangas
2011-01-29Properly capitalize documentation headings; some only had initial-wordBruce Momjian
capitalization.
2011-01-29Make installation.sgml build standalone again.Tom Lane
We must not try to link to sections that aren't part of the standalone "make INSTALL" build. Corrects build failure introduced in commit 159e3d86292cfec2a2828f9f69ac7a6cb1be242d.
2011-01-28Copy-edit a paragraph in the contrib/seg documentation.Tom Lane
Although this improves the style, an ulterior motive is to keep the two table links from breaking across lines in PDF output, per complaint from Josh Kupershmidt.
2011-01-27Rephrase pg_conversion description to avoid splitting link across page.Tom Lane
The link to the CREATE CONVERSION manual page was split across a page boundary in the PDF output, leading to "\pdfendlink ended up in different nesting level than \pdfstartlink" error while building PDFs. It wouldn't be worth changing text that's undergoing active editing to avoid this, since other editing might result in moving the link away from the page end anyway. But this paragraph has been static for a long time, so might as well fix it to prevent it from being an issue in future.
2011-01-27Update release notes.Tom Lane
Security: CVE-2010-4015
2011-01-27Update release notes for releases 9.0.3, 8.4.7, 8.3.14, and 8.2.20.Tom Lane
2011-01-27Improve grammar and spelling in durability discussion.Tom Lane
2011-01-27Update non-durable docs about non-synchronous-commit allowingBruce Momjian
transaction loss for a _database_ crash.
2011-01-26Restructure streaming docs so streaming seems more integrated in theBruce Momjian
paragraphs, per suggestion from Dan Birken.
2011-01-26Update contrib documention mentions to point to actual documentationBruce Momjian
sections, rather than just calling it "/contrib/module_name". Also update pg_test_fsync build instructions now that it is in /contrib.
2011-01-26Update sync commit performance documentation to be consistent with otherBruce Momjian
non-durable items, per Robert Haas.
2011-01-26Make 'on' uppercase in a sql example.Itagaki Takahiro
2011-01-25Update warning about synchronous-commit durability, per suggestion fromBruce Momjian
Robvert Haas.
2011-01-25Correct ALTER TYPE -> SET DATA TYPE in ALTER TABLE documentation.Robert Haas
The latter is the correct name of the operation to change the data type of a column. Noah Misch
2011-01-25Remove old claim that ExclusiveLock is sometimes taken on system catalogs.Tom Lane
We used to do that on pg_listener, but pg_listener is no more. Also add a bit more documentation for ShareRowExclusive mode.
2011-01-25Fix thinko in ALTER FOREIGN TABLE documentation.Robert Haas
Noah Misch
2011-01-25Replace pg_class.relhasexclusion with pg_index.indisexclusion.Tom Lane
There isn't any need to track this state on a table-wide basis, and trying to do so introduces undesirable semantic fuzziness. Move the flag to pg_index, where it clearly describes just a single index and can be immutable after index creation.
2011-01-25Implement ALTER TABLE ADD UNIQUE/PRIMARY KEY USING INDEX.Tom Lane
This feature allows a unique or pkey constraint to be created using an already-existing unique index. While the constraint isn't very functionally different from the bare index, it's nice to be able to do that for documentation purposes. The main advantage over just issuing a plain ALTER TABLE ADD UNIQUE/PRIMARY KEY is that the index can be created with CREATE INDEX CONCURRENTLY, so that there is not a long interval where the table is locked against updates. On the way, refactor some of the code in DefineIndex() and index_create() so that we don't have to pass through those functions in order to create the index constraint's catalog entries. Also, in parse_utilcmd.c, pass around the ParseState pointer in struct CreateStmtContext to save on notation, and add error location pointers to some error reports that didn't have one before. Gurjeet Singh, reviewed by Steve Singer and Tom Lane
2011-01-24More documentation cleanup for sepgsql.Robert Haas
Thom Brown and Robert Haas
2011-01-23First round of cleanup of sepgsql code and documentation.Robert Haas
Robert Haas, with a few suggestions from Thom Brown
2011-01-23sepgsql, an SE-Linux integration for PostgreSQLRobert Haas
This is still pretty rough - among other things, the documentation needs work, and the messages need a visit from the style police - but this gets the basic framework in place. KaiGai Kohei
2011-01-23Add 'directory' format to pg_dump. The new directory format is compatibleHeikki Linnakangas
with the 'tar' format, in that untarring a tar format archive produces a valid directory format archive. Joachim Wieland and Heikki Linnakangas
2011-01-23Only show pg_stat_replication details to superusersMagnus Hagander
2011-01-23Add pg_basebackup tool for streaming base backupsMagnus Hagander
This tool makes it possible to do the pg_start_backup/ copy files/pg_stop_backup step in a single command. There are still some steps to be done before this is a complete backup solution, such as the ability to stream the required WAL logs, but it's still usable, and could do with some buildfarm coverage. In passing, make the checkpoint request optionally fast instead of hardcoding it. Magnus Hagander, reviewed by Fujii Masao and Dimitri Fontaine
2011-01-22Allow the wal_buffers setting to be auto-tuned to a reasonable value.Tom Lane
If wal_buffers is initially set to -1 (which is now the default), it's replaced by 1/32nd of shared_buffers, with a minimum of 8 (the old default) and a maximum of the XLOG segment size. The allowed range for manual settings is still from 4 up to whatever will fit in shared memory. Greg Smith, with implementation correction by me.
2011-01-21Clean up pg_test_fsync commit.Tom Lane
Actually rename the program, rather than just claiming we did. Hook it into the build system. Get rid of useless dependency on libpq. Clean up #include list and messy whitespace.
2011-01-21Fix broken markup, also minor copy-editing.Tom Lane
2011-01-21Emphasize where OVER needs to be when using a window function.Robert Haas
Jeff Turner
2011-01-21Update SGML docs to point to new /contrib/pg_test_fsync.Bruce Momjian
2011-01-21Move test_fsync to /contrib.Bruce Momjian
2011-01-20Add new psql command \dL to list languages.Robert Haas
Original patch by Fernando Ike, revived by Josh Kuperschmidt, reviewed by Andreas Karlsson, and in earlier versions by Tom Lane and Peter Eisentraut.