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