AllLangHelp_sdatabase.mk | 1
source/text/sdatabase/dabawiz01.xhp | 1
source/text/sdatabase/dabawiz02pgsql.xhp | 50 +++++++++++++++++++++++++++++++
3 files changed, 52 insertions(+)
New commits:
commit 30c15a5e48886b78d0bd3eac3e5bdf9f29cd9ac3
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Mon Jan 24 17:18:29 2022 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Tue Jan 25 17:13:49 2022 +0100
Add PostgreSQL connection Help page
Related to tdf#43369 where a patch has been abandonned but is
nevertheless still much wanted.
The db connection wizard is generic and has no information on
the required connection sctrings. The Help button in the wizard is
not working as of today.
The issue is recurrent in user-space.
Change-Id: I3a5d30f859d6fb4e12813df3fe6df35d5e2e0f68
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/128887
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/AllLangHelp_sdatabase.mk b/AllLangHelp_sdatabase.mk
index fec5f43b9..b715812ee 100644
--- a/AllLangHelp_sdatabase.mk
+++ b/AllLangHelp_sdatabase.mk
@@ -66,6 +66,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,sdatabase,\
helpcontent2/source/text/sdatabase/dabawiz02jdbc \
helpcontent2/source/text/sdatabase/dabawiz02mysql \
helpcontent2/source/text/sdatabase/dabawiz02odbc \
+ helpcontent2/source/text/sdatabase/dabawiz02pgsql \
helpcontent2/source/text/sdatabase/dabawiz02oracle \
helpcontent2/source/text/sdatabase/dabawiz02spreadsheet \
helpcontent2/source/text/sdatabase/dabawiz02text \
diff --git a/source/text/sdatabase/dabawiz01.xhp
b/source/text/sdatabase/dabawiz01.xhp
index 2da427274..0a8b98b8e 100644
--- a/source/text/sdatabase/dabawiz01.xhp
+++ b/source/text/sdatabase/dabawiz01.xhp
@@ -64,6 +64,7 @@
<paragraph role="paragraph" id="par_idN10667" xml-lang="en-US"><link
href="text/sdatabase/dabawiz02jdbc.xhp">Set up JDBC
connection</link></paragraph>
<paragraph role="paragraph" id="par_idN10676" xml-lang="en-US"><link
href="text/sdatabase/dabawiz02oracle.xhp">Set up Oracle database
connection</link></paragraph>
<embed href="text/sdatabase/dabawiz02mysql.xhp#mysql"/>
+<embed href="text/sdatabase/dabawiz02pgsql.xhp#pgsqlh1"/>
<paragraph role="paragraph" id="par_idN10694" xml-lang="en-US"><link
href="text/sdatabase/dabawiz02odbc.xhp">ODBC settings</link></paragraph>
<paragraph role="paragraph" id="par_idN106A3" xml-lang="en-US"><link
href="text/sdatabase/dabawiz02spreadsheet.xhp">Set up Spreadsheet
connection</link></paragraph>
</body>
diff --git a/source/text/sdatabase/dabawiz02pgsql.xhp
b/source/text/sdatabase/dabawiz02pgsql.xhp
new file mode 100644
index 000000000..91a2f0aa2
--- /dev/null
+++ b/source/text/sdatabase/dabawiz02pgsql.xhp
@@ -0,0 +1,50 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+ <!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ -->
+
+ <meta>
+ <topic id="textsdatabasedabawiz02pgsqlxml" indexer="include"
status="PUBLISH">
+ <title id="tit" xml-lang="en-US">PostgresSQL Connection</title>
+ <filename>/text/sdatabase/dabawiz02pgsql.xhp</filename>
+ </topic>
+ </meta>
+ <body>
+ <bookmark xml-lang="en-US" branch="index" id="bm_id861587404584956">
+<bookmark_value>PostgreSQL settings (Base)</bookmark_value>
+ </bookmark>
+ <bookmark xml-lang="en-US"
branch="hid/dbaccess/ui/dbwizconnectionpage/ConnectionPage"
id="bm_id701643051950111" localize="false"/>
+ <section id="pgsqlHead">
+ <h1 id="hd_id971643043442131"><variable id="pgsqlh1"><link
href="text/sdatabase/dabawiz02pgsql.xhp" name="pgconnection">PostgresSQL
Connection</link></variable></h1>
+ <paragraph id="par_id811643043442133" role="paragraph"
xml-lang="en-US">Specifies the options for connecting to PostgresSQL
databases.</paragraph>
+ </section>
+ <h2 id="hd_id321643044241406">DBMS/driver-specific connection string</h2>
+ <paragraph role="paragraph" id="par_id341643044249556">Enter the driver
specific connection string. The connection string is sequence of keyword/value
pairs separated by spaces. For example</paragraph>
+ <paragraph role="paragraph"
id="par_id471643044279530"><literal>dbname=MyDatabase host=myHost
port=5432</literal></paragraph>
+ <paragraph role="paragraph" id="par_id301643045873140">where</paragraph>
+ <list type="unordered">
+ <listitem>
+ <paragraph id="par_id511643044303340"
role="listitem"><emph>dbname</emph>: the name of the database hosted in the
DBMS server.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id331643044364699"
role="listitem"><emph>host</emph>: the fully qualified name of the RDBMS
server</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id931643044367236"
role="listitem"><emph>port</emph>: the server port. The default port for
PostgreSQL is 5432.</paragraph>
+ </listitem>
+ </list>
+ <paragraph role="paragraph" id="par_id421643049901759">You can also enter
the connection string as</paragraph> <paragraph role="paragraph"
id="par_id51643050033680"><literal>postgresql://myHost:port/MyDatabase</literal>.</paragraph>
+
+ <note id="par_id71643046088031">Refer to the database server administrator
for the correct values of the keywords passed in the connection string. Values
for <emph>user=</emph> and <emph>password=</emph> are ignored but will be
requested at connection time.</note>
+ <tip id="par_id131643048856194">The connection string is displayed in the
%PRODUCTNAME Base status bar.</tip>
+ <section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id571643046067450">List of all
keyword/value pairs for <link
href="https://www.postgresql.org/docs/13/libpq-connect.html#LIBPQ-PARAMKEYWORDS";
name="PG13keywords">PostgresSQL 13</link> connection string. Not every pair is
handled by the %PRODUCTNAME driver manager.</paragraph>
+ </section>
+</body>
+</helpdocument>
