User Tools
linux:postgresql_9_4
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
linux:postgresql_9_4 [2017/03/28 23:19] admin created |
linux:postgresql_9_4 [2017/03/28 23:22] (current) admin |
||
|---|---|---|---|
| Line 19: | Line 19: | ||
| * pgadmin3 - PostgreSQL administration GUI. | * pgadmin3 - PostgreSQL administration GUI. | ||
| * phppgadmin - PostgreSQL web-based administration tool. | * phppgadmin - PostgreSQL web-based administration tool. | ||
| - | * | + | |
| Please note that the procedural languages are installed separately (plpgsql comes by default). Perform search packaging database to find the list of possibilities: | Please note that the procedural languages are installed separately (plpgsql comes by default). Perform search packaging database to find the list of possibilities: | ||
| Line 76: | Line 76: | ||
| If you get errors like: | If you get errors like: | ||
| + | <code bash> | ||
| psql: FATAL: Ident authentication failed for user "mypguser" | psql: FATAL: Ident authentication failed for user "mypguser" | ||
| + | </code> | ||
| + | |||
| edit pg_hba.conf in /etc/postgresql/X.Y/main/pg_hba.conf | edit pg_hba.conf in /etc/postgresql/X.Y/main/pg_hba.conf | ||
| - | + | <code bash> | |
| - | local all all trust # replace ident or peer with trust | + | local all all trust # replace ident or peer with trust |
| + | </code> | ||
| reload postgresql | reload postgresql | ||
| + | <code bash> | ||
| # /etc/init.d/postgresql reload | # /etc/init.d/postgresql reload | ||
| - | Documentation | + | </code> |
| + | |||
| + | ===== Documentation ===== | ||
| To get an overview about Debian's PostgreSQL architecture, instructions for a quick start, and pointers to the programs and manpages, have a look at /usr/share/doc/postgresql-common/README.Debian.gz. | To get an overview about Debian's PostgreSQL architecture, instructions for a quick start, and pointers to the programs and manpages, have a look at /usr/share/doc/postgresql-common/README.Debian.gz. | ||
| - | Tutorial files | + | ===== Tutorial files ===== |
| PostgreSQL documentation points to tutorial, which is included in postgresql-doc package. To get more information look at /usr/share/doc/postgresql-doc-[version]/tutorial/README. | PostgreSQL documentation points to tutorial, which is included in postgresql-doc package. To get more information look at /usr/share/doc/postgresql-doc-[version]/tutorial/README. | ||
| - | Listing existing database clusters | + | ===== Listing existing database clusters ===== |
| Use pg_lsclusters command to check installed clusters and obtain some basic information such as: version (major version), name, port, status (online or down), owner, data directory and log file. | Use pg_lsclusters command to check installed clusters and obtain some basic information such as: version (major version), name, port, status (online or down), owner, data directory and log file. | ||
| + | <code bash> | ||
| pg_lsclusters | pg_lsclusters | ||
| + | </code> | ||
linux/postgresql_9_4.1490735953.txt.gz · Last modified: 2017/03/28 23:19 by admin
Page Tools
