Sorry to bother you but I was unable to find this problem after looking through the mailing list. I have postgres setup up on UNIX and I configured the appropriate files and followed the steps from the manual. After I initialized the database server and started the postmaster I attempted to query template1 for the version number. Every time I run select version(); I get 0 rows returned. I also ran the query select * from pg_database which returned no rows, shouldn't template1 at least be in there? Did I miss a step, or is there any way to initialize these values. I am attempting to connect to this database using pgAdmin 3 but the select version() is failing because template1 is returning no rows. Any help would be appreciated.
Thanks, Adam ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match