Le sam. 15 mai 2021 à 01:14, frank picabia <fpica...@gmail.com> a écrit :
> > We cancelled a web application upgrade part way through when it was > realized > Postgres needed a version upgrade first. Using the dump file extracted > from > a full dump with pg_dumpall the DB was restored with a line like : > > psql -d dbname -f dump.sql > > The file dump.sql was extracted from the full dump using the script > pg_extract.sh script provided on Github by someone (not sure which fork). > > Others may want to take note, this tool does not include the declaration > of TABLESPACE and its location. So the tablespace files will be > in the general data area. \db+ reports tablespace is defined, but it's > just empty. If you have a CREATE TABLESPACE with LOCATION in your full > dump, you should add it back into the extracted result for a single DB. > it would probably be much more helpful if you reported that to on the original repo, so other users will have a better chance to be aware of that problem, and the author might also learn about the issue and fix it. >
