Postgres update 9.1 to 9.3 - error port 50432

From: Mauricio Tavares <mfx1975(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Postgres update 9.1 to 9.3 - error port 50432
Date: 2015-01-30 17:31:36
Message-ID: CAOQWw8ShKQEK=18wMjBL4Bt4V4d_N-GVjXzorBxw_XM_Yt15sw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Personal greetings ...

Anyone ever have used pg_upgrade ????

I tried to use it, but is giving the error

The following are the commands and the returned error.

-bash-4.1$ /usr/pgsql-9.3/bin/pg_upgrade -b /usr/pgsql-9.1/bin -B
/usr/pgsql-9.3/bin -d /var/lib/pgsql/9.1/data/ -D /var/lib/pgsql/9.3/data/
-o "-c config_file=/var/lib/pgsql/9.1/data/postgresql.conf" -O "-c
config_file=/var/lib/pgsql/9.3/data/postgresql.conf"
Performing Consistency Checks
-----------------------------
Checking cluster versions ok
Checking database user is a superuser ok
Checking for prepared transactions ok
Checking for reg* system OID user data types ok
Checking for contrib/isn with bigint-passing mismatch ok
Creating dump of global objects ok
Creating dump of database schemas
ok

*failure*
Consult the last few lines of "pg_upgrade_server.log" for
the probable cause of the failure.

connection to database failed: could not connect to server: No such file or
directory
Is the server running locally and accepting
connections on Unix domain socket "/var/lib/pgsql/.s.PGSQL.50432"?

could not connect to new postmaster started with the command:
"/usr/pgsql-9.3/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D
"/var/lib/pgsql/9.3/data/" -o "-p 50432 -b -c
autovacuum_multixact_freeze_max_age=2000000000 -c synchronous_commit=off -c
fsync=off -c full_page_writes=off-c
config_file=/var/lib/pgsql/9.3/data/postgresql.conf -c listen_addresses=''
-c unix_socket_permissions=0700 -c
unix_socket_directories='/var/lib/pgsql'" start
Failure, exiting
-bash-4.1$

I've changed the configs postgres the door, but still gives error ....

I tried to force the use of the door with the parameters -p and -P, however
the error was the same.

Has anyone experienced this situation ???

Thanks for listening ..

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message John Scalia 2015-01-30 18:29:22 Re: Postgres update 9.1 to 9.3 - error port 50432
Previous Message David G Johnston 2015-01-29 19:42:12 Re: Space taken by Null values