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 ..
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 |