[GENERAL] Not a PG question: SCSI question

2001-05-15 Thread Jean-Arthur Silve
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

[GENERAL] Can't get lock for vacuum

2001-04-26 Thread Jean-Arthur Silve
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 ?

2001-03-27 Thread Jean-Arthur Silve
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 :

[GENERAL] Database Recovery

2001-02-13 Thread Jean-Arthur Silve
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