From: | "RAVALET Jacques" <jacques(dot)ravalet(at)prestataire(dot)finances(dot)gouv(dot)fr> |
---|---|
To: | <pgsql-bugs(at)postgresql(dot)org> |
Cc: | <jacques(dot)ravalet(at)steria(dot)com> |
Subject: | JRV problem with pg_upgrade |
Date: | 2013-03-25 15:19:48 |
Message-ID: | 33DD7B734A847440AD07BD647035F58B03E878C0@DUBLIN.solano.alize |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hello,
I'am a database administrateur and I get trouble to upgrade database postgres
from 8.4.6 to 9.2.3.
During pg_upgrade, I can't start the old cluster with parameter -c
listen_addresses=''
This syntax work to start the old cluster and to access to the database
"/distrib/postgresql/app/chfdba/produit/8.4.6/bin/pg_ctl" -w -l
"pg_upgrade_server.log" -D "/distrib/postgresql/data/chorus_formulaires/data"
-o "-p 50432 -c autovacuum=off
-c autovacuum_freeze_max_age=2000000000 -c listen_addresses='*' -c
unix_socket_permissions=0700" start
This syntax doesn't work to start the old cluster
"/distrib/postgresql/app/chfdba/produit/8.4.6/bin/pg_ctl" -w -l
"pg_upgrade_server.log" -D "/distrib/postgresql/data/chorus_formulaires/data"
-o "-p 50432 -c autovacuum=off
-c autovacuum_freeze_max_age=2000000000 -c listen_addresses='' -c
unix_socket_permissions=0700" start
But pg_upgrade use this "bad" syntax even I try to force -c
listen_addresses='*'
pg_upgrade -c -d /distrib/postgresql/data/chorus_formulaires/data -D
/distrib/postgresql/data/chorus_formulaires/data/9.2.3 -b
/distrib/postgresql/app/chfdba/produit/8.4.6/bin -B
/distrib/postgresql/app/chfdba/produit/9.2.3/bin -o "-c listen_addresses='*'"
more pg_upgrade_server.log
could not connect to old postmaster started with the command:
"/distrib/postgresql/app/chfdba/produit/8.4.6/bin/pg_ctl" -w -l
"pg_upgrade_server.log" -D "/distrib/postgresql/data/chorus_formulaires/data"
-o "-p 50432 -c autovacuum=off -c autovacuum_freeze_max_age=2000000000
-c listen_addresses='*' -c listen_addresses='' -c
unix_socket_permissions=0700" start
Failure, exiting
I don't know how to workaround this problem ?
Best regards,
Jacques ravalet
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2013-03-25 17:50:45 | Re: |
Previous Message | krishnakumar | 2013-03-25 09:07:18 | Re: BUG #7940: Auto increment issue |