Skip to content
Snippets Groups Projects
  1. Aug 23, 2010
  2. Aug 22, 2010
  3. Aug 20, 2010
    • Tom Lane's avatar
      Bring some sanity to the trace_recovery_messages code and docs. · 79dc97a4
      Tom Lane authored
      Per gripe from Fujii Masao, though this is not exactly his proposed patch.
      Categorize as DEVELOPER_OPTIONS and set context PGC_SIGHUP, as per Fujii,
      but set the default to LOG because higher values aren't really sensible
      (see the code for trace_recovery()).  Fix the documentation to agree with
      the code and to try to explain what the variable actually does.  Get rid
      of no-op calls trace_recovery(LOG), which accomplish nothing except to
      demonstrate that this option confuses even its author.
      79dc97a4
  4. Aug 17, 2010
  5. Aug 03, 2010
  6. Jul 29, 2010
    • Peter Eisentraut's avatar
      Fix indentation of verbatim block elements · 66424a28
      Peter Eisentraut authored
      Block elements with verbatim formatting (literallayout, programlisting,
      screen, synopsis) should be aligned at column 0 independent of the surrounding
      SGML, because whitespace is significant, and indenting them creates erratic
      whitespace in the output.  The CSS stylesheets already take care of indenting
      the output.
      
      Assorted markup improvements to go along with it.
      66424a28
  7. Jul 27, 2010
  8. Jul 24, 2010
  9. Jul 22, 2010
    • Robert Haas's avatar
      Add options to force quoting of all identifiers. · ce68df46
      Robert Haas authored
      I've added a quote_all_identifiers GUC which affects the behavior
      of the backend, and a --quote-all-identifiers argument to pg_dump
      and pg_dumpall which sets the GUC and also affects the quoting done
      internally by those applications.
      
      Design by Tom Lane; review by Alex Hunsaker; in response to bug #5488
      filed by Hartmut Goebel.
      ce68df46
  10. Jul 20, 2010
    • Robert Haas's avatar
      Add restart_after_crash GUC. · 5ffaa900
      Robert Haas authored
      Normally, we automatically restart after a backend crash, but in some
      cases when PostgreSQL is invoked by clusterware it may be desirable to
      suppress this behavior, so we provide an option which does this.
      Since no existing GUC group quite fits, create a new group called
      "error handling options" for this and the previously undocumented GUC
      exit_on_error, which is now documented.
      
      Review by Fujii Masao.
      5ffaa900
    • Robert Haas's avatar
      Change the default value of standard_conforming_strings to on. · 0839f312
      Robert Haas authored
      This change should be publicized to driver maintainers at once and
      release-noted as an incompatibility with previous releases.
      0839f312
  11. Jul 17, 2010
  12. Jul 16, 2010
  13. Jul 08, 2010
  14. Jul 07, 2010
  15. Jul 06, 2010
  16. Jul 04, 2010
  17. Jul 03, 2010
    • Tom Lane's avatar
      Make vacuum_defer_cleanup_age be PGC_SIGHUP level, since it's not sensible · aceedd88
      Tom Lane authored
      to have different values in different processes of the primary server.
      Also put it into the "Streaming Replication" GUC category; it doesn't belong
      in "Standby Servers" because you use it on the master not the standby.
      In passing also correct guc.c's idea of wal_keep_segments' category.
      aceedd88
    • Tom Lane's avatar
      Replace max_standby_delay with two parameters, max_standby_archive_delay and · e76c1a0f
      Tom Lane authored
      max_standby_streaming_delay, and revise the implementation to avoid assuming
      that timestamps found in WAL records can meaningfully be compared to clock
      time on the standby server.  Instead, the delay limits are compared to the
      elapsed time since we last obtained a new WAL segment from archive or since
      we were last "caught up" to WAL data arriving via streaming replication.
      This avoids problems with clock skew between primary and standby, as well
      as other corner cases that the original coding would misbehave in, such
      as the primary server having significant idle time between transactions.
      Per my complaint some time ago and considerable ensuing discussion.
      
      Do some desultory editing on the hot standby documentation, too.
      e76c1a0f
  18. Jun 30, 2010
  19. Jun 29, 2010
  20. Jun 28, 2010
  21. Jun 25, 2010
  22. Jun 22, 2010
  23. Jun 15, 2010
  24. May 31, 2010
  25. May 27, 2010
  26. May 20, 2010
  27. May 18, 2010
  28. May 03, 2010
  29. May 02, 2010
    • Simon Riggs's avatar
      Mention that max_standby_delay has units of milliseconds. Units are mentioned · 98bbab47
      Simon Riggs authored
      for all other parameters where the default is expressed in a different unit.
      98bbab47
    • Tom Lane's avatar
      Clean up some awkward, inaccurate, and inefficient processing around · f9ed327f
      Tom Lane authored
      MaxStandbyDelay.  Use the GUC units mechanism for the value, and choose more
      appropriate timestamp functions for performing tests with it.  Make the
      ps_activity manipulation in ResolveRecoveryConflictWithVirtualXIDs have
      behavior similar to ps_activity code elsewhere, notably not updating the
      display when update_process_title is off and not truncating the display
      contents at an arbitrarily-chosen length.  Improve the docs to be explicit
      about what MaxStandbyDelay actually measures, viz the difference between
      primary and standby servers' clocks, and the possible hazards if their clocks
      aren't in sync.
      f9ed327f
  30. Apr 29, 2010
  31. Apr 28, 2010
    • Heikki Linnakangas's avatar
      Introduce wal_level GUC to explicitly control if information needed for · 9b8a7332
      Heikki Linnakangas authored
      archival or hot standby should be WAL-logged, instead of deducing that from
      other options like archive_mode. This replaces recovery_connections GUC in
      the primary, where it now has no effect, but it's still used in the standby
      to enable/disable hot standby.
      
      Remove the WAL-logging of "unlogged operations", like creating an index
      without WAL-logging and fsyncing it at the end. Instead, we keep a copy of
      the wal_mode setting and the settings that affect how much shared memory a
      hot standby server needs to track master transactions (max_connections,
      max_prepared_xacts, max_locks_per_xact) in pg_control. Whenever the settings
      change, at server restart, write a WAL record noting the new settings and
      update pg_control. This allows us to notice the change in those settings in
      the standby at the right moment, they used to be included in checkpoint
      records, but that meant that a changed value was not reflected in the
      standby until the first checkpoint after the change.
      
      Bump PG_CONTROL_VERSION and XLOG_PAGE_MAGIC. Whack XLOG_PAGE_MAGIC back to
      the sequence it used to follow, before hot standby and subsequent patches
      changed it to 0x9003.
      9b8a7332
  32. Apr 26, 2010
    • Robert Haas's avatar
      When we're restricting who can connect, don't allow new walsenders. · ab93cd9b
      Robert Haas authored
      Normal superuser processes are allowed to connect even when the database
      system is shutting down, or when fewer than superuser_reserved_connection
      slots remain.  This is intended to make sure an administrator can log in
      and troubleshoot, so don't extend these same courtesies to users connecting
      for replication.
      ab93cd9b
  33. Apr 20, 2010
  34. Apr 19, 2010
    • Robert Haas's avatar
      Add an 'enable_material' GUC. · 5b89ef38
      Robert Haas authored
      The logic for determining whether to materialize has been significantly
      overhauled for 9.0.  In case there should be any doubt about whether
      materialization is a win in any particular case, this should provide a
      convenient way of seeing what happens without it; but even with enable_material
      turned off, we still materialize in cases where it is required for
      correctness.
      
      Thanks to Tom Lane for the review.
      5b89ef38
Loading