Page 1 of 1

Old files .1 and .2

PostPosted: Fri May 02, 2008 9:16 pm
by 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?

Re: Old files .1 and .2

PostPosted: Sat May 03, 2008 12:24 am
by APerfect10
Are these files in your PostgreSQL data/base directory? I am a little confused...

Best regards,

Derek

Re: Old files .1 and .2

PostPosted: Sat May 03, 2008 8:43 am
by 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.

Re: Old files .1 and .2

PostPosted: Sat May 03, 2008 8:59 pm
by 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

Re: Old files .1 and .2

PostPosted: Sat May 03, 2008 9:33 pm
by 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.