admin@xxx:~/>: psql -p 5555 -U viewuser mcdb

mcdb=>

 

Example query:

    SELECT * FROM "public"."v_clients";

    SELECT v_clients.cid, v_clients.client_name, v_clients.client_addr,v_clients.os_type FROM "public"."v_clients";

 

     select client_name,status_code,domain FROM v_activities_2 WHERE (status_code=30901 or status_code=30915) and recorded_date_time > current_timestamp - interval '24 hours'

When running pre/post scripts, it is possible that you are getting the following error message:

2017-03-20 19:43:43 avtar Info <5916>: Executing run-at-start '/usr/local/avamar/etc/scripts/test.sh'
2017-03-20 19:43:43 avtar Info <6033>: Begin STDERR from run-at-start:
avspawn::spawn after execve errno:8 code 8: Exec format error

 

In order to resolve that, ensure that you specified the interpreter as first line.
So it should start with, for example:

 #!/bin/sh

 

Who is Online

We have 47 guests and no members online