Обсуждение: PG_UPRADE issue

Поиск
Список
Период
Сортировка

PG_UPRADE issue

От
jmfox180
Дата:
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.