so when following the instructions of pg_upgrade
" If your installation directory is not version-specific, e.g.
/usr/local/pgsql, it is necessary to move the current PostgreSQL install
directory so it does not interfere with the new PostgreSQL installation.
Once the current PostgreSQL server is shut down, it is safe to rename the
PostgreSQL installation directory; assuming the old directory is
/usr/local/pgsql, you can do:
mv /usr/local/pgsql /usr/local/pgsql.old
to rename the directory."
i was just curious and try to see if the current postgres (which now is in
the pgsql.old directory instead) is still working
so i did a
/usr/loca/pgsql.old/bin/pg_ctl -D /usr/local/pgsql.old/data start
and it showed
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
but did not go further than that
then i tried to /usr/local/pgsql8/bin/psql to connect to the server
and it says
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
so am i doing something wrong with the "mv" command that i'm missing??
(beacuase it seems that everything screwed since i rename the complete
folder)
--
View this message in context: http://postgresql.1045698.n5.nabble.com/PG-UPRADE-issue-tp5759891.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.