[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

[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. ---

[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 Félix Eboue 75583 Paris Cedex 12 Tel : 01 44 67 05 05 Fax :

[ADMIN] what means "INSERT xxx yyy" ?

Hi ! Does anyone knows what means, after an INSERT for exemple the message : INSERT 19331808 1 What the meaning of the two numbers ? I had a problem with a DB because I reached the max transaction ID. So, how could i know what is the maximum ? and what is the current transaction ID ? Is it t

[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 tri