blob: abbdfca5dc82a726fb4abc40e3658a675670d357 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
|
<?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">PostgreSQL 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>
<section id="pgsqlHead">
<h1 id="hd_id971643043442131"><variable id="pgsqlh1"><link href="text/sdatabase/dabawiz02pgsql.xhp">PostgreSQL Connection</link></variable></h1>
<paragraph id="par_id811643043442133" role="paragraph" xml-lang="en-US">Specifies the options for connecting to PostgreSQL databases.</paragraph>
</section>
<h2 id="hd_id651688208054254">Direct connection to PostgreSQL databases</h2>
<paragraph role="paragraph" id="par_id771688208079289">The data for the direct connection to a PostgreSQL database can be provided in two different ways:</paragraph>
<h3 id="hd_id861688208111738">Fill in the data</h3>
<paragraph role="paragraph" id="par_id421688208147990">Connection data can be provided by filling in the top three text boxes. Ask the database administrator for the correct data.</paragraph>
<bookmark branch="hid/dbaccess/ui/postgrespage/hostNameEntry" id="bm_id301688517436297" localize="false"/>
<bookmark branch="hid/dbaccess/ui/postgrespage/dbNameEntry" id="bm_id261688517538018" localize="false"/>
<bookmark branch="hid/dbaccess/ui/postgrespage/portNumEntry" id="bm_id111688517542714" localize="false"/>
<list type="unordered">
<listitem>
<paragraph id="par_id451688208281422" role="listitem"><emph>Database name</emph>: type the name of the specific database.</paragraph>
</listitem>
<listitem>
<paragraph id="par_id431688208308832" role="listitem"><emph>Server</emph>: provide the URL or IP address of the DBMS server.</paragraph>
</listitem>
<listitem>
<paragraph id="par_id781688208333506" role="listitem"><emph>Port number</emph>: enter the port number of the DBMS server.</paragraph>
</listitem>
</list>
<bookmark branch="hid/dbaccess/ui/postgrespage/browseurl" id="bm_id881688517530306" localize="false"/>
<h3 id="hd_id321643044241406">DBMS/driver-specific connection string</h3>
<paragraph role="paragraph" id="par_id341643044249556">Instead of entering the data in the text boxes as explained above, or if you need to specify more parameter for the connection, you can enter the driver specific connection string. The connection string is a 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">PostgreSQL 13</link> connection string. Not every pair is handled by the %PRODUCTNAME driver manager.</paragraph>
</section>
</body>
</helpdocument>
|
