| 1 |
PGObject-Util-DBAdmin |
| 2 |
|
| 3 |
This module provides a basic interface to command line utilities. With it |
| 4 |
you can create and drop databases, list databases, take and restore backups, |
| 5 |
and run sql files against databases. |
| 6 |
|
| 7 |
INSTALLATION |
| 8 |
|
| 9 |
To install this module, run the following commands: |
| 10 |
|
| 11 |
perl Makefile.PL |
| 12 |
make |
| 13 |
make test |
| 14 |
make install |
| 15 |
|
| 16 |
|
| 17 |
TESTING |
| 18 |
|
| 19 |
By default, tests which interact with a database are not run. To run the |
| 20 |
full test suite, set environment variable DB_TESTING=1. The database |
| 21 |
password may be set with environment variable PGPASSWORD. |
| 22 |
|
| 23 |
For example: |
| 24 |
|
| 25 |
DB_TESTING=1 PGPASSWORD=XXXXX make test |
| 26 |
|
| 27 |
Database tests are run using a database named `pgobject_test_db`, which |
| 28 |
will be dropped if it already exists. |
| 29 |
|
| 30 |
|
| 31 |
SUPPORT AND DOCUMENTATION |
| 32 |
|
| 33 |
After installing, you can find documentation for this module with the |
| 34 |
perldoc command. |
| 35 |
|
| 36 |
perldoc PGObject::Util::DBAdmin |
| 37 |
|
| 38 |
You can also look for information at: |
| 39 |
|
| 40 |
RT, CPAN's request tracker (report bugs here) |
| 41 |
http://rt.cpan.org/NoAuth/Bugs.html?Dist=PGObject-Util-DBAdmin |
| 42 |
|
| 43 |
AnnoCPAN, Annotated CPAN documentation |
| 44 |
http://annocpan.org/dist/PGObject-Util-DBAdmin |
| 45 |
|
| 46 |
CPAN Ratings |
| 47 |
http://cpanratings.perl.org/d/PGObject-Util-DBAdmin |
| 48 |
|
| 49 |
Search CPAN |
| 50 |
http://search.cpan.org/dist/PGObject-Util-DBAdmin/ |
| 51 |
|
| 52 |
GitHub source code repository (contribute patches here) |
| 53 |
https://github.com/ledgersmb/PGObject-Util-DBAdmin |
| 54 |
|
| 55 |
|
| 56 |
LICENSE AND COPYRIGHT |
| 57 |
|
| 58 |
Copyright (C) 2014-2019 Chris Travers |
| 59 |
|
| 60 |
This program is distributed under the (Revised) BSD License: |
| 61 |
L<http://www.opensource.org/licenses/BSD-3-Clause> |
| 62 |
|
| 63 |
Redistribution and use in source and binary forms, with or without |
| 64 |
modification, are permitted provided that the following conditions |
| 65 |
are met: |
| 66 |
|
| 67 |
* Redistributions of source code must retain the above copyright |
| 68 |
notice, this list of conditions and the following disclaimer. |
| 69 |
|
| 70 |
* Redistributions in binary form must reproduce the above copyright |
| 71 |
notice, this list of conditions and the following disclaimer in the |
| 72 |
documentation and/or other materials provided with the distribution. |
| 73 |
|
| 74 |
* Neither the name of Chris Travers's Organization |
| 75 |
nor the names of its contributors may be used to endorse or promote |
| 76 |
products derived from this software without specific prior written |
| 77 |
permission. |
| 78 |
|
| 79 |
THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS |
| 80 |
"AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT |
| 81 |
LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR |
| 82 |
A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT |
| 83 |
OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, |
| 84 |
SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT |
| 85 |
LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, |
| 86 |
DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY |
| 87 |
THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT |
| 88 |
(INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE |
| 89 |
OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. |
| 90 |
|