On Fri, Jan 30, 2015 at 11:12:43AM -0500, Robert Haas wrote: > I think everyone who has read this mailing list for a while is > probably already aware of this problem. When you create a tablespace > somewhere inside the data directory, weird things happen. If you > pg_upgrade and then incautiously run the delete_old_cluster.sh script > thus created, you will blow away large chunks of your data.[1] If you
pg_upgrade doesn't create the deletion script in this case, and warns the user: Could not create a script to delete the old cluster's data files because user-defined tablespaces exist in the old cluster directory. The old cluster's contents must be deleted manually. > In the short term, I favor just adding a warning, so that people get > some clue that they are doing something that might be a bad idea. In > the long term, we might want to do more. Thoughts? Yes, good idea. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers