在Mac上安装Perl DBD:PG

Question

i运行：

perl -MCPAN -e 'install Bundle::DBD::Pg'

它问：

Path to pg_config? 

我说：

/Library/PostgreSQL/9.3/bin/pg_config

它运行...最后一行是：

Test Summary Report
-------------------
t/02attribs.t     (Wstat: 256 Tests: 249 Failed: 1)
  Failed test:  23
  Non-zero exit status: 1
Files=15, Tests=1691, 29 wallclock secs ( 0.23 usr  0.05 sys +  5.29 cusr  1.65 csys =  7.22 CPU)
Result: FAIL
Failed 1/15 test programs. 1/1691 subtests failed.
make: *** [test_dynamic] Error 255
  TURNSTEP/DBD-Pg-2.19.3.tar.gz
  /usr/bin/make test -- NOT OK
//hint// to see the cpan-testers results for installing this module, try:
  reports TURNSTEP/DBD-Pg-2.19.3.tar.gz
Running make install
  make test had returned bad status, won't install without force

我看到了dbi_user config转向JGP（我的登录），我也在DB中创建了。

我应该从哪里开始的任何提示？

根据要求，这是完整的测试结果：

Running make test
PGINITDB="/Library/PostgreSQL/9.3/bin/initdb" PERL_DL_NONLAZY=1 /usr/bin/perl "-   MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00_signature.t .... skipped: Set the environment variable TEST_SIGNATURE to enable this test
t/00basic.t ......... ok   
t/01connect.t ....... Please wait, creating new database for testing
t/01connect.t ....... 1/15 # 
# DBI                         Version 1.631
# DBD::Pg                     Version 2.19.3
# Perl                        Version 5.16.2
# OS                          darwin
# PostgreSQL (compiled)       90302
# PostgreSQL (target)         90302
# PostgreSQL (reported)       PostgreSQL 9.3.2 on x86_64-apple-darwin, compiled by i686-apple-darwin11-llvm-gcc-4.2 (GCC) 4.2.1 (Based on Apple Inc. build 5658) (LLVM build 2336.9.00), 64-bit
# Default port                5432
# DBI_DSN                     dbi:Pg:db="postgres";port=5440;host=<pwd>/dbdpg_test_database/data/socket
# DBI_USER                    jgp
# Test schema                 dbd_pg_testschema
# LANG                        C
# array_nulls                 on
# backslash_quote             safe_encoding
# client_encoding             UTF8
# server_encoding             UTF8
# standard_conforming_strings on
# Adjusted:                   initdb
t/01connect.t ....... ok     
t/01constants.t ..... ok       
t/02attribs.t ....... 1/249 
#   Failed test 'DB handle attribute "PrintWarn" shows warnings when on'
#   at t/02attribs.t line 263.
#                   ''
#     doesn't match '(?^:dbd_pg_test_temp)'
    (in cleanup) DBD::Pg::st DESTROY failed: no connection to the server at t/02attribs.t line 1558.
# Looks like you failed 1 test of 249.
t/02attribs.t ....... Dubious, test returned 1 (wstat 256, 0x100)
Failed 1/249 subtests 
t/03dbmethod.t ...... ok       
t/03smethod.t ....... ok     
t/04misc.t .......... 1/70 # Checking pg_st_split_statement. This may take a while...
t/04misc.t .......... ok     
t/06bytea.t ......... ok     
t/07copy.t .......... ok     
t/08async.t ......... ok     
t/09arrays.t ........ ok       
t/12placeholders.t .. ok       
t/20savepoints.t .... ok   
t/99cleanup.t ....... 1/1 Removing test database directory
t/99cleanup.t ....... ok   

我必须承认我是Perl和Postgresql的新手。

Answer 1

看起来已经修复了，但尚未包含在新版本中。显然，" Postgres在9.3中的健谈较少"。

CPAN上有一个开发人员版本（v2.20.1_6）。安装：

cpan TURNSTEP/DBD-Pg-2.20.1_6.tar.gz

，或者您可以使用git。

Answer 2

这对我有用，我只需要回答PG_Config问题，我的答案是：/applications/postgres.app/contents/versions/9.5/bin/pg_config