2009-04-20 #1

netflow=# select * from pg_user;
 usename  | usesysid | usecreatedb | usesuper | usecatupd |  passwd  | valuntil | useconfig
----------+----------+-------------+----------+-----------+----------+----------+-----------
 postgres |       10 | t           | t        | t         | ******** |          |
 netflow  |    16385 | f           | f        | f         | ******** |          |

$ createdb -O netflow netflow
CREATE DATABASE

$ psql netflow
Welcome to psql 8.1.11, the PostgreSQL interactive terminal.
Type:  copyright for distribution terms
       h for help with SQL commands
       ? for help with psql commands
       g or terminate with semicolon to execute query
       q to quit
netflow=# alter user netflow with password 'newpassword';
ALTER ROLE
netflow=# q
$

# IPv4 local connections:
host    all         all         127.0.0.1/32          ident sameuser

# IPv4 local connections:
host    all         all         127.0.0.1/32          md5

postgres=# create table inettest (a inet); 
CREATE TABLE 
postgres=# insert into inettest values 
('192.168.0.1'),('192.168.1.1'),('10.0.0.1'); 
INSERT 0 3

select srcip from flows where '72.1.205.128/25' >> srcip ;
    srcip
--------------
 72.1.205.210
 72.1.205.210
 72.1.205.210
 72.1.205.173
 72.1.205.247
 72.1.205.181
 72.1.205.247
[...]