看报错应该是$libdir未指定，先看下echo $libdir的输出是什么

我echo $libdir的输出空

请问正确的应该是什么位置

不执行这个语句
create extension pg_bulkload; #如果连接指定到单个库时，需要创建扩展以生成
pgbulkload.pg_bulkload() 函数
postgres-# \df pgbulkload.*
List of functions
Schema | Name | Result data type | Argument data types
| Type
------------±------------±-----------------±-------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------±-----
pgbulkload | pg_bulkload | record | options text[], OUT skip bigint, OUT count bigint, OUT parse_errors bigint, OUT duplicate_new bigint, OUT duplicate_old b
igint, OUT system_time double precision, OUT user_time double precision, OUT duration double precision | func
(1 row)
创建扩展后模式和函数就都创建了

[postgres@localhost extension]$ whereis pg_bulkload
pg_bulkload: /data/pgdb/pgsql/bin/pg_bulkload

[postgres@localhost extension]$ more /data/pgdb/pgsql/share/extension/pg_bulkload–3.1.20.sql
/*

• pg_bulkload–3.1.20.sql
• Copyright © 2007-2023, NIPPON TELEGRAPH AND TELEPHONE CORPORATION
  */

– complain if script is sourced in psql, rather than via CREATE EXTENSION
\echo Use “CREATE EXTENSION pg_bulkload” to load this file. \quit

CREATE SCHEMA pgbulkload;

– Adjust this setting to control where the objects get created.
CREATE FUNCTION pgbulkload.pg_bulkload(
IN options text[],
OUT skip bigint,
OUT count bigint,
OUT parse_errors bigint,
OUT duplicate_new bigint,
OUT duplicate_old bigint,
OUT system_time float8,
OUT user_time float8,
OUT duration float8
)
AS ’$libdir/pg_bulkload', 'pg_bulkload' LANGUAGE C VOLATILE STRICT; [postgres@localhost extension]$ echo $libdir

[postgres@localhost extension]$ whereis pg_bulkload
pg_bulkload: /data/pgdb/pgsql/bin/pg_bulkload
知道路径在哪里了吧