PDA

View Full Version : Postgres question



peche
07-03-2011, 10:17 AM
Is there a way of finding out which version I am currently using?

Also 8.3 is 18gb on my computer but the huge files are located

8.3/data/base/25811 are this files needed or could/can I delete them?

netsrak
07-03-2011, 10:56 AM
Don't touch this folder - its the complete database. If you modify any file in this folder structure you will loose all your data.

To get the exact version you need to run a sql statement - see this for example: Re: Where to Get Version of PostgreSQL Installation (http://archives.postgresql.org/pgsql-admin/2006-12/msg00204.php)