Postgres Setup

Postgres Setup (Mode 11)

Several Incredible Technologies games need a small local PostgreSQL 8.3 database to store game data: Golden Tee Live (2006–2019), Power Putt Live (2012/2013), Silver Strike Bowling Live, Target Toss Pro (Bags / Lawn Darts), and Orange County Choppers Pinball.

Mode 11 detects which of your registered games need this automatically — no hardcoded list to keep up to date, so a newly added game is covered the moment you register it. If none of your registered games need it, mode 11 says so and exits immediately without installing anything.

---

What mode 11 does

If PostgreSQL isn't installed yet, the script downloads and installs PostgreSQL 8.3 silently. This is the only feature in this script that requires running as Administrator, since it creates a real Windows service and a local postgres Windows user account. You'll be asked for two passwords:

1. A SERVICE ACCOUNT password — for the Windows account that runs PostgreSQL in the background. You'll almost never need it again.
2. A DATABASE password — the important one. It's saved (encrypted) so every Postgres game can be configured automatically, and you'll need it again if you ever connect with pgAdmin yourself.

If PostgreSQL is already installed, it is never reinstalled or modified — the script just uses it as-is.

For each Postgres-needing game:

• A database that already exists is never recreated or restored over.
• A Pass field that's already filled in is never overwritten — you may have already configured it correctly, by hand or on an earlier run.
• If the game's profile already has TeknoParrot's own "Automatically create Database" feature (Golden Tee Live 2018 and newer), the script only fills in the connection fields (address, port, username) — TeknoParrot creates the database itself and asks for the backup location on first launch.
• For older profiles that predate that feature, the script creates the database and restores that game's own bundled backup itself — found automatically inside that game's pg_backup folder (the newest dated subfolder, or the highest-numbered file, matching how the game ships its own backups).

Every time mode 11 runs, it backs up every existing Postgres database first, before touching anything. Restore them via Restore Backup if anything looks wrong.

---

Password storage

The database password is encrypted using Windows DPAPI (tied to your Windows account and this PC) before being saved to TeknoParrot-Manager.config.json — the first secret this script has ever needed to store. The service account password is never saved at all, encrypted or not; it's only needed once, during install.

---

Where this comes from

This automates the manual setup process documented at Eggmansworld/tp-it-guides, including the real PostgreSQL 8.3 installer (bundled in that repo's release ZIP). If you'd rather not automate this, that guide covers doing it entirely by hand via pgAdmin III.

A note on trust: the installer itself is not Authenticode-signed, so the script records SHA256/source audit information for every download but cannot independently verify publisher authenticity the way it does for ReShade (whose installer genuinely is signed). This is a limitation of the installer itself, not something a stronger check in this script could fix.

---

Health check coverage

Mode 10 (Library health check) reports, read-only, whether the PostgreSQL service is installed/running and how many registered games still need a database password configured — without installing or changing anything.