Can't call method "prepare" on an undefined value at ./pg_table_recovery.pl line 118.

[th0mcat]

When running the script, I get the error Can't call method "prepare" on an undefined value at ./pg_table_recovery.pl line 118.. I have pulled the script down and filled in the variables several times, still nothing.

OS: Ubuntu 22.04
DB container: postgres:12.1-alpine
Perl version: v5.34.0 built for x86_64-linux-gnu-thread-multi

$dbname = "<db>"; 
$username = "<user>";
$password = "<pw>";
$dbhost = "<docker_container_ip>";
$dbport = "5432";
$dboptions = "-e";
$dbtty = "ansi";

$table = "<table>";
$tableid = "id";
$write = 0;
$verbose = 1; 

[xyhtac]

Hi, do you have any issues with linking Perl:DBI or creating the object:

$dbh = DBI->connect("dbi:Pg:dbname=$dbname;host=$dbhost;port=$dbport;options=$dboptions;tty=$dbtty","$username","$password",
            {PrintError => 0});

also make sure that you have installed Perl:DBI before launching the script:

> sudo apt-get install libdbi-perl