On 10/20/11 12:14 PM, Karsten Hilbert wrote:
> Well, Ian isn't talking about removing data. What he was
> asking (I believe) is how to remove from the data directory
> files which got nothing to do with the database in question
> (but probably look like database files because, say, someone
> copied*another* database into the directory ;-)
pg_dumpall
stop postgres
save the .conf files
wipe $PGDATA
initdb
restore the .conf files
restart postgres
restore the dumpall
--
john r pierce N 37, W 122
santa cruz ca mid-left coast