Merge ~clinton-fung/launchpad:faq-migration-postgres into launchpad:master

[Clinton Fung]

Relocate database-related information from FAQs to a new section under Explanation

Relocate database-related information from FAQs to a new section under Explanation

[Clinton Fung (clinton-fung)]

Subsumed by https://code.launchpad.net/~cjwatson/launchpad/+git/launchpad/+merge/427502

Unmerged commits

7101322... by Clinton Fung on 2022-09-20

Relocate database-related information from FAQs to a new section under Explanation

	docs:0 (build)
	lint:0 (build)
	mypy:0 (build)

1 → 3 of 3 results

First • Previous • Next • Last

diff --git a/doc/explanation/index.rst b/doc/explanation/index.rst
index c6b72d0..a7db240 100644
--- a/doc/explanation/index.rst
+++ b/doc/explanation/index.rst
@@ -12,3 +12,4 @@ Explanation
    architecture
    pip
    favicon
+   postgres
diff --git a/doc/explanation/postgres.rst b/doc/explanation/postgres.rst
new file mode 100644
index 0000000..96b9bcf
--- /dev/null
+++ b/doc/explanation/postgres.rst
@@ -0,0 +1,33 @@
+==================
+Launchpad database
+==================
+
+Why PostgreSQL?
+===============
+
+PostgreSQL was chosen in 2004 because it supported most of the features we
+thought we would need; MySQL did not.  The other contender was Oracle, and
+for a while we made sure we would be able to switch to Oracle if necessary
+but PostgreSQL has worked great.
+
+How integrated is the database in the code?
+===========================================
+
+Highly. We make use of PostgreSQL specific features, such as:
+
+* SQL language extensions
+* PL/pgSQL and Python stored procedures
+* Triggers
+* Functional indexes
+* Automatic load balancing over the replicas with Slony-I
+* Transactional DDL
+* tsearch2 full text search
+* Database permissions
+
+My database permissions keep getting deleted!
+=============================================
+
+If your local account is called "launchpad" it conflicts with a role called
+"launchpad" which is defined in ``database/schema/security.cfg``.  You need
+to rename your local account and re-assign it superuser permissions as the
+``utilities/launchpad-database-setup`` script does.
diff --git a/doc/faq.rst b/doc/faq.rst
index cc7a6a7..e2c1304 100644
--- a/doc/faq.rst
+++ b/doc/faq.rst
@@ -8,28 +8,6 @@ Are there Launchpad packages available?
 No, Launchpad is not packaged and there are no plans to do so.  Launchpad
 deployment is done straight from Git branches and is quite complex.
 
-Why PostgreSQL?
-===============
-
-PostgreSQL was chosen in 2004 because it supported most of the features we
-thought we would need; MySQL did not.  The other contender was Oracle, and
-for a while we made sure we would be able to switch to Oracle if necessary
-but PostgreSQL has worked great.
-
-How integrated is the database in the code?
-===========================================
-
-Highly. We make use of PostgreSQL specific features, such as:
-
-* SQL language extensions
-* PL/pgSQL and Python stored procedures
-* Triggers
-* Functional indexes
-* Automatic load balancing over the replicas with Slony-I
-* Transactional DDL
-* tsearch2 full text search
-* Database permissions
-
 What version of Python is required?
 ===================================
 
@@ -50,11 +28,3 @@ Development Launchpads don't send email to the outside world, for obvious
 reasons.  They connect to the local SMTP server and send to root.  To create
 new users, create a new account and check the local mailbox, or see
 :doc:`how-to/new-user`.
-
-My database permissions keep getting deleted!
-=============================================
-
-If your local account is called "launchpad" it conflicts with a role called
-"launchpad" which is defined in ``database/schema/security.cfg``.  You need
-to rename your local account and re-assign it superuser permissions as the
-``utilities/launchpad-database-setup`` script does.