![]() ![]() On Debian-based systems (including Ubuntu) the package that provides this module is libdbd-pg-perl:Īnd on Redhat-based systems it is perl-DBD-Pg: The DBI module itself does not have the ability to communicate with any specific DBMS: for that it is necessary to install the appropriate back-end module, which in the case of PostgreSQL is DBD::Pg. (The usual default is to allow connections from the local machine only.) Method a working installation of PostgreSQL, andįor this particular scenario, PostgreSQL must be configured to accept remote TCP connections to the database and username stated above.Valid credentials are the username ‘user’ and the password ‘xyzzy’. It accepts remote TCP connections on the usual port number (5432). Suppose that there is a database called finance hosted using PostgreSQL on a machine called db. This gives you a connection handle which is needed when calling other DBI functions. In order to use a particular database it is first necessary to connect to it. The DBI module is an abstraction mechanism by which a Perl script can interact with a database with minimal regard for which DBMS (in this case PostgreSQL) is being used to host the database. To establish a connection to a PostgreSQL database using the Perl DBI module Background Ubuntu (Hardy, Intrepid, Jaunty, Karmic, Lucid, Maverick, Natty, Precise, Trusty) ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |