Re: pg_upgrade output directory
Bruce Momjian <bruce@momjian.us>
From: Bruce Momjian <bruce@momjian.us>
To: Greg Stark <gsstark@mit.edu>
Cc: Andrew Dunstan <andrew@dunslane.net>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2010-06-12T17:12:33Z
Lists: pgsql-hackers
Attachments
- /rtmp/diff (text/x-diff) patch
Greg Stark wrote: > On Sat, Jun 12, 2010 at 4:58 AM, Bruce Momjian <bruce@momjian.us> wrote: > > However, I might have been too conservative. ?How do tools that generate > > multiple output files usually handle this situation? ?Do they output in > > to a subdirectory in $HOME, or in a subdirectory of the current > > directory, or just create multiple files without a subdirectory? > > Generally they put them in the current directory without > subdirectories but take a parameter to specify a directory to use. > That parameter could be mandatory though if you're afraid the current > directory isn't a suitable place. Agreed. I have applied the attached patch which creates the files in the current directory. I think that will be fine and don't see any need for a directory parameter. I have kept the printing of the full path name in the output: Upgrade complete ---------------- | Optimizer statistics is not transferred by pg_upgrade | so consider running: | vacuumdb --all --analyze-only | on the newly-upgraded cluster. | Running this script will delete the old cluster's data files: | /u/pg_migrator/pg_migrator/delete_old_cluster.sh I figured this would be helpful for people on Windows who might not know the actual directory used for the files. However, it does make the display kind of wide. Ideas? -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + None of us is going to be here forever. +