Re: Extraneous Files

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