PostgreSQL 9.4 – Using Postgres with Logstash and Log Filename Issues

Just a slight variation to Chris's answer:

SELECT a, translate(b, '[]', '{}')::text[] AS b, d
FROM json_to_record('{"a": 1, "b": ["hello", "There"], "c": "bar"}')
AS x(a int, b text, d text);

The idea is the same: massage the JSON array into an array - in this case, through an array literal. In addition to a bit cleaner looking code (though I love it, regex usually does not help much in this regard :), it seems slighly faster, too:

CREATE TABLE jsonb_test (
    id serial,
    data jsonb
);

INSERT INTO jsonb_test (id, data)
SELECT i, format('{"a": %s, "b": ["foo", "bar"], "c": "baz"}', i::text)::jsonb 
FROM generate_series(1,10000) t(i);

SELECT a, string_to_array(regexp_replace(b, '\[*\"*\s*\]*','','g'),',') AS b, d
FROM jsonb_test AS j, 
LATERAL json_to_record(j.data::json) AS r(a int, b text, d text);

-- versus 

SELECT a, translate(b, '[]', '{}')::text[] AS b, d
FROM jsonb_test AS j, 
LATERAL json_to_record(j.data::json) AS r(a int, b text, d text);

On this dataset and on my test box, the regex version shows and average execution time of 300 ms, while my version shows 210 ms.

First you have to note that PostgreSQL doesn't really have a concept of anonymous usage. So you do not have a way to log in without the user being added.

You have two options. The first is you can add appropriate ad users and groups manually. Or you can add them using an AD trigger (see https://superuser.com/questions/909554/trigger-an-event-when-computer-is-added-to-active-directory for a similar question, and full documentation at https://technet.microsoft.com/en-us/library/dd277403.aspx). Please note, the latter is a bit of a security concern and you need to make sure you aren't giving out access beyond what you want to give).

If you go the latter direction, you need to make sure you are restricting access to the public role.