pg_dump error

[DirtyRacer1337]

Seems like in new pg_dog version 0.1.18 pg_dump is broken

happens with

[general]
pooler_mode = "transaction"
prepared_statements = "extended"

error

pg_dump: error: query failed: ERROR:  ERROR: 42601 zero-length delimited identifier at or near """"
pg_dump: detail: Query was: SELECT pg_catalog.set_config('search_path', '', false);

[levkk]

Thanks for reporting this! I fixed that particular error in #678, but I'm still having issues pg_dump-ing a schema, e.g.:

2025-12-14T05:54:15.790525Z TRACE pgdog::net::stream: [127.0.0.1:51060] <-- ErrorResponse {
    severity: "ERROR",
    code: "42P05",
    message: "prepared statement \"__pgdog_1\" already exists",
    detail: None,
    context: None,
    file: Some(
        "prepare.c",
    ),
    routine: Some(
        "StorePreparedStatement",
    ),
}
2025-12-14T05:54:15.790568Z ERROR pgdog::net::stream: [127.0.0.1:51060] <-- ERROR: 42P05 prepared statement "__pgdog_1" already exists
2025-12-14T05:54:15.790601Z TRACE pgdog::net::stream: 😳
2025-12-14T05:54:15.790667Z TRACE pgdog::net::stream: [127.0.0.1:51060] <-- ReadyForQuery {
    status: 'E',
}
2025-12-14T05:54:15.790703Z TRACE pgdog::net::stream: 😳
2025-12-14T05:54:15.790752Z TRACE pgdog::net::stream: [127.0.0.1:51060] <-- ErrorResponse {
    severity: "ERROR",
    code: "25P02",
    message: "current transaction is aborted, commands ignored until end of transaction block",
    detail: None,
    context: None,
    file: Some(
        "postgres.c",
    ),
    routine: Some(
        "exec_simple_query",
    ),
}
2025-12-14T05:54:15.790794Z ERROR pgdog::net::stream: [127.0.0.1:51060] <-- ERROR: 25P02 current transaction is aborted, commands ignored until end of transaction block
2025-12-14T05:54:15.790824Z TRACE pgdog::net::stream: 😳
2025-12-14T05:54:15.790844Z ERROR pgdog::backend::server: ProtocolOutOfSync got: Z, extended buffer: ProtocolState { queue: [], simulated: [], extended: false, out_of_sync: false }, state: transaction error
2025-12-14T05:54:15.790933Z TRACE pgdog::net::stream: [127.0.0.1:51060] <-- ErrorResponse {
    severity: "ERROR",
    code: "58000",
    message: "protocol is out of sync",
    detail: None,
    context: None,
    file: None,
    routine: None,
}

I'll keep this issue open until we figure all of this out.

[levkk]

Ok figured it out. We have a bug in how we rewrite PREPARE commands. We also ignored the value of the prepared_statements setting (when set to extended or lower, we still tried to handle these). I fixed the flag handling in #679, so as long as you set prepared_statements = "extended" (which is default), pg_dump should work 👍

Let me know if you're still running into this issue after #679 is merged.

[DirtyRacer1337]

yep, now working as before, thanks for quick fix