The pg_hba.conf file
http://www.postgresql.org/docs/8.2/static/auth-pg-hba-conf.html
http://www.postgresql.org/docs/8.2/static/auth-pg-hba-conf.html
PostgreSQL
PostgreSQL is an object-relational database system that has
the features of traditional commercial database systems with
enhancements to be found in next-generation DBMS systems.
To install PostgreSQL, run the following command in the
command prompt:
sudo apt-get install postgresql
Once the installation is complete, you should configure the
PostgreSQL server based on your needs, although the default
configuration is viable.
By default, connection via TCP/IP is disabled.
PostgreSQL supports multiple client authentication methods.
By default, IDENT authentication method is used for postgres and local users.
Please refer
the PostgreSQL Administrator’s Guide.
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
/etc/postgresql/<version>/main
directory. For example, if you install PostgreSQL 8.3, the
configuration files are stored in the
/etc/postgresql/8.3/main directory.
![]() |
|
| To configure ident authentication, add entries to the /etc/postgresql/8.3/main/pg_ident.conffile. |
To enable TCP/IP connections, edit the file /etc/postgresql/8.3/main/postgresql.conf
Locate the line #listen_addresses = ‘localhost’ and change it to:
listen_addresses = 'localhost'
![]() |
|
| To allow other computers to connect to your PostgreSQL server replace ‘localhost’ with the IP Address of your server. |
You may also edit all other parameters, if you know what you are doing!
For details, refer to the configuration file or to the PostgreSQL documentation.
Now that we can connect to our PostgreSQL server, the next step is to
set a password for the postgres user. Run the following command at a terminal
prompt to connect to the default PostgreSQL template database:
sudo -u postgres psql template1
The above command connects to PostgreSQL database template1 as user
postgres. Once you connect to the PostgreSQL server, you will be
at a SQL prompt. You can run the following SQL command at the psql
prompt to configure the password for the user postgres.
ALTER USER postgres with encrypted password 'your_password';
After configuring the password, edit the file
/etc/postgresql/8.3/main/pg_hba.conf to use
MD5 authentication with the postgres user:
local all postgres md5 sameuser
Finally, you should restart the PostgreSQL service to
initialize the new configuration. From a terminal prompt enter the following to
restart PostgreSQL:
sudo /etc/init.d/postgresql-8.3 restart
![]() |
|
| The above configuration is not complete by any means. Please refer the PostgreSQL Administrator’s Guide to configure more parameters. |
sudo apt-get install postgresql-doc-8.3
To view the guide enter file:///usr/share/doc/postgresql-doc-8.3/html/index.html into the address
bar of your browser.

connect to remote database:
USE:
psql -h <host> -p <port> -u <database>
psql -h <host> -p <port> -U <username> -W <password> <database>
For example:
psql -h localhost -p 5432 -U webuser dbs_cosi
1. sudo /etc/init.d/apache2 start
HOME: /var/www
2. sudo /etc/apache2/bin/apachectl -k start
HOME: /etc/apache2/htdocs
sudo apt-get install php5
sudo /etc/init.d/apache2 restart
sudo gedit /var/www/testphp.php
2. launch ‘fedora client’
C:Fedoraclientbinfedora-admin.bat
username: fedoraAdmin
simple password
3. Ingest demo data
C:Fedoraclientbin>fedora-ingest-demos.bat localhost 8080 fedoraAdmin 123xxx http
4. view objects online
http://localhost:8080/fedora/get/demo:5
2. Prof. Chris Johnson
http://www.cs.utah.edu/~crj/
Seg3D
BioMesh3D
ImageVis3D
3. Prof. Gary Egan
http://www.florey.edu.au/about/management-and-staff/scientific-staff/gary-egan/