March 29th, 2008, 11:57 PM
|
|
Registered User
|
|
Join Date: Mar 2008
Posts: 2
Time spent in forums: 10 m 19 sec
Reputation Power: 0
|
|
|
Database Broken
I have a fairly large postgresql 8.0 database (roughly 3gb) which became fragmented on my hard drive and performance was considerably reduced. Windows could not defragment so I closed all the processes associated with postgresql, shifted the folder onto my external drive then shifted it back. This has completely broken my database. I know very little about this program please excuse my ignorance. All the data associated with the database is in the folder D:\Program Files\PostgreSQL\8.0\data\base, is there a way to convert this data back into a database? All the programs I used to use this datasource for give a similar error -
Unable to connect to database
210 - SQLSTATE = 28000
Fatal: database "UGDB" does not exist
Any help at all would be greatly appreciated I really dont know where to start with this,
|
Dev Shed Forums Sponsor:
AT&T devCentral & BlackBerry(r) Webcast Series: BlackBerry and GPS -Build Location Awareness into your BlackBerry Applications, July 10th-1:00PM EST. Register Today!
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
