From: jmfox180 <mcano@stsa.info>
To: pgsql-admin@postgresql.org
Subject: PG_UPRADE issue
Date: Wed, 19 Jun 2013 08:49:13 -0700 (PDT)
Message-ID: <1371656953272-5759891.post@n5.nabble.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: mcano@stsa.info
Subject: Re: PG_UPRADE issue
In-Reply-To: <1371656953272-5759891.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox