Upgrading PostgreSQL under Windows

Le 27/03/2019 � 07:02, Kumar Prince NCS a �crit�:

We are �Upgrading PostgreSQL under Windows from v9.3 to 9.5. Following
steps from https://www.postgresql.org/docs/10/pgupgrade.html

We are using PostgreSQL database for confluence application.

While running Step 9 , there is command to set path with postgres user.
As per installation of postgres database� , we haven�t created
�postgres� user on windows.

When we ran pg_upgrade.exe we are getting below error

You need to specify the user used for migration with the appropriate
command line option, for instance "-U postgres".
Othewise pg_upgrade will try to connect with your OS username, which
obviously won't work.

Since you can't specify a password in pg_upgrade's command, you will
also need to provide authentication informations in a pgpass.conf file
as per https://www.postgresql.org/docs/9.5/libpq-pgpass.html

Regards
--
Arnaud

Arnaud L. schrieb am 27.03.2019 um 14:00:

Le 27/03/2019 à 07:02, Kumar Prince NCS a écrit :

We are  Upgrading PostgreSQL under Windows from v9.3 to 9.5. Following steps from https://www.postgresql.org/docs/10/pgupgrade.html

We are using PostgreSQL database for confluence application.

While running Step 9 , there is command to set path with postgres user. As per installation of postgres database  , we haven’t created “postgres” user on windows.

When we ran pg_upgrade.exe we are getting below error

You need to specify the user used for migration with the appropriate command line option, for instance "-U postgres".
Othewise pg_upgrade will try to connect with your OS username, which obviously won't work.

Since you can't specify a password in pg_upgrade's command, you will also need to provide authentication informations in a pgpass.conf file as per https://www.postgresql.org/docs/9.5/libpq-pgpass.html

I typically set the connection method to "trust" in both pg_hba.conf files before starting pg_upgrade.