Re: Upgrading from 9.2.15 to 9.4.20

From: Michal <sitkey(dot)michal(at)scheidt-bachmann(dot)sk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Upgrading from 9.2.15 to 9.4.20
Date: 2019-01-18 11:50:38
Message-ID: 1547812238246-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message ROS Didier 2019-01-18 12:26:58 repmgr and automatic failover
Previous Message Fabio Pardi 2019-01-18 11:47:48 Re: pgbouncer