Pg for Windows: need help!
"Сергей Хомицкий" <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.dbdpg |
|---|---|
| Message-ID | <[email protected]> |
Hi. Help me, please with Pg for Windows:
1. WinXP SP2
2. Perl:
This is perl, v5.8.8 built for MSWin32-x86-multi-thread
(with 33 registered patches, see perl -V for more detail)
Copyright 1987-2006, Larry Wall
Binary build 819 [267479] provided by ActiveState http://www.ActiveState.com
Built Aug 29 2006 12:42:41
Perl may be copied only under the terms of either the Artistic License or the
GNU General Public License, which may be found in the Perl 5 source kit.
Complete documentation for Perl, including FAQ lists, should be found on
this system using "man perl" or "perldoc perl". If you have access to the
Internet, point your browser at http://www.perl.org/, the Perl Home Page.
3. PostgreSQL:
postgres (PostgreSQL) 8.2.1
4. Pg install as:
ppm install http://dbdpgppm.projects.postgresql.org/DBD-Pg-5.8s.ppd
5. ppm list is:
C:\>ppm list
┌──────────────────────────┬────────────┬───────┬──────────┬──────┐
│ name │ version │ files │ size │ area │
├──────────────────────────┼────────────┼───────┼──────────┼──────┤
│ ActivePerl-Config │ 1.0 │ 2 │ 11 KB │ perl │
│ ActivePerl-DocTools │ 2.0 │ 13 │ 63 KB │ perl │
│ ActivePerl-PPM │ 4.0 │ 63 │ 545 KB │ perl │
│ ActiveState-RelocateTree │ 1.3 │ 4 │ 29 KB │ perl │
│ ActiveState-Scineplex │ 1.0 │ 6 │ 77 KB │ perl │
│ ActiveState-Utils │ 2.1 │ 21 │ 106 KB │ perl │
│ Archive-Tar │ 1.30-r1 │ 8 │ 82 KB │ perl │
│ Archive-Zip │ 1.16 │ 10 │ 154 KB │ perl │
│ Compress-Zlib │ 1.42 │ 7 │ 121 KB │ perl │
│ DBD-Pg │ 1.49 │ 10 │ 1958 KB │ site │
│ DBD-PgPP │ 0.05 │ 5 │ 61 KB │ site │
│ DBD-SQLite │ 1.12 │ 6 │ 288 KB │ perl │
│ DBD-mysql │ 3.0002 │ 15 │ 1296 KB │ site │
│ DBI │ 1.52 │ 44 │ 1179 KB │ perl │
│ Data-Dump │ 1.06 │ 2 │ 14 KB │ perl │
│ Digest-HMAC │ 1.01 │ 4 │ 5 KB │ perl │
│ Digest-MD2 │ 2.03 │ 6 │ 29 KB │ perl │
│ Digest-MD4 │ 1.5-r1 │ 6 │ 38 KB │ perl │
│ Digest-SHA1 │ 2.11 │ 6 │ 38 KB │ perl │
│ File-CounterFile │ 1.04 │ 2 │ 6 KB │ perl │
│ Font-AFM │ 1.19 │ 14 │ 38 KB │ perl │
│ GD │ 2.35 │ 20 │ 1181 KB │ site │
│ HTML-Parser │ 3.55 │ 12 │ 129 KB │ perl │
│ HTML-Tagset │ 3.10 │ 2 │ 13 KB │ perl │
│ HTML-Tree │ 3.20 │ 10 │ 314 KB │ perl │
│ IO-String │ 1.08 │ 2 │ 12 KB │ perl │
│ IO-Zlib │ 1.04 │ 2 │ 16 KB │ perl │
│ LWP │ 5.805-r1 │ 69 │ 657 KB │ perl │
│ MD5 │ 2.03 │ 2 │ 1 KB │ perl │
│ MIME-Base64-Scripts │ 1.00 │ 9 │ 3 KB │ perl │
│ Math-BigInt-FastCalc │ 0.10 │ 6 │ 31 KB │ perl │
│ Perl │ 5.8.8.819 │ 1529 │ 24138 KB │ perl │
│ SOAP-Lite │ 0.55-r1 │ 29 │ 332 KB │ perl │
│ Tcl │ 0.89-r2 │ 8 │ 2371 KB │ perl │
│ Term-ReadKey │ 2.30 │ 7 │ 48 KB │ perl │
│ Term-ReadLine-Perl │ 1.0302-r1 │ 3 │ 139 KB │ perl │
│ Text-Autoformat │ 1.13 │ 2 │ 43 KB │ perl │
│ Text-Reform │ 1.11 │ 7 │ 60 KB │ perl │
│ Tk │ 804.027-r6 │ 693 │ 5988 KB │ perl │
│ Tkx │ 1.04 │ 9 │ 68 KB │ perl │
│ URI │ 1.35 │ 50 │ 116 KB │ perl │
│ Unicode-String │ 2.09 │ 7 │ 601 KB │ perl │
│ Win32-AuthenticateUser │ 0.02 │ 7 │ 26 KB │ perl │
│ XML-Parser │ 2.34-r1 │ 32 │ 483 KB │ perl │
│ XML-Simple │ 2.14 │ 3 │ 111 KB │ perl │
│ libwin32 │ 0.26-r3 │ 154 │ 2180 KB │ perl │
└──────────────────────────┴────────────┴───────┴──────────┴──────┘
(46 packages installed)
6. DBI drivers is:
install_driver(CX) failed: Can't locate DBD/CX.pm in @INC (@INC contains: D:/USR/site/lib D:/USR/lib .) at (eval 5) line 3.
Perhaps the DBD::CX perl module hasn't been fully installed,
or perhaps the capitalisation of 'CX' isn't right.
Available drivers: DBM, ExampleP, File, Pg, PgPP, Proxy, SQLite, Sponge, mysql.
=================
SO, when I start testing script, I see next:
Software error:
install_driver(Pg) failed: Can't load 'D:/USR/site/lib/auto/DBD/Pg/Pg.dll' for module DBD::Pg: load_file:Не найден указанный модуль at D:/USR/lib/DynaLoader.pm line 230.
at (eval 5) line 3
Compilation failed in require at (eval 5) line 3.
Perhaps a required shared library or dll isn't installed where expected
But file "D:/USR/site/lib/auto/DBD/Pg/Pg.dll" EXIST:
D:\USR\site\lib\auto\DBD\Pg>dir
Том в устройстве D имеет метку DATA
Серийный номер тома: 4CEF-E6FC
Содержимое папки D:\USR\site\lib\auto\DBD\Pg
16.02.2008 12:39 <DIR> .
16.02.2008 12:39 <DIR> ..
16.02.2008 12:39 324 .packlist
16.02.2008 12:39 1В 036В 288 libeay32.dll
16.02.2008 12:39 0 Pg.bs
16.02.2008 12:39 159В 744 Pg.dll
16.02.2008 12:39 752 Pg.exp
16.02.2008 12:39 1В 854 Pg.lib
16.02.2008 12:39 371В 712 Pg.pdb
16.02.2008 12:39 196В 608 ssleay32.dll
8 файлов 1 767 282 байт
2 папок 19 979 456 512 байт свободно
What can I do to work with PostgreSQL via Perl? DBD:PgPP have so much errors!
Now I use MySQL - no problems! But I want use PostgreSQL, as I use at my work (with FreeBSD).
Help me with this bugs, pls.!
Thank's and regardes,
Serge Khomitsky