Determining PostgreSQL version

Thread Tools Search this Thread
Operating Systems Solaris Determining PostgreSQL version
# 1  
Old 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.
# 2  
Old 07-29-2011
there is no solaris 7.2... but to check installed packages use "pkginfo".
# 3  
Old 07-29-2011
Originally Posted by DukeNuke2
there is no solaris 7.2... but to check installed packages use "pkginfo".
no, I need to know if Postgre is >7.2

pkginfo doesn't help. it seems this is some 'custom built' postgre and pkginfo reports:
VERSION: release 5.10
but that seems like solaris version or something.

I need to be sure postgre version is above 7.2

I found this:
" How do I tell what PostgreSQL version I am running?
Run this query: SELECT version(); "

but don't know how to run query..

Last edited by orange47; 07-29-2011 at 11:00 AM..
# 4  
Old 07-29-2011

psql --version

Last edited by radoulov; 07-29-2011 at 01:03 PM.. Reason: Code tags.
This User Gave Thanks to ccj4467 For This Post:
# 5  
Old 08-01-2011
Originally Posted by ccj4467

psql --version

doesn't work..:

 $ /usr/local/pgsql/bin/psql --version psql: fatal: open failed: No such file or directory


I have found the following in documentation file (usr/local/pgsql/doc/html/pgtcl.html ) :
TITLE="PostgreSQL 7.2.1 Documentation"

is it safe to assume postgre is v7.2.1 ?

solved, by modifying .bashrc to include LD_LIBRARY_PATH for Postgre


Last edited by orange47; 08-01-2011 at 08:55 AM..
Login or Register to Ask a Question

Previous Thread | Next Thread

7 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Copy a file from directroy/ prior version to the directory/ new version

How to copy a file from directroy/ prior version to the directory/ new version automatically. (4 Replies)
Discussion started by: roy1912
4 Replies

2. Solaris

Postgresql installation

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

3. UNIX and Linux Applications

PostgreSQL problem with vacuumdb

I am trying to run vacuumdb script. but it exits with an error: " vacuumdb:fatal 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

4. UNIX for Dummies Questions & Answers

PostgreSQL - can not find server

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. Programming

kill - postgresql

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

6. UNIX and Linux Applications

Perl - PostGreSql query

Guys, I guess, I posted something in the wrong forum. Here it is - Can you please help me with this? Regards, garric (0 Replies)
Discussion started by: garric
0 Replies

7. SuSE

postgresql-jdbc on 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
Login or Register to Ask a Question