Thursday, February 14, 2008

To kill the postgresql database

	ERROR:  database is being accessed by other users


If you get this error, you can kill the particular database using following command.


kill `ps auxww | grep 'postgres: username databasename' |grep -v 'grep' |awk '{ print $2 }'`

1 comment:

Anonymous said...

Integrating Perl with PHP

Yes, it is possible to integrate Perl Interpreter with PHP script. Perl and PHP are very popular web programming Language. Both the interpreter are developed in C language libraries.

Before Integrating make sure that you must install PHP and Perl language.

To check that, open the terminal,

shell> perl -v

It will check the Perl language version along with Perl description and copyright. Likewise,

shell> php -v

It will show the PHP language version along with Copyright and zend technologies group.

For integrating , you must install the PHP Perl extension package. You can download this PHP Perl extension package from this link,

http://pecl.php.net/package/perl

Follow the steps given in README file in the downloaded package.

Through Perl extension package, the programmer can

* load and execute perl files
* evaluate perl code
* access perl variables
* call perl functions
* instantiate perl objects
* access properties of perl objects
* call methods of perl objects

These features can be accessible only through API class called Perl().

For Example test.php :

echo "first line";
$perl_obj = new Perl(); // Creating a object called $perl_obj for the class Perl()
$perl_obj->require("perl_script_file.pl"); // Perl files can be loaded through Perl::require module.
echo "last line";

For more details,
http://devzone.zend.com/node/view/id/1712

R. Prasath