Библиография

Здесь представлены ссылки на справочные материалы и книги, посвящённые SQL и PostgreSQL.

Некоторые статьи и технические описания, написанные первой командой разработки POSTGRES, можно найти на сайте факультета компьютерных наук Калифорнийского университета в Беркли.

Справочники по языку SQL

[bowman01] The Practical SQL Handbook. Using SQL Variants. Fourth Edition. Judith Bowman, Sandra Emerson, Marcy Darnovsky. ISBN 0-201-70309-2. Addison-Wesley Professional. 2001.

[date97] A Guide to the SQL Standard. A user's guide to the standard database language SQL. Fourth Edition. C. J. Date Hugh Darwen. ISBN 0-201-96426-0. Addison-Wesley. 1997.

[date04] An Introduction to Database Systems. Eighth Edition. C. J. Date. ISBN 0-321-19784-4. Addison-Wesley. 2003.

[elma04] Fundamentals of Database Systems. Fourth Edition. Ramez Elmasri Shamkant Navathe. ISBN 0-321-12226-7. Addison-Wesley. 2003.

[melt93] Understanding the New SQL. A complete guide. Jim Melton Alan R. Simon. ISBN 1-55860-245-3. Morgan Kaufmann. 1993.

[ull88] Principles of Database and Knowledge-Base Systems. Classical Database Systems. Jeffrey D. Ullman. Volume 1. Computer Science Press. 1988.

[sqltr-19075-6] SQL Technical Report. Part 6: SQL support for JavaScript Object Notation (JSON). First Edition. 2017.

Документация, посвящённая PostgreSQL

[sim98] Enhancement of the ANSI SQL Implementation of PostgreSQL. Stefan Simkovics. Department of Information Systems, Vienna University of Technology. Vienna, Austria. November 29, 1998.

[yu95] The Postgres95. User Manual. A. Yu J. Chen. University of California. Berkeley, California. Sept. 5, 1995.

[fong] The design and implementation of the POSTGRES query optimizer. Zelaine Fong. University of California, Berkeley, Computer Science Department.

Заметки и статьи

[ports12] «Serializable Snapshot Isolation in PostgreSQL». D. Ports K. Grittner. VLDB Conference, August 2012.

[berenson95] «A Critique of ANSI SQL Isolation Levels». H. Berenson, P. Bernstein, J. Gray, J. Melton, E. O'Neil, P. O'Neil. ACM-SIGMOD Conference on Management of Data, June 1995.

[olson93] Partial indexing in POSTGRES: research project. Nels Olson. UCB Engin T7.49.1993 O676. University of California. Berkeley, California. 1993.

[ong90] «A Unified Framework for Version Modeling Using Production Rules in a Database System». L. Ong J. Goh. ERL Technical Memorandum M90/33. University of California. Berkeley, California. April, 1990.

[rowe87] «The POSTGRES data model». L. Rowe M. Stonebraker. VLDB Conference, Sept. 1987.

[seshadri95] «Generalized Partial Indexes». P. Seshadri A. Swami. Eleventh International Conference on Data Engineering, 6–10 March 1995. Cat. No.95CH35724. IEEE Computer Society Press. Los Alamitos, California. 1995. 420–7.

[ston86] «The design of POSTGRES». M. Stonebraker L. Rowe. ACM-SIGMOD Conference on Management of Data, May 1986.

[ston87a] «The design of the POSTGRES rules system». M. Stonebraker, E. Hanson, C. H. Hong. IEEE Conference on Data Engineering, Feb. 1987.

[ston87b] «The design of the POSTGRES storage system». M. Stonebraker. VLDB Conference, Sept. 1987.

[ston89] «A commentary on the POSTGRES rules system». M. Stonebraker, M. Hearst, S. Potamianos. SIGMOD Record 18(3). Sept. 1989.

[ston89b] «The case for partial indexes». M. Stonebraker. SIGMOD Record 18(4). Dec. 1989. 4–11.

[ston90a] «The implementation of POSTGRES». M. Stonebraker, L. A. Rowe, M. Hirohama. Transactions on Knowledge and Data Engineering 2(1). IEEE. March 1990.

[ston90b] «On Rules, Procedures, Caching and Views in Database Systems». M. Stonebraker, A. Jhingran, J. Goh, S. Potamianos. ACM-SIGMOD Conference on Management of Data, June 1990.

[ston92] « Обзор проекта Sequoia 2000 ». M. Stonebraker. Аннотация докладов COMPCON Spring 1992. 1992. 383–388.

Q.1. recovery.conf file merged into postgresql.conf

Postgres Pro 11 and below used a configuration file named recovery.conf to manage replicas and standbys. Support for this file was removed in Postgres Pro 12. See the release notes for PostgreSQL 12 for details on this change.

On Postgres Pro 12 and above, archive recovery, streaming replication, and PITR are configured using normal server configuration parameters. These are set in postgresql.conf or via ALTER SYSTEM like any other parameter.

The server will not start if a recovery.conf exists.

The trigger_file setting has been renamed to promote_trigger_file.

The standby_mode setting has been removed. A standby.signal file in the data directory is used instead. See Standby Server Operation for details.