I got that figured out, and the data is now going into my v9.5 cluster
(shiny and new!).
I happen to hit 'Enter' on my terminal window after it was stagnant for
~1hr, and it gave me this error:
psql: fe_sendauth: no password supplied
I corrected that with pgpass and things are looking good.
Tha
Thanks Greg,
Sounds like I've unknowingly stumbled onto a good path, the one you
suggested.
I actually installed v9.5 on the target server. I have it running on a
different port (5444) and using a different data directory than the v8.3
install.
I'm doing the dump, and forwarding it to the remo
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> To move the DB, you are suggesting something like this:
> pg_dump -h dbms11 -U postgres -C mls11 | psql -h localhost -d mls11
Basically yes.
> I'm not familiar with removing/adding indexes (I'm not a DBA, just trying
> to pretend to be one
