aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
...
* Don't pass an invalid file handle to dup2(). That causes a crash onHeikki Linnakangas2010-04-01
| | | | | | | | | | | Windows, thanks to a feature in CRT called Parameter Validation. Backpatch to 8.2, which is the oldest version supported on Windows. In 8.2 and 8.3 also backpatch the earlier change to use DEVNULL instead of NULL_DEV #define for a /dev/null-like device. NULL_DEV was hard-coded to "/dev/null" regardless of platform, which didn't work on Windows, while DEVNULL works on all platforms. Restarting syslogger didn't work on Windows on versions 8.3 and below because of that.
* Use a file of patterns of filenames to exclude from pgindent runs, instead ↵Andrew Dunstan2010-04-01
| | | | if using multiple invocations of egrep. Add perl ppport.h to the current list.
* Change test -e to test -f in docs, for portability.Bruce Momjian2010-04-01
|
* Zoltan beautified his hidden-variable-patch for ecpg. This also makes sure ↵Michael Meskes2010-04-01
| | | | we get an error message instead of a warning if the variable have different types.
* Applied Zoltan's patch to make ecpg spit out warnings if a local variable ↵Michael Meskes2010-04-01
| | | | hides a global one with the same name.
* Add contraint exclusion section to contraint docs.REL9_0_ALPHA5Bruce Momjian2010-04-01
| | | | Takahiro Itagaki
* Refer to max_wal_senders in a more consistent fashion.Robert Haas2010-04-01
| | | | | | | The error message now makes explicit reference to the GUC that must be changed to fix the problem, using wording suggested by Tom Lane. Along the way, rename the GUC from MaxWalSenders to max_wal_senders for consistency and grep-ability.
* Add full names for release note item authors.Bruce Momjian2010-04-01
|
* Use test -e rather than test -f.Bruce Momjian2010-04-01
|
* Improve 9.0 release notes by removing extra parentheses and linking to aBruce Momjian2010-04-01
| | | | more appropriate place for exclusion constraints.
* Revert change that prevented ellipses from looking like ../.Bruce Momjian2010-03-31
|
* Clarify ellipses use in archive_command example, per Josh Kupershmidt.Bruce Momjian2010-03-31
|
* Document why 'cp -i </dev/null' is suggested for archive command.Bruce Momjian2010-03-31
|
* Fix typos, spotted by Thom Brown.Heikki Linnakangas2010-03-31
|
* Enhance standby documentation.Heikki Linnakangas2010-03-31
| | | | | Original patch by Fujii Masao, with heavy editing and bitrot-fixing after my other commit.
* Mention in the docs that if special keywords like "sameuser" andHeikki Linnakangas2010-03-31
| | | | "replication" are quoted in pg_hba.conf, they lose their special meaning.
* Enhance documentation of the build-in standby mode, explaining the retryHeikki Linnakangas2010-03-31
| | | | | | | | | | | | | | loop in standby mode, trying to restore from archive, pg_xlog and streaming. Move sections around to make the high availability chapter more coherent: the most prominent part is now a "Log-Shipping Standby Servers" section that describes what a standby server is (like the old "Warm Standby Servers for High Availability" section), and how to set up a warm standby server, including streaming replication, using the built-in standby mode. The pg_standby method is desribed in another section called "Alternative method for log shipping", with the added caveat that it doesn't work with streaming replication.
* Change recovery.conf.sample to match postgresql.conf by showing onlyBruce Momjian2010-03-31
| | | | default values, with example comments.
* Give a more precise error message if a variable is re-used as cursor name in ↵Michael Meskes2010-03-31
| | | | ecpg.
* Fix "constraint_exclusion = partition" logic so that it will also attemptTom Lane2010-03-30
| | | | | | constraint exclusion on an inheritance set that is the target of an UPDATE or DELETE query. Per gripe from Marc Cousin. Back-patch to 8.4 where the feature was introduced.
* Change the retry-loop in standby mode to also try restoring files fromHeikki Linnakangas2010-03-30
| | | | | | | | | | | | | | | | pg_xlog directory. This is essential for replaying WAL records that were streamed from the master, after a standby server restart. If a corrupt record is seen in a file restored from the archive or streamed from the master, log it as a WARNING and keep retrying. If the corruption is permanent, and not just a glitch in the whatever copies the files to the archive or a network error not caught by CRC checks in TCP for example, we will keep retrying and logging the WARNING indefinitely. But that's better than shutting down completely, the standby is still useful for running read-only queries. In PITR the recovery ends at such a corrupt record, which is a bit questionable, but that's the behavior we had in previous releases and we don't feel like chaning it now. It does make sense for tools like pg_standby.
* Message tuningPeter Eisentraut2010-03-30
|
* Properly initialize local varaible inBruce Momjian2010-03-30
| | | | | btree_xlog_delete_get_latestRemovedXid(). This variable was only tested in assert builds.
* Add comma missing from postgresql.conf comment.Bruce Momjian2010-03-30
|
* Separate targets "make docs" and "make install-docs" for the documentationPeter Eisentraut2010-03-30
| | | | | | | | It is no longer installed by default, but included in "make world"/"make install-world". Documentation updated accordingly. Also, fix vpathsearch function to work when calling make install-docs without previous make docs.
* Add note that XML Schema validation is not supportedPeter Eisentraut2010-03-29
| | | | requested by Andrew Lardinois
* Add some information about what it means for PL/Python to be untrusted.Peter Eisentraut2010-03-29
| | | | Similar information already appears in the PL/Perl and PL/Tcl chapters.
* Add some documentation about PL/Python limitationsPeter Eisentraut2010-03-29
| | | | suggested by Steve White (bug #5272)
* Edit recovery.conf.sample so it matches docs. Change standby_modeSimon Riggs2010-03-29
| | | | | | example to 'on or 'off' rather than 'true' or 'false', as shown in docs. Add restartpoint_command. Add section header for recovery target parameters, matching docs.
* Rework join-removal logic as per recent discussion. In particular thisTom Lane2010-03-28
| | | | | fixes things so that it works for cases where nested removals are possible. The overhead of the optimization should be significantly less, as well.
* Derive latestRemovedXid for btree deletes by reading heap pages. TheSimon Riggs2010-03-28
| | | | | | | | | | | WAL record for btree delete contains a list of tids, even when backup blocks are present. We follow the tids to their heap tuples, taking care to follow LP_REDIRECT tuples. We ignore LP_DEAD tuples on the understanding that they will always have xmin/xmax earlier than any LP_NORMAL tuples referred to by killed index tuples. Iff all tuples are LP_DEAD we return InvalidTransactionId. The heap relfilenode is added to the WAL record, requiring API changes to pass down the heap Relation. XLOG_PAGE_MAGIC updated.
* Flush CopyOutResponse when starting streaming in walsender, so that it'sHeikki Linnakangas2010-03-26
| | | | | | not delayed until the first WAL record is sent. Fujii Masao
* Modify some new and pre-existing messages for translatability.Simon Riggs2010-03-25
|
* Fix ginint4_queryextract() to actually do what it was intended to do for anTom Lane2010-03-25
| | | | | | | | | unsatisfiable query, such as indexcol && empty_array. It should return -1 to tell GIN no scan is required; but silly typo disabled the logic for that, resulting in unnecessary "GIN indexes do not support whole-index scans" error. Per bug report from Jeff Trout. Back-patch to 8.3 where the logic was introduced.
* Prevent ALTER USER f RESET ALL from removing the settings that were put thereAlvaro Herrera2010-03-25
| | | | | | | | by a superuser -- "ALTER USER f RESET setting" already disallows removing such a setting. Apply the same treatment to ALTER DATABASE d RESET ALL when run by a database owner that's not superuser.
* Additional thoughts on WALSender cpu reduction. Use long typeSimon Riggs2010-03-24
| | | | and alter a comment to reduce confusion.
* Change replication connection log format to allow for a databaseSimon Riggs2010-03-24
| | | | | called replication. Add host and port details, following format of messages in BackendInitialize().
* Reduce CPU utilisation of WALSender process. Process was using 10% CPUSimon Riggs2010-03-24
| | | | | | doing nothing, caused by naptime specified in milliseconds yet units of pg_usleep() parameter is microseconds. Correctly specifying units reduces call frequency by 1000. Reduction in CPU consumption verified.
* Fix thinko in log message for "sameuser" ident map mismatch: the providedTom Lane2010-03-24
| | | | | | | and authenticated usernames were swapped. Reported by Bryan Henderson in bug #5386. Also clean up poorly-maintained header comment for this function.
* Now that we know last_statrequest > last_statwrite can be observed in theTom Lane2010-03-24
| | | | buildfarm, expend a little more effort on the log message for it.
* Mark "installcheck-parallel", "world", "install-world" and ↵Andrew Dunstan2010-03-24
| | | | "installcheck-world" make targets as PHONY. Fujii Masao.
* Update description of walrcv_receive() function to match reality.Heikki Linnakangas2010-03-24
|
* Document in postgresql.conf that the max_standby_delay default is 30Bruce Momjian2010-03-24
| | | | 'seconds'.
* Typo fix from IRC breinbaasBruce Momjian2010-03-23
|
* Remove useless double assignmentPeter Eisentraut2010-03-23
| | | | GCC 4.5 complained about it.
* Remove CRs for each line in pgbench.sgml.Itagaki Takahiro2010-03-23
|
* Add back other xlog() function author names.Bruce Momjian2010-03-23
|
* Each worker thread will have its own log file in pgbench to avoid interleavedItagaki Takahiro2010-03-23
| | | | | | | writes. The first worker still uses "pgbench_log.<pid>" for the name, but additional workers use "pgbench_log.<pid>.<serial-number>" instead. Reported by Greg Smith.
* Properly credit Simon for functions pg_last_xlog_replay_location, etc.Bruce Momjian2010-03-22
|
* Fix regression test breakage from recent change in default name of ↵Tom Lane2010-03-22
| | | | exclusion-constraint index.
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-05 02:32:19 +0000