JRV problem with pg_upgrade

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-bugs by date

  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