Re: [ADMIN] Recovering corrupted data.

2000-03-24 Thread Thomas Dean
I just completed a lot of recovery from losing all the bin/* part of psql version 6.4.2, and had to install 6.5.3. The disk file format changed, so, I had to translate the disk files into sql commands.` Most of the tables I had were text, char, etc. So, I used the standatd unix tools, like stri

Re: [ADMIN] pgsql-admin: disallowing CREATE TABLE

2000-03-23 Thread Thomas Dean
If I understand your question correctly, createuser will do this. 'man createuser' ... -D Does not allow the user to create databases.

[ADMIN] Data Recovery - 6.4.2 to 6.5.3 disk file translation

2000-03-23 Thread Thomas Dean
I was running version 6.4.2 when I lost all the binaries. I still have all the data/* and data/base/* files. The port for FreeBSD is 6.5.3. I have it installed, now. The disk file formats changed between version 6.4.2 and 6.5.3. Is there a tool or mechanism to translate these files into a for