[GENERAL] Not a PG question: SCSI question
Hi ! I have 2 servers running apache, php and PG 7.0.3 running under Linux The first one uses IDE disks, and everything run fine and fast. (uses linux 2.0.36) The second one uses SCSI drives with a Adaptec adapter. (uses Linux 2.2.14) My problem is that acces to the DB on this server are very very slow (I guess that it s particulary slow when i do INSERTs) It s so slow that even the keyboard and the display slow down ! The HD write or read a lot... When I do a ps or top, I don't see any process taking all the ressources... So, I guess there is something whith the SCSI... Is anybody has a clue ?? thanks ! jean-arthur PS : I did a vacuum analyze, and the table are not so big (max tuples are 5000 ) EuroVox 4, place Félix Eboue 75583 Paris Cedex 12 Tel : 01 44 67 05 05 Fax : 01 44 67 05 19 Web : http://www.eurovox.fr ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[GENERAL] Can't get lock for vacuum
Hi ! Last day, when I did a vacuum, postgres crashes. Now It works fine, but I can't do VACUMM, the error message is something like Can't get lock. Is another Vacuum running ? What can I do to reactivate the vacuum ? thank you. EuroVox 4, place Félix Eboue 75583 Paris Cedex 12 Tel : 01 44 67 05 05 Fax : 01 44 67 05 19 Web : http://www.eurovox.fr ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
[GENERAL] .mdb to Postgres ?
Hi ! One of our customers has an MS Access DB (I think..) He sent me a .mdb file. Does anyone knows a way to convert this to postgreSQL db ? thank you ! EuroVox 4, place Flix Eboue 75583 Paris Cedex 12 Tel : 01 44 67 05 05 Fax : 01 44 67 05 19 Web : http://www.eurovox.fr ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[GENERAL] Database Recovery
Hi ! I have a big problem : all my datas are unavailable. When I do a vaccuum, that ok there are rows. When I do a "SELECT" or "\d", nothing. One of you told me that could be that I reached the max transaction ID. My pg_log is very big (1 Go !!) How could I retrieve my datas ? Of course I tried pg_dump : nothing ! Fils is the DB sub directories seems ok... I tried to make a new install, I re create all the DB, than moved my datafiles to each subdirectories. But nothing ! Then I moved to the old pg_log file to the new DB ! Nothing ! Is there a way to retrieve my datas, even without the indexes ??? thank you ! jean-arthur Le simple fait de passer par la fenetre ne suffit pas a la transformer en porte.