07-29-2011
Determining PostgreSQL version
I need to find out if a version of PostgreSQL installed in SPARC Solaris is > 7.2
please tell me how to do it.
thanks.
7 More Discussions You Might Find Interesting
1. SuSE
Hi,
I am writing a Java Swing application and want to add Embedded SQL to it. The application should interact with a PostgreSQL database running on my local machine. The compiler complains that it cannot find the org.postgresql package included in the code. I'm guessing the problem is that... (0 Replies)
Discussion started by: marina
0 Replies
2. UNIX and Linux Applications
Guys,
I guess, I posted something in the wrong forum. Here it is -
https://www.unix.com/shell-programming-scripting/67395-perl-postgrepsql-question.html
Can you please help me with this?
Regards,
garric (0 Replies)
Discussion started by: garric
0 Replies
3. Programming
Hi guys.
I was was designing a simple database in postgresql. I wrote a perl function in postgresql and execute it. suddenly i saw that it is running in an infinite loop. After i stopped executing of the query, i saw that CPU is in 90%+ load. I looked at process list and there it was. postgresql... (1 Reply)
Discussion started by: majid.merkava
1 Replies
4. UNIX for Dummies Questions & Answers
I am first year year student .. and i need help
i tried to work with PostgreSQL but when i open the terminal, i face problem in how to reach to PostgreSQL . always i get message it says that " can not find server " .
so what shall i do please .....:( (9 Replies)
Discussion started by: barlom
9 Replies
5. UNIX and Linux Applications
I am trying to run vacuumdb script. but it exits with an error:
"ld.so.1: vacuumdb:fatal libpq.so.5 open failed no such file or directory"
same error is with some other pstgre commands.
please, help.
thanks.
edit: it seems I need to set LD_LIBRARY_PATH properly. but how to add to it?... (0 Replies)
Discussion started by: orange47
0 Replies
6. Solaris
Hi all,
I want to install two postgreql 8.3.5 instances on same servers. already one instalce is running on default port and i need it to be installed on another port.. How ever i achived installing the second instance.. but the problem is if i create a new user using createuser in the newly... (3 Replies)
Discussion started by: phani4u
3 Replies
7. Shell Programming and Scripting
How to copy a file from directroy/ prior version to the directory/ new version automatically. (4 Replies)
Discussion started by: roy1912
4 Replies
LEARN ABOUT DEBIAN
alzabo::driver::postgresql
Alzabo::Driver::PostgreSQL(3pm) User Contributed Perl Documentation Alzabo::Driver::PostgreSQL(3pm)
NAME
Alzabo::Driver::PostgreSQL - PostgreSQL specific Alzabo driver subclass
SYNOPSIS
use Alzabo::Driver::PostgreSQL;
DESCRIPTION
This provides some PostgreSQL specific implementations for the virtual methods in Alzabo::Driver.
METHODS
connect, create_database, drop_database
Besides the parameters listed in the Alzabo::Driver docs, the following parameters are accepted:
* options
* tty
schemas
This method accepts the same parameters as the "connect()" method.
get_last_id
Returns the last id created for a sequenced column.
identifier_length
Returns the maximum identifier length allowed by the database. This is really a guess based on the server version, since the actual value
is set when the server is compiled.
BUGS
In testing, I found that there were some problems using Postgres in a situation where you start the app, connect to the database, get some
data, fork, reconnect, and and then get more data. I suspect that this has more to do with the DBD::Pg driver and/or Postgres itself than
Alzabo. I don't believe this would be a problem with an app which forks before ever connecting to the database (such as mod_perl).
AUTHOR
Dave Rolsky, <autarch@urth.org>
perl v5.8.8 2007-12-23 Alzabo::Driver::PostgreSQL(3pm)