I have some problem.
I want to migrate from postgresql to cockroachdb.
I have pg_dump file. but the pg_dump file can’t read in cockroachdb.
at the first, same command entered, there are syntax error.
I fixed many syntax error.
after then I encountered this error.
That dump file located in ‘/data02/cockroach-v19.1.4.linux-amd64/cockdata/extern/kmemmdb_dump.sql’.
right directory.
what cause the problem?
How can I do?
root@182.195.31.226:26257/kmemmdb> import pgdump ‘nodelocal://1/kmemmdb_dump.sql’;
pq: internal error: uncaught error: open /data02/cockroach-v19.1.4.linux-amd64/cockdata/extern/kmemmdb_dump.sql: no such file or directory
DETAIL: stack trace:
github.com/cockroachdb/cockroach/pkg/sql/distsqlpb/data.go:160: in NewError()
github.com/cockroachdb/cockroach/pkg/sql/distsqlrun/stream_encoder.go:109: in AddMetadata()
github.com/cockroachdb/cockroach/pkg/sql/distsqlrun/outbox.go:125: in addRow()
github.com/cockroachdb/cockroach/pkg/sql/distsqlrun/outbox.go:293: in mainLoop()
github.com/cockroachdb/cockroach/pkg/sql/distsqlrun/outbox.go:413: in run()
HINT: You have encountered an unexpected error inside CockroachDB.
Please check https://github.com/cockroachdb/cockroach/issues to check
whether this problem is already tracked. If you cannot find it there,
please report the error with details at:
https://github.com/cockroachdb/cockroach/issues/new/choose
If you would rather not post publicly, please contact us directly at:
support@cockroachlabs.com
The Cockroach Labs team appreciates your feedback.