From: | shitake <shitake83(at)googlemail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Upgrade Postgres 8.4SS >> 9.1 |
Date: | 2012-01-17 14:07:31 |
Message-ID: | 1326809251173-5151661.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi guys,
i'm currently in the process of upgrading my 8.4SS version to a 9.1 version
of postgresql.
I am running it on a Windows 2003 Server machine.
The tool that I'm using is 'pg_upgrade'.
Both servers are stopped.
I have editet the pgpass.conf to include a line like this:
'*:*:*:postgres:postgres'
I have put a line like this into the pg_hba.conf : local all all
trust
The -? option on pg_upgrade doesn't show any parameter that I can set for a
password, I started the command line as User:postgres and the ouput I get is
this.
D:\Program Files\PostgreSQL\9.1\bin>pg_upgrade -d "D:/Program
Files/PostgresPlus
/8.4SS/data" -D "D:/Program Files/PostgreSQL/9.1/data" -b "D:/Program
Files/Post
gresPlus/8.4SS/bin" -B "D:/Program Files/PostgreSQL/9.1/bin" -p 5432 -P 5433
-v
Running in verbose mode
Performing Consistency Checks
-----------------------------
Checking current, bin, and data directories ok
Checking cluster versions ok
""D:/Program Files/PostgresPlus/8.4SS/bin/pg_ctl" -w -l "nul" -D "D:/Program
Fil
es/PostgresPlus/8.4SS/data" -o "-p 5432 -c autovacuum=off -c
autovacuum_freeze_m
ax_age=2000000000" start >> "nul" 2>&1"
connection to database failed: fe_sendauth: no password supplied
unable to connect to old postmaster started with the command: ""D:/Program
Files
/PostgresPlus/8.4SS/bin/pg_ctl" -w -l "nul" -D "D:/Program
Files/PostgresPlus/8.
4SS/data" -o "-p 5432 -c autovacuum=off -c
autovacuum_freeze_max_age=2000000000"
start >> "nul" 2>&1"
Failure, exiting
There's a window open with the data_dir of both servers and i never see a
postmaster.pid, so i can be sure that none of the 2 servers are started by
the pg_upgrade.
Where could i provide it with a password ??
And if the password is not the problem, what could i have possibly done
wrong ??
Thanks a lot.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Upgrade-Postgres-8-4SS-9-1-tp5151661p5151661.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | P. Broennimann | 2012-01-17 14:07:47 | Basic PostgreSQL Question |
Previous Message | Tefft, Michael J | 2012-01-17 12:58:25 | RE: [GENERAL] PostgreSQL counterpart to DBMS_METADATA? |