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


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to