SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-10-2008, 05:45 AM
| ||||
| ||||
 Missing Databases 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      |
|
04-10-2008, 05:45 AM
| |||
| |||
| Re: Missing Databases "Frank L. Parks" <fparks@ezbizpartner.com> writes: > 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? You sure those "other ways" are connecting to the same postmaster? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings |
|
04-10-2008, 05:45 AM
| ||||
| ||||
| Re: Missing Databases Tom: Tom Lane wrote: >"Frank L. Parks" <fparks@ezbizpartner.com> writes: > > >>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? >> >> > >You sure those "other ways" are connecting to the same postmaster? > > regards, tom lane > >---------------------------(end of broadcast)--------------------------- >TIP 5: don't forget to increase your free space map settings > > > > > Ok thanks - too many hours and not enough sleep. It was a "veesion" problem as my old math teacher would say. It helps to comment out the listen to address parameter - duh! #listen_addresses = '*' # what IP address(es) to listen on; Thanks for the prompt wake up call - all is right! Frank ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend |
Linear Mode
