Here some information from the host running postgres:
$ juju run --machine 1 "ps aux | grep post" root 864 0.0 0.0 294444 10628 ? Ssl 10:19 0:00 /var/lib/juju/tools/unit-postgresql-0/jujud unit --data-dir /var/lib/juju --unit-name postgresql/0 --debug postgres 3336 0.0 0.6 4135576 105752 ? S 10:19 0:00 /usr/lib/postgresql/9.3/bin/postgres -D /var/lib/postgresql/9.3/main -c config_file=/etc/postgresql/9.3/main/postgresql.conf postgres 3338 0.0 0.0 4137500 1664 ? Ss 10:19 0:00 postgres: checkpointer process postgres 3339 0.0 0.1 4137500 26720 ? Ss 10:19 0:00 postgres: writer process postgres 3340 0.0 0.0 4137500 1664 ? Ss 10:19 0:00 postgres: wal writer process postgres 3341 0.0 0.0 4138212 2952 ? Ss 10:19 0:00 postgres: autovacuum launcher process postgres 3342 0.0 0.0 100548 1764 ? Ss 10:19 0:00 postgres: stats collector process $ juju run --machine 1 "cat /var/log/postgresql/postgresql-9.3-main.log" 2014-08-21 16:19:57 UTC [3337]: [1-1] db=,user= LOG: database system was shut down at 2014-08-21 16:19:55 UTC 2014-08-21 16:19:57 UTC [3336]: [1-1] db=,user= LOG: database system is ready to accept connections 2014-08-21 16:19:57 UTC [3341]: [1-1] db=,user= LOG: autovacuum launcher started 2014-08-21 16:19:58 UTC [3343]: [1-1] db=[unknown],user=[unknown] LOG: incomplete startup packet
Here some information from the host running postgres:
$ juju run --machine 1 "ps aux | grep post" juju/tools/ unit-postgresql -0/jujud unit --data-dir /var/lib/juju --unit-name postgresql/0 --debug postgresql/ 9.3/bin/ postgres -D /var/lib/ postgresql/ 9.3/main -c config_ file=/etc/ postgresql/ 9.3/main/ postgresql. conf postgresql/ postgresql- 9.3-main. log" ,user=[ unknown] LOG: incomplete startup packet
root 864 0.0 0.0 294444 10628 ? Ssl 10:19 0:00 /var/lib/
postgres 3336 0.0 0.6 4135576 105752 ? S 10:19 0:00 /usr/lib/
postgres 3338 0.0 0.0 4137500 1664 ? Ss 10:19 0:00 postgres: checkpointer process
postgres 3339 0.0 0.1 4137500 26720 ? Ss 10:19 0:00 postgres: writer process
postgres 3340 0.0 0.0 4137500 1664 ? Ss 10:19 0:00 postgres: wal writer process
postgres 3341 0.0 0.0 4138212 2952 ? Ss 10:19 0:00 postgres: autovacuum launcher process
postgres 3342 0.0 0.0 100548 1764 ? Ss 10:19 0:00 postgres: stats collector process
$ juju run --machine 1 "cat /var/log/
2014-08-21 16:19:57 UTC [3337]: [1-1] db=,user= LOG: database system was shut down at 2014-08-21 16:19:55 UTC
2014-08-21 16:19:57 UTC [3336]: [1-1] db=,user= LOG: database system is ready to accept connections
2014-08-21 16:19:57 UTC [3341]: [1-1] db=,user= LOG: autovacuum launcher started
2014-08-21 16:19:58 UTC [3343]: [1-1] db=[unknown]