Hello,
This is my first submission to this site, so apologies if I'm going about this the wrong way and please do let me know the preferred way.
My work has a PostgreSQL server that I connect to from my development desktop computer via Perl scripts and PgAdmin 4. This development computer is a 64-bit Windows 10 CPU.
I installed Strawberry Perl in 2015 and then the necessary CPAN modules needed for my various apps.
I have upgraded Strawberry perl and the CPAN modules on a regular basis since 2015. I have never had PostgreSQL installed on my development computer. Nor have I ever set the DBI_* environment variables. The CPAN install of DBD::Pg always worked seamlessly until last week when I began getting a 'initdb' error. Here are the specifics:
# DBI Version 1.643
# DBD::Pg Version 3.15.1
# Perl Version 5.30.2
# OS MSWin32
# PostgreSQL (compiled) ?
# PostgreSQL (target) ?
# PostgreSQL (reported) ?
# Default port ?
# DBI_DSN dbi:Pg:dbname=db_xyz_appname
# DBI_USER fte_MyName
# Test schema dbd_pg_testschema
# LANG C
# Adjusted: initdb
# Error was: Bad initdb output: 'initdb' is not recognized as an internal or external command,
# operable program or batch file.
Is there a reason the 'initdb' error is appearing now after nearly 7 years? Do I need to install PostgreSQL on my development computer just to get past this error? Thinking that there may be a bug in the current version of Strawberry Perl or the CPAN modules, I installed a prior version of them all and am still getting the 'initdb' error.
Many thanks in advance for any information about this issue.
Brian