|
|
1847.
|
|
|
You can edit the <filename>/etc/mysql/my.cnf</filename> file to configure the basic settings -- log file, port number, etc. For example, to configure <application>MySQL</application> to listen for connections from network hosts, change the <emphasis>bind_address</emphasis> directive to the server's IP address:
|
|
|
|
|
(no translation yet)
|
|
Translated and reviewed by
Peter Mráz
|
|
|
|
|
1860.
|
|
|
By default, connection via TCP/IP is disabled. PostgreSQL supports multiple client authentication methods. By default, IDENT authentication method is used for <application>postgres</application> and local users. Please refer <ulink url="http://www.postgresql.org/docs/8.3/static/admin.html"> the PostgreSQL Administrator's Guide</ulink>.
|
|
|
|
|
(no translation yet)
|
|
Translated and reviewed by
Peter Mráz
|
|
|
|
|
1861.
|
|
|
The following discussion assumes that you wish to enable TCP/IP connections and use the MD5 method for client authentication. PostgreSQL configuration files are stored in the <filename>/etc/postgresql/<version>/main</filename> directory. For example, if you install PostgreSQL 8.3, the configuration files are stored in the <filename>/etc/postgresql/8.3/main</filename> directory.
|
|
|
|
|
(no translation yet)
|
|
Translated and reviewed by
Peter Mráz
|
|
|
|
|
1862.
|
|
|
To configure <emphasis>ident</emphasis> authentication, add entries to the <filename>/etc/postgresql/8.3/main/pg_ident.conf</filename> file.
|
|
|
|
|
(no translation yet)
|
|
Translated and reviewed by
Peter Mráz
|
|
|
|
|
1863.
|
|
|
To enable TCP/IP connections, edit the file <filename>/etc/postgresql/8.3/main/postgresql.conf</filename>
|
|
|
|
|
(no translation yet)
|
|
Translated and reviewed by
Peter Mráz
|
|
|
|
|
1872.
|
|
|
After configuring the password, edit the file <filename>/etc/postgresql/8.3/main/pg_hba.conf</filename> to use <emphasis>MD5</emphasis> authentication with the <emphasis>postgres</emphasis> user:
|
|
|
|
|
(no translation yet)
|
|
Translated and reviewed by
Peter Mráz
|
|
|
|
|
1873.
|
|
|
local all postgres md5 sameuser
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
|
(no translation yet)
|
|
Translated and reviewed by
Peter Mráz
|
|
|
|
|
1875.
|
|
|
sudo /etc/init.d/postgresql-8.3 restart
|
|
|
|
|
(no translation yet)
|
|
Translated and reviewed by
Peter Mráz
|
|
|
|
|
1876.
|
|
|
The above configuration is not complete by any means. Please refer <ulink url="http://www.postgresql.org/docs/8.3/static/admin.html"> the PostgreSQL Administrator's Guide</ulink> to configure more parameters.
|
|
|
|
|
(no translation yet)
|
|
Translated and reviewed by
Peter Mráz
|
|
|
|
|
1877.
|
|
|
As mentioned above the <ulink url="http://www.postgresql.org/docs/8.3/static/admin.html">Administrator's Guide</ulink> is an excellent resource. The guide is also available in the <application>postgresql-doc-8.3</application> package. Execute the following in a terminal to install the package:
|
|
|
|
|
(no translation yet)
|
|
Translated and reviewed by
Peter Mráz
|
|
|
