I need some help in finding my missing databases.
I did as pg_dumpall of 8.x and then updated to 8.1.2 and reloaded my
databases using psql -U postgres template1 < dumpfile.
I can see each one in psql -U xxxxx dbname and I can do a \dt to display
the tables on the server. When I try to connect any other way
(webmin/pgadmin/application) it can't find any dbs. Can anyone please
point me in a direction to find the problem?
Thanks,
Frank
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
