Postgresql


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

# 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
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.

Creating a database

The example here is for postbooks


Top Page wiki Index

Disclaimer

This 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

(C) Copyright 1994-2017, Transtronics, Inc. All rights reserved
TranstronicsĀ® is a registered trademark of Transtronics, Inc.
All trademarks are the property of their respective owners.