Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fbIJw-0004S7-Kb for pgsql-admin@arkaria.postgresql.org; Fri, 06 Jul 2018 04:26:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fbIJu-0005vo-4H for pgsql-admin@arkaria.postgresql.org; Fri, 06 Jul 2018 04:26:10 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fbI6x-0005UR-8W for pgsql-admin@lists.postgresql.org; Fri, 06 Jul 2018 04:12:47 +0000 Received: from n3.nabble.com ([162.255.23.22]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fbI6u-0004zd-EY for pgsql-admin@postgresql.org; Fri, 06 Jul 2018 04:12:46 +0000 Received: from n3.nabble.com (localhost [127.0.0.1]) by n3.nabble.com (Postfix) with ESMTP id 00150DDDA954 for ; Thu, 5 Jul 2018 21:12:41 -0700 (MST) Date: Thu, 5 Jul 2018 21:12:41 -0700 (MST) From: pavna To: pgsql-admin@postgresql.org Message-ID: <1530850361998-0.post@n3.nabble.com> Subject: pg_restore error Command was: CREATE OPERATOR ~> ( PROCEDURE = plv8x.json_eval_ls, MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk When I pg_restore I get errors. Postgres version : PostgreSQL 9.4.0 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu 4.8.2-19ubuntu1) 4.8.2, 64-bit plv8.version : 1.5.0-dev1 pg_restore: processing item 2532 OPERATOR | pg_restore: creating OPERATOR | pg_restore: processing item 2533 OPERATOR | pg_restore: creating OPERATOR | pg_restore: processing item 2536 OPERATOR |> pg_restore: creating OPERATOR |> pg_restore: processing item 2537 OPERATOR |> pg_restore: creating OPERATOR |> pg_restore: [archiver (db)] Error from TOC entry 2537; 2617 27562 OPERATOR |> employeeDB pg_restore: [archiver (db)] could not execute query: ERROR: argument of commutator must be a name Command was: CREATE OPERATOR |> ( PROCEDURE = plv8x.json_eval, LEFTARG = plv8x.json, RIGHTARG = text, COMMUTATOR = 27561 ... pg_restore: processing item 2534 OPERATOR ~ pg_restore: creating OPERATOR ~ pg_restore: processing item 2540 OPERATOR ~> pg_restore: creating OPERATOR ~> pg_restore: [archiver (db)] Error from TOC entry 2540; 2617 27566 OPERATOR ~> employeeDB pg_restore: [archiver (db)] could not execute query: ERROR: argument of commutator must be a name Command was: CREATE OPERATOR ~> ( PROCEDURE = plv8x.json_eval_ls, LEFTARG = plv8x.json, RIGHTARG = text, COMMUTATOR = 275... pg_restore: processing item 2535 OPERATOR ~~ pg_restore: creating OPERATOR ~~ pg_restore: processing item 2670 OPERATOR CLASS gist__int_ops pg_restore: creating OPERATOR CLASS gist__int_ops pg_restore: processing item 347 TABLE account_setting pg_restore: creating TABLE account_setting pg_restore: processing item 348 SEQUENCE account_setting_id_seq pg_restore: creating SEQUENCE account_setting_id_seq pg_restore: processing item 4780 SEQUENCE OWNED BY account_setting_id_seq pg_restore: creating SEQUENCE OWNED BY account_setting_id_seq -- Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html