aboutsummaryrefslogtreecommitdiff
path: root/doc/src
Commit message (Collapse)AuthorAge
...
* Move documentation of all recovery.conf option to a new chapter.Heikki Linnakangas2010-02-22
| | | | | They used to be scattered between the "backup and restore" and "streaming replication" chapters.
* Adjust sample auto-explain output to reflect query text inclusion.Andrew Dunstan2010-02-20
|
* Make 'include_realm' ordering consistent in the docs, to match recentBruce Momjian2010-02-20
| | | | doc change.
* Clarify documentation about username mapping when authenticating withBruce Momjian2010-02-20
| | | | | | GSSAPI or Kerberos. Ian Turner
* Document that many solid-state drives have volatile write-back caches.Bruce Momjian2010-02-20
|
* Copy editing of Hot Standby docs. Some clarifications, additionSimon Riggs2010-02-20
| | | | of missing items and minor edits.
* Document --version and --help options for all client applications (theyBruce Momjian2010-02-19
| | | | | | all support it). Per report from Josh Kupershmidt
* First pass over client applications documentation proofreading.Bruce Momjian2010-02-19
| | | | gabrielle
* Remove mention that binary distributions pre-compile the tutorial files.Bruce Momjian2010-02-19
|
* Preliminary release notes for 9.0alpha4Peter Eisentraut2010-02-19
|
* Hot Standby documentation updatesBruce Momjian2010-02-19
| | | | Greg Smith
* Add missing close tag.Bruce Momjian2010-02-18
|
* Wordsmithing of HS and SR documentation, with some wording improvementsBruce Momjian2010-02-18
| | | | from Erik Rijkers too.
* Stamp HEAD as 9.0devel, and update various places that were referring to 8.5Tom Lane2010-02-17
| | | | (hope I got 'em all). Per discussion, this release will be 9.0 not 8.5.
* Tweak description of payload parameter.Tom Lane2010-02-17
|
* Replace the pg_listener-based LISTEN/NOTIFY mechanism with an in-memory queue.Tom Lane2010-02-16
| | | | | | | | | | | | In addition, add support for a "payload" string to be passed along with each notify event. This implementation should be significantly more efficient than the old one, and is also more compatible with Hot Standby usage. There is not yet any facility for HS slaves to receive notifications generated on the master, although such a thing is possible in future. Joachim Wieland, reviewed by Jeff Davis; also hacked on by me.
* Move log_error_verbosity GUC setting to "What to log" section, andBruce Momjian2010-02-16
| | | | document the behavior of terse and verbose output options.
* Honor to_char() "FM" specification in YYY, YY, and Y; it was alreadyBruce Momjian2010-02-16
| | | | | | honored by YYYY. Also document Oracle "toggle" FM behavior. Per report from Guy Rouillier
* Have SELECT and CREATE TABLE AS queries return a row count. While thisBruce Momjian2010-02-16
| | | | | | | is invisible in psql, other interfaces, like libpq, make this value visible. Boszormenyi Zoltan
* Clarify documentation on the behavior of unnamed bind queries.Bruce Momjian2010-02-16
|
* Fix synopsis of DO statement.Itagaki Takahiro2010-02-16
|
* Add psql tab completion for DO blocks.Itagaki Takahiro2010-02-15
| | | | | | Also adjust documentation of DO. Patch from David Fetter and subsequent discussion.
* Ooops, let's get the non-null vs null bit right ...Tom Lane2010-02-14
|
* Document the behavior of STRICT VARIADIC functions.Tom Lane2010-02-14
|
* Remove tabs from sgml.Bruce Momjian2010-02-13
|
* Add plperl.on_plperl_init and plperl.on_plperlu_init settings for ↵Andrew Dunstan2010-02-12
| | | | language-specific startup. Rename recently added plperl.on_perl_init to plperl.on_init. Also, code cleanup for utf8 hack. Patch from Tim Bunce, reviewed by Alex Hunsaker.
* Extend the set of frame options supported for window functions.Tom Lane2010-02-12
| | | | | | | | | This patch allows the frame to start from CURRENT ROW (in either RANGE or ROWS mode), and it also adds support for ROWS n PRECEDING and ROWS n FOLLOWING start and end points. (RANGE value PRECEDING/FOLLOWING isn't there yet --- the grammar works, but that's all.) Hitoshi Harada, reviewed by Pavel Stehule
* Update Hot Standby documentation to reflect the change in the LOGHeikki Linnakangas2010-02-12
| | | | messages printed at startup. As pointed out by Simon Riggs.
* Clean up Streaming Replication documentation a little bit. A lot moreHeikki Linnakangas2010-02-12
| | | | needs to be done, but it's a step forward..
* Move "Warm Standby Servers for High Availability" and "Hot Standby"Heikki Linnakangas2010-02-09
| | | | | | sections under "High Availability, Load Balancing, and Replication" chapter. Streaming replication chapter needs a lot more work, but this commit just moves things around.
* Create an official API function for C functions to use to check if they areTom Lane2010-02-08
| | | | | | | | | | being called as aggregates, and to get the aggregate transition state memory context if needed. Use it instead of poking directly into AggState and WindowAggState in places that shouldn't know so much. We should have done this in 8.4, probably, but better late than never. Revised version of a patch by Hitoshi Harada.
* Update high availability/replication documentation chart for new hotBruce Momjian2010-02-08
| | | | standby featureset.
* Remove old-style VACUUM FULL (which was known for a little while asTom Lane2010-02-08
| | | | | | | | | | | | | | | | | VACUUM FULL INPLACE), along with a boatload of subsidiary code and complexity. Per discussion, the use case for this method of vacuuming is no longer large enough to justify maintaining it; not to mention that we don't wish to invest the work that would be needed to make it play nicely with Hot Standby. Aside from the code directly related to old-style VACUUM FULL, this commit removes support for certain WAL record types that could only be generated within VACUUM FULL, redirect-pointer removal in heap_page_prune, and nontransactional generation of cache invalidation sinval messages (the last being the sticking point for Hot Standby). We still have to retain all code that copes with finding HEAP_MOVED_OFF and HEAP_MOVED_IN flag bits on existing tuples. This can't be removed as long as we want to support in-place update from pre-9.0 databases.
* Create a "relation mapping" infrastructure to support changing the relfilenodesTom Lane2010-02-07
| | | | | | | | | | | | | | | | | | | | | | | of shared or nailed system catalogs. This has two key benefits: * The new CLUSTER-based VACUUM FULL can be applied safely to all catalogs. * We no longer have to use an unsafe reindex-in-place approach for reindexing shared catalogs. CLUSTER on nailed catalogs now works too, although I left it disabled on shared catalogs because the resulting pg_index.indisclustered update would only be visible in one database. Since reindexing shared system catalogs is now fully transactional and crash-safe, the former special cases in REINDEX behavior have been removed; shared catalogs are treated the same as non-shared. This commit does not do anything about the recently-discussed problem of deadlocks between VACUUM FULL/CLUSTER on a system catalog and other concurrent queries; will address that in a separate patch. As a stopgap, parallel_schedule has been tweaked to run vacuum.sql by itself, to avoid such failures during the regression tests.
* Mention warm and now "hot" standby servers in the high availability docs.Bruce Momjian2010-02-05
|
* Document that archive_timeout will force new WAL files even if a singleBruce Momjian2010-02-05
| | | | | checkpoint has happened, and recommend adjusting checkpoint_timeout to reduce the impact of this.
* Previous commit was: Properly document that OVER and WINDOW are Postgres ↵Bruce Momjian2010-02-05
| | | | reserved words.
* Previous commit was to have tab checking as part of gmake check.Bruce Momjian2010-02-05
|
* *** empty log message ***Bruce Momjian2010-02-05
|
* Improve PL/Perl documentation of database access functions.Bruce Momjian2010-02-05
| | | | Alexey Klyukin
* Add SGML 'check-tabs' Makefile rule to check for tabs.Bruce Momjian2010-02-05
|
* Modify recently added PQconnectdbParams() with new argument, expand_dbname.Joe Conway2010-02-05
| | | | | | | | | | | | | | | | If expand_dbname is non-zero and dbname contains an = sign, it is taken as a conninfo string in exactly the same way as if it had been passed to PQconnectdb. This is equivalent to the way PQsetdbLogin() works, allowing PQconnectdbParams() to be a complete alternative. Also improve the way the new function is called from psql and replace a previously missed call to PQsetdbLogin() in psql. Additionally use PQconnectdbParams() for pg_dump and friends, and the bin/scripts command line utilities such as vacuumdb, createdb, etc. Finally, update the documentation for the new parameter, as well as the nuances of precedence in cases where key words are repeated or duplicated in the conninfo string.
* Three out of four of us like this phrasing better.Tom Lane2010-02-04
|
* Mention "unquoted" identifiers are case-insensitive.Bruce Momjian2010-02-03
|
* Proofreading improvements for the Administration documentation book.Bruce Momjian2010-02-03
|
* Add a message type header to the CopyData messages sent from primaryHeikki Linnakangas2010-02-03
| | | | | to standby in streaming replication. While we only have one message type at the moment, adding a message type header makes this easier to extend.
* Make RADIUS authentication use pg_getaddrinfo_all() to get address ofMagnus Hagander2010-02-02
| | | | | | | the server. Gets rid of a fairly ugly hack for Solaris, and also provides hostname and IPV6 support.
* Remove tabs in sgml.Bruce Momjian2010-02-01
|
* Minor documentation improvements for new string_agg aggregate.Robert Haas2010-02-01
|
* Revoke augmentation of WAL records for btree delete, per discussion.Simon Riggs2010-02-01
|
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-14 13:23:14 +0000