Import PGDUMP failing with storage scheme error

#1

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: “”

#2

Hi,

are you using the nodelocal syntax?

See this.

Thanks,
Matt

#3

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
#4

Thanks Matt,

I found out the same already:

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

Regards,
Ignacio

#5

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

Thanks,
Matt

#6

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 …

#7

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