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. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
