The following information may have errors; It is not permissible to be read by anyone who has ever met a lawyer. Use is confined to Engineers with more than 370 course hours of electronic engineering for theoretical studies.

ph +1(785) 841 3089 Email inform@xtronics.com

From Transwiki

[edit] set main password

Default user is postgres with no password other than being the postgresql user, so we need to set it up:

su - postgres  ; become the postgresql user
createuser -DRS root ; Create a root user and others you might need.
psql template1 ; mess with the template1 database - enter postgresql shell

ALTER USER postgres PASSWORD 'CHANGE'; where CHANGE is your new password
ALTER USER root PASSWORD 'CHANGE'; Change other users
\q ; exit the postgresql shell
exit ; stop being postgresql user

• The install should really setup a password - this is kludgey

• In the /etc/postgresql/8.4/main/pg_hba.conf you will need to add a line similar to:

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD 
host    all         postgres    192.168.1.1/24        md5  ; where you list a user name and your LAN address

• In /etc/postgresql/8.4/main/postgresql.conf you need to change the listen_addresses

listen_addresses = '*'     ; listen to all addresses

listen_address won't take network notation instead:

The value takes the form of a comma-separated list of host names and/or numeric IP addresses.

[edit] Creating a database

The example here is for postbooks