Error on creating database in phppgadmin

Quick Fix: (worked with my Version (5.0.3) / pg 9.2.3 )

1. change to /classes/database
2. copy Postgres84.php to Postgres92.php
3. open Connection.php
4. add a line case '9.2': return 'Postgres92'; break; at the // Detect version and choose appropriate database driver switch.
5. open Postgres.php and copy functions getTablespaces + getTablespace
6. open Postgres92.php and paste the functions into the class

7. replace ", spclocation," with ", pg_tablespace_location(oid) asspclocation," in both functions.

8. in Postgres92.php change class name to Postgres92

I updated to Mountain Lion on my Mac Mini Server on the evening of 12/12/2012 which runs PostgreSQL 9.2.1. I had the same problem when I found this question. When I did a search about this problem I found the following bug tracker on the matter.

http://sourceforge.net/tracker/?func=detail&aid=3570272&group_id=37132&atid=418980

One of the comments suggests to download the developer branch from github to get around this from https://github.com/phppgadmin/phppgadmin/zipball/master. I did this and copied the to /Library/Server/Web/Data/Sites/Default and renamed the folder. I modified $conf['servers'][0]['host'] to 127.0.0.1 in /conf/config.inc.php. I think I had to copy config.inc.php-dist. I have been successful in creating databases. As of 12/12 they had not released a stable version for 9.2. Hopefully they will soon.

In short: table pg_tablespace does not have that column in 9.2.

It seems that information should be obtained from other means now, as mentioned in the mailing list.

Also notice how in the official phpPgAdmin page, the latest PostgreSQL supported version is 9.0.