Old files .1 and .2

[dwr2]

I've got some sql files which look as though they are from some previous db creations. The files are called 35053 and 16443. There are 3 versions of the file, the orginal, .1 and .2 where .2 is the latest.

Can I delete the previous verions? Are there any more I can/should delete?

[APerfect10]

Are these files in your PostgreSQL data/base directory? I am a little confused...

Best regards,

Derek

[dwr2]

postgresql/8.2/data/base/16403/16443.<blank> (25 april)
postgresql/8.2/data/base/16403/16443.1 (30 april)
postgresql/8.2/data/base/16403/16443.2 (2 may)

postgresql/8.2/data/base/16403/35053.<blank> (25 april)
postgresql/8.2/data/base/16403/35053.1 (30 april)
postgresql/8.2/data/base/16403/35053.2 (2 may)

The date are when I created new databases and populated them; I did however delete (through PT3) the old databases.

[APerfect10]

I would not touch any files in the PostgreSQL data/base directory. If you delete the database then PostgreSQL should have deleted the corresponding files.

The only way I would clean out the directory is if you do a full backup then completely wipe PostgreSQL clean then reinstall and restore. To be honest, I doubt its worth the trouble.

Best regards,

Derek

[dwr2]

Ok thanks. I'm only bothering with it because they are 1GB+ files (each).

Just deleted them (well it is a beta....), and everything is Ok (they hadn't been altered anyway since the new db was created).

If I find out where came from/why they were left I'll post it, in case it happens to anyone else.