Search Postgresql Archives

Re: Upgrading from 9.2.15 to 9.4.20

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux