diff options
| author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2022-01-24 17:18:29 -0300 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2022-01-25 17:13:49 +0100 |
| commit | 30c15a5e48886b78d0bd3eac3e5bdf9f29cd9ac3 (patch) | |
| tree | 1588d6d577ecebb9587ae13a2e60e53cff18e211 | |
| parent | 919def267b89cfe03f40218baa8c16cf65526448 (diff) | |
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.hallot@libreoffice.org>
| -rw-r--r-- | AllLangHelp_sdatabase.mk | 1 | ||||
| -rw-r--r-- | source/text/sdatabase/dabawiz01.xhp | 1 | ||||
| -rw-r--r-- | source/text/sdatabase/dabawiz02pgsql.xhp | 50 |
3 files changed, 52 insertions, 0 deletions
diff --git a/AllLangHelp_sdatabase.mk b/AllLangHelp_sdatabase.mk index fec5f43b94..b715812eec 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 2da4272741..0a8b98b8ec 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 0000000000..91a2f0aa25 --- /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> |