From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Amitabh Kant <amitabhkant(at)gmail(dot)com> |
Cc: | PGSQL Mailing List <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pg_upgrade error on FreeBSD (9.1 -> 9.5) |
Date: | 2017-01-21 16:23:07 |
Message-ID: | 27960.1485015787@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Amitabh Kant <amitabhkant(at)gmail(dot)com> writes:
> command: "/var/tmp/pgbin.SPOsRj4D/bin/pg_ctl" -w -l "pg_upgrade_server.log"
> -D "/usr/local/pgsql/data91" -o "-p 50432 -b -c listen_addresses='' -c
> unix_socket_permissions=0700 -c unix_socket_directory='/usr/local/pgsql'"
Note the unix_socket_directory parameter, which is indeed being applied
because we can see it again in the ps output:
> pgsql 26636 0.0 1.4 66960 14512 - Is 4:08AM 0:00.06
> /var/tmp/pgbin.SPOsRj4D/bin/postgres -D /usr/local/pgsql/data91 -p 50432 -b
> -c listen_addresses= -c unix_socket_permissions=0700 -c
> unix_socket_directory=/usr/local/pgsql
However, your psql is looking for the socket in /tmp:
> $ psql -p 50432 -d template1
> psql: could not connect to server: No such file or directory
> Is the server running locally and accepting
> connections on Unix domain socket "/tmp/.s.PGSQL.50432"?
You could successfully connect to that server with
"psql -p 50432 -h /usr/local/pgsql ...", I expect.
The question is why pg_upgrade issued that option and then failed to
cope with the consequences. I suspect it has something to do with one
installation being configured with different default socket directory
than the other, but I don't have enough facts.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | PAWAN SHARMA | 2017-01-21 19:02:21 | Doubts regarding postgres Security |
Previous Message | Dorian Hoxha | 2017-01-21 15:46:07 | Re: Free seminar in Malmo: PostgreSQL at 10TB and Beyond |