大佬教程收集整理的这篇文章主要介绍了【Centos】Postgresql连接测试(Perl和Ruby),大佬教程大佬觉得挺不错的,现在分享给大家,也给大家做个参考。
Centos安装了POSTGResql之后,将考虑如何让Perl与Ruby连接它。
1,安装Perl的数据库连接包
yum install perl-DBI.x86_64 perl-DBD-Pg.x86_64
2,连接测试
vi testPerl.pl #!/usr/bin/perl use DBI; # POSTGResql our $db_name = "testDB"; our $DB_USER = "test"; our $DB_PASS = "Admin"; our $DB_HOST = "198.192.69.1"; our $DB_PORT = "5432"; my $dbh = DBI->connect("dbi:Pg:dbname=$db_name;host=$DB_HOST","$DB_USER","$DB_PASS") or die "$!\n Error: Failed to connect to DB.\n"; my $sth = $dbh->prepare("SELECT Now();"); $sth->execute(); while (my $ary_ref = $sth->fetchrow_arrayref) { my ($row) = @$ary_ref; print $row,"\n"; } $sth->finish; $dbh->disconnect; 1;
成功的场合就会显示时间数据。
1,安装Ruby的数据库连接包
pg-0.18.4.gem
下载地址:https://rubygems.org/gems/pg/versions/0.18.4
/usr/sbin/td-agent-gem install pg-0.18.4.gem Building native extensions. This Could take a while... successfully installed pg-0.18.4 Parsing documentation for pg-0.18.4 Installing ri documentation for pg-0.18.4 Done installing documentation for pg after 2 seconds WARNING: Unable to pull data from ‘https://rubygems.org/‘: Errno::ENETUNREACH: Network is unreachable - connect(2) for "api.rubygems.org" port 443 (https://api.rubygems.org/specs.4.8.gz) 1 gem installed
2,连接测试
vi test.rb require ‘pg‘ connect = PG::connect(host:"198.192.69.1",user:"test",password:"Admin",dbname:"testDB",port:"5432") results = connect.exec("SELEct current_date hoge") results.each{|result| p result["hoge"] } connect.finish
#修改执行权限 chmod 777 test.rb #执行测试 /opt/td-agent/embedded/bin/ruby test.rb 2018/8/31
成功的场合就会显示时间数据。
以上是大佬教程为你收集整理的【Centos】Postgresql连接测试(Perl和Ruby)全部内容,希望文章能够帮你解决【Centos】Postgresql连接测试(Perl和Ruby)所遇到的程序开发问题。
如果觉得大佬教程网站内容还不错,欢迎将大佬教程推荐给程序员好友。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。