http://10.3.0.100/tutorials/index.php?action=history&feed=atom&title=PostgreSQL_Verbindungsparameter
PostgreSQL Verbindungsparameter - Versionsgeschichte
2026-04-10T23:10:51Z
Versionsgeschichte dieser Seite in Tutorials
MediaWiki 1.39.1
http://10.3.0.100/tutorials/index.php?title=PostgreSQL_Verbindungsparameter&diff=5928&oldid=prev
Martin Kirner: /* mittels alias */
2019-06-20T11:33:38Z
<p><span dir="auto"><span class="autocomment">mittels alias</span></span></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="de">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Nächstältere Version</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Version vom 20. Juni 2019, 11:33 Uhr</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l37">Zeile 37:</td>
<td colspan="2" class="diff-lineno">Zeile 37:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[https://www.postgresql.org/docs/current/libpq-envars.html https://www.postgresql.org/docs/current/libpq-envars.html]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[https://www.postgresql.org/docs/current/libpq-envars.html https://www.postgresql.org/docs/current/libpq-envars.html]</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>== mittels alias ==</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>== mittels <ins style="font-weight: bold; text-decoration: none;">'</ins>alias<ins style="font-weight: bold; text-decoration: none;">' </ins>==</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Die Datei <code>~/.bashrc</code> editieren </div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Die Datei <code>~/.bashrc</code> editieren </div></td></tr>
<tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l58">Zeile 58:</td>
<td colspan="2" class="diff-lineno">Zeile 58:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Zurück zu [[PostgreSQL#Verbindungsparameter|<del style="font-weight: bold; text-decoration: none;">Verbindungsparameter</del>]]</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Zurück zu [[PostgreSQL#Verbindungsparameter|<ins style="font-weight: bold; text-decoration: none;">PostgreSQL</ins>]]</div></td></tr>
</table>
Martin Kirner
http://10.3.0.100/tutorials/index.php?title=PostgreSQL_Verbindungsparameter&diff=5926&oldid=prev
Martin Kirner: Die Seite wurde neu angelegt: „== Passwortdatei == <pre> vi ~/.pgpass </pre> <pre> YOUR_HOST:YOUR_PORT:DB_NAME:USER_NAME:PASSWORD </pre> <pre> chmod 600 ~/.pgpass </pre> <pre> vi ~/.bash…“
2019-06-20T11:32:11Z
<p>Die Seite wurde neu angelegt: „== Passwortdatei == <pre> vi ~/.pgpass </pre> <pre> YOUR_HOST:YOUR_PORT:DB_NAME:USER_NAME:PASSWORD </pre> <pre> chmod 600 ~/.pgpass </pre> <pre> vi ~/.bash…“</p>
<p><b>Neue Seite</b></p><div>== Passwortdatei ==<br />
<br />
<pre><br />
vi ~/.pgpass<br />
</pre><br />
<br />
<pre><br />
YOUR_HOST:YOUR_PORT:DB_NAME:USER_NAME:PASSWORD<br />
</pre><br />
<br />
<pre><br />
chmod 600 ~/.pgpass<br />
</pre><br />
<br />
<pre><br />
vi ~/.bashrc<br />
</pre><br />
<br />
=== Links ===<br />
<br />
[https://www.postgresql.org/docs/current/libpq-pgpass.html https://www.postgresql.org/docs/current/libpq-pgpass.html]<br />
<br />
== Umgebungsvariablen ==<br />
<br />
* <ip address>=127.0.0.1 für localhost<br />
* PGPASSFILE ist hier eigentlich nicht notwendig, da '/home/<username>/.pgpass' der Standardpfad ist<br />
<br />
<pre><br />
export PGHOSTADDR=<ip address><br />
export PGUSER=<postgres user><br />
export PGDATABASE=<database name><br />
export PGPASSFILE=/home/<username>/.pgpass<br />
</pre><br />
<br />
=== Links ===<br />
<br />
[https://www.postgresql.org/docs/current/libpq-envars.html https://www.postgresql.org/docs/current/libpq-envars.html]<br />
<br />
== mittels alias ==<br />
<br />
Die Datei <code>~/.bashrc</code> editieren <br />
<br />
<pre><br />
vi ~/.bashrc<br />
</pre><br />
<br />
und folgende Zeile hinzufügen ''(127.0.0.1 für localhost)'':<br />
<br />
<pre><br />
alias db='psql -h <ip address> -U <postgres user> -d <database name>'<br />
</pre><br />
<br />
Danach die Datei mittels <code>source</code> neu einlesen:<br />
<br />
<pre><br />
source ~/.bashrc<br />
</pre><br />
<br />
<br />
Zurück zu [[PostgreSQL#Verbindungsparameter|Verbindungsparameter]]</div>
Martin Kirner