Function installPostgreSQL

cmd/sqlc-test-setup/main.go:174–246

()

}

func installPostgreSQL() error {
	log.Println("--- Installing PostgreSQL ---")

	// Install runtime dependencies needed by PostgreSQL extensions (e.g.
	// uuid-ossp requires libossp-uuid16).
	if err := installPgDeps(); err != nil {
		return fmt.Errorf("installing postgresql dependencies: %w", err)
	}

	// Check if already installed in our directory
	if _, err := os.Stat(pgBin("postgres")); err == nil {
		out, err := runOutput(pgBin("postgres"), "--version")
		if err == nil {
			log.Printf("postgresql is already installed: %s", strings.TrimSpace(out))
			log.Println("skipping postgresql installation")
			return nil
		}
	}

	platform := runtime.GOOS + "/" + runtime.GOARCH
	bin, ok := pgBinaries[platform]
	if !ok {
		return fmt.Errorf("unsupported platform: %s (supported: %s)", platform, supportedPlatforms())
	}

	// Download to a temp file
	tarball := filepath.Join(os.TempDir(), fmt.Sprintf("postgresql-%s.tar.gz", pgVersion))

	if _, err := os.Stat(tarball); err != nil {
		log.Printf("downloading PostgreSQL %s from %s", pgVersion, bin.URL)
		if err := downloadFile(tarball, bin.URL); err != nil {
			os.Remove(tarball)
			return fmt.Errorf("downloading postgresql: %w", err)
		}
	} else {
		log.Printf("postgresql tarball already downloaded at %s", tarball)
	}

	// Verify SHA256 checksum
	log.Printf("verifying SHA256 checksum")
	actualHash, err := sha256File(tarball)
	if err != nil {
		return fmt.Errorf("computing sha256: %w", err)
	}
	if actualHash != bin.SHA256 {
		os.Remove(tarball)
		return fmt.Errorf("SHA256 mismatch: expected %s, got %s", bin.SHA256, actualHash)
	}
	log.Printf("SHA256 checksum verified: %s", actualHash)

	baseDir := pgBaseDir()

	// Create the base directory in the user cache
	if err := os.MkdirAll(baseDir, 0o755); err != nil {
		return fmt.Errorf("creating %s: %w", baseDir, err)
	}

	// Extract the tarball - it contains a top-level directory like