Which would you recommend? Leave the data directory in place and re-install PG or copy it to somewhere else, delete it and then re-install PG?
-Shawn > On Feb 15, 2017, at 9:36 AM, Magnus Hagander <mag...@hagander.net> wrote: > > On Wed, Feb 15, 2017 at 6:28 PM, Shawn Thomas <thoma...@u.washington.edu > <mailto:thoma...@u.washington.edu>> wrote: > Well that would make more sense of things. I had removed and re-installed > the postresql-common package: > > https://packages.debian.org/jessie/postgresql-common > <https://packages.debian.org/jessie/postgresql-common> > > and thought that it would leave the main PG package in place. But perhaps I > was wrong. I’ll follow Tom’s advice and just re-install everything (saving > the old data directory) and hope the new installation can use the old data > data directory. > > If you removed it and then installed it, then the removal would remove all > dependent packages and if you then only intalled that one and not the > dependencies that would explain it. > > If you had run a reinstall on it, then it would've kept them around. > > > One question about this approach though: the Debian package installation > automatically initializes the new data directory and starts PG. If I shut it > down and copy the old data directory into the newly installed one, will there > be an xlog issue? > > You have to copy the xlog along with the database. > > Or if you leave it in place where it is, the packages won't initialize a new > data directory. > > -- > Magnus Hagander > Me: http://www.hagander.net/ <http://www.hagander.net/> > Work: http://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>
