Re: Upgrading from 9.2.15 to 9.4.20 - Mailing list pgsql-general

From Michal
Subject Re: Upgrading from 9.2.15 to 9.4.20
Date
Msg-id 1547812238246-0.post@n3.nabble.com
Whole thread Raw
In response to Re: Upgrading from 9.2.15 to 9.4.20  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Responses Re: Upgrading from 9.2.15 to 9.4.20  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Is anywhere where IP adress of the server must be set? Because im doing
upgrade on test and this is copy of the VM of production (upgrading Jira
PostgreSQL)...Checks when Postgres 9.2.15 running gives me ok when i stop
both instances and try to upgrade i have error what i writed. 

Can you be please more specific what can i do?

directory  /run/postgresql when Postgres 9.2.15 running contains this : 
pg_upgrade_internal.log  pg_upgrade_server.log  pg_upgrade_utility.log

and how can i make local UNIX connections trusted in pg_hba.conf?
pg_hba.conf contains this : 

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only
#local   all             all                                     peer
# IPv4 local connections:
#host    all             all             127.0.0.1/32            ident
# IPv6 local connections:
#host    all             all             ::1/128                 ident
# Allow replication connections from localhost, by a user with the
# replication privilege.
#local   replication     postgres                                peer
#host    replication     postgres        127.0.0.1/32            ident
#host    replication     postgres        ::1/128                 ident
local   all all                          trust
host    all    all 127.0.0.1/32    trust

Thanks for help



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html


pgsql-general by date:

Previous
From: Fabio Pardi
Date:
Subject: Re: pgbouncer
Next
From: ROS Didier
Date:
Subject: repmgr and automatic failover