From: Ziggy Skalski <zskalski@afilias.info>
To: pgsql-admin@postgresql.org
Subject: Re: Re: PG_UPGRADE issues "this utility can only upgrade to postgresql version 9.2."
Date: Wed, 19 Jun 2013 13:08:57 -0400
Message-ID: <51C1E5A9.2030502@afilias.info> (raw)
In-Reply-To: <1371651412536-5759873.post@n5.nabble.com>
References: <1371491646614-5759509.post@n5.nabble.com>
<20130617230803.GC1997@momjian.us>
<1371578763431-5759711.post@n5.nabble.com>
<51C0CADF.6040001@afilias.info>
<1371651412536-5759873.post@n5.nabble.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On 13-06-19 10:16 AM, jmfox180 wrote:
> so i tried to do a
>
> /usr/local/pgsql.old/bin/postgres -D /usr/local/pgsql.old/data start
>
> LOG: database system was shut down at 2013-06-19 08:10:51 CST
> LOG: database system is ready to accept connections
> LOG: autovacuum launcher started
>
> it got stuck there ^^
>
> the i tried to
> /usr/local/pgsql.old/bin/psql -p 5432
>
> and it turns that
> 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 basically i just moved the whole pgsql8.3.2 that i had to a new folder
> which is pgsql.old with sudo mv etc,etc
> but i can not turn on the 8.3 server, i did try to start the new one (9.2.4)
> and yes i can.
>
> any idea?
>
>
>
> --
> View this message in context: http://postgresql.1045698.n5.nabble.com/PG-UPGRADE-issues-this-utility-can-only-upgrade-to-postgresq...
> Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
>
>
Does the file /var/run/postgresql/.s.PGSQL.5432.lock exist on the system
you're trying to upgrade ? If so, what's inside (cat it), does it
point to your /usr/local/pgsql.old/data directory? I've found that in
my (limited) experience with pg_upgrade, it's good to run the upgrade
from /tmp directory, that way the lock file gets created there and
usually there's no write permission problems in /tmp either :)
Ziggy
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: zskalski@afilias.info
Subject: Re: Re: PG_UPGRADE issues "this utility can only upgrade to postgresql version 9.2."
In-Reply-To: <51C1E5A9.2030502@afilias.info>
* 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