In the original code the sub routine using %actionsw does work (just dropped sequence and reran a few times)

DB creation

DB create line (in psql)

sudo su postgres

/usr/pgsql-11/bin/psql template1

CREATE USER usevideo blah etc;

CREATE DATABASE usevideos WITH OWNER = usevideo ENCODING = 'UTF8' LC_COLLATE = 'en_GB.UTF-8' LC_CTYPE = 'en_GB.UTF-8' TABLESPACE = pg_default CONNECTION LIMIT = -1;

The db connection line is

use DBI qw(:sql_types); my $dbh=DBI->connect('dbi:Pg:dbname=usevideos;host=192.168.1.3','dbuser','dbpass',{AutoCommit=>1,RaiseError=>1,PrintError=>0});