Greg Smith <greg@xxxxxxxxxxxxxxx> writes: > Andy Dale wrote: >> I will however save/backup the files before removing them (just in >> case anything goes wrong). > If you do go through with this, I would recommend doing a complete > database dump afterwards using pg_dump/pg_dumpall. That should make it > immediately obvious if you broke something with the change. Doing pg_dump would expose the mistake if you'd removed an actual table's files. But I'm not sure it would expose it if you removed an index ... regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
