PG_UPRADE issue

From: jmfox180 <mcano(at)stsa(dot)info>
To: pgsql-admin(at)postgresql(dot)org
Subject: PG_UPRADE issue
Date: 2013-06-19 15:49:13
Message-ID: 1371656953272-5759891.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2013-06-19 16:52:28 Re: PG_UPGRADE issues "this utility can only upgrade to postgresql version 9.2."
Previous Message jmfox180 2013-06-19 14:16:52 Re: PG_UPGRADE issues "this utility can only upgrade to postgresql version 9.2."