paperclipai/paperclip · error

psql did not expose stdin

Error message

psql did not expose stdin

What it means

Error "psql did not expose stdin" thrown in paperclipai/paperclip.

Source

Thrown at packages/db/src/backup-lib.ts:375

  const child = spawn(
    psqlBin,
    [
      `--dbname=${opts.connectionString}`,
      "--set=ON_ERROR_STOP=1",
      "--quiet",
      "--no-psqlrc",
    ],
    {
      stdio: ["pipe", "ignore", "pipe"],
      env: {
        ...process.env,
        PGCONNECT_TIMEOUT: String(connectTimeout),
      },
    },
  );

  if (!child.stdin) {
    throw new Error("psql did not expose stdin");
  }

  const input = opts.backupFile.endsWith(".gz")
    ? createReadStream(opts.backupFile).pipe(createGunzip())
    : createReadStream(opts.backupFile);

  await Promise.all([
    pipeline(input, child.stdin),
    waitForChildExit(child, psqlBin),
  ]);
}

async function hasStatementBreakpoints(backupFile: string): Promise<boolean> {
  const raw = createReadStream(backupFile);
  const stream = backupFile.endsWith(".gz") ? raw.pipe(createGunzip()) : raw;
  let text = "";

  try {

View on GitHub (pinned to 120ae5428f)

Solutions

1. Check psql installation and retry; stdin pipe was unavailable.
2. Verify spawn stdio configuration for psql.

When it happens

Trigger: Thrown at packages/db/src/backup-lib.ts:375 when the library encounters an invalid state.

Common situations: See trigger scenarios.

AI-assisted analysis of paperclipai/paperclip@120ae5428f (2026-08-18). Data as JSON: /api/errors/3fa47759781d2054. Report an issue: GitHub.