Import PGDUMP failing with storage scheme error

PgDump taken for the full database without any changes

Before proceeding with the import creating the target database and connecting to it.

create database zabbixp;
use zabbixp;

Error:
root@****/zabbixp> IMPORT PGDUMP ‘/cockroach-data/extern/zabbixp_dump.sql’;
pq: unsupported storage scheme: “”

Hi,

are you using the nodelocal syntax?

See this.

Thanks,
Matt

You need to run the following and make sure the local file is in a folder called extern on every nodes store.

Example:

import pgdump 'nodelocal:///zabbixp_dump.sql';
1 Like

Thanks Matt,

I found out the same already:

IMPORT TABLE history FROM PGDUMP ‘nodelocal:/history_dump.sql’;

Regards,
Ignacio

Awesome, let me know if you have any other questions.

Thanks,
Matt

Hey nice to see that I am not the only one who tried to get zabbix running on cockroachDB. Too bad that the authors of zabbix are not interested …

As of now just doing POC on CockroachDB, there was no real reason to use Zabbix, but the size of the database and the datatypes