使用Psycopg3复制跨服务器的表格

Question

I'm working from and example in the psycopg3 documentation to copy a table from one database to another:

dsn_src = 'postgresql:///dev_db'
dsn_tgt = 'postgresql:///prod_test'

with psycopg.connect(dsn_src) as conn1, psycopg.connect(dsn_tgt) as conn2:
    with conn1.cursor().copy("COPY sample TO STDOUT (FORMAT BINARY)") as copy1:
        with conn2.cursor().copy("COPY sample FROM STDIN (FORMAT BINARY)") as copy2:
            for data in copy1:
                copy2.write(data)

在以下错误中运行此错误

QueryCanceled: COPY from stdin failed: error from Python: TypeError - can't write memoryview
CONTEXT:  COPY sample, line 1

，源和目标架构是相同的，如文档所建议，如果格式规范（格式二进制）被删除。

是否有解决此 MemoryView 错误的方法？

Answer 1

猜测您正在使用 psycopg3 ＆lt; = 3.0.11。将其固定在3.0.12 per 发行说明。我以3.0.11运行代码，如您所示，它失败了。我升级到3.0.13，它起作用了。