From: | Magnus Hagander <magnus(at)hagander(dot)net> |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | pg_upgrade fails for non-postgres user |
Date: | 2011-01-28 22:08:22 |
Message-ID: | AANLkTi=84YRXFom1bhq9JaCr-WKg+SAauYgFYjkTucdJ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I just tried doing pg_upgrade on a database when logged in as user
"mha" rather than "postgres" on my system. And it failed. Even though
the db was initialized with superuser "mha". The reason for this was
that pg_upgrade tried to connect to the database "mha" (hardcoded to
be the db username), and that certainly didn't exist.
When that was fixed, I realized the psql command to create the
datanbases connect to database "template1" only to immediately switch
to database "postgres", which also seems rather pointless.
Attach patch makes it connect to the "postgres" database instead of
$USER, and then also changes the psql command to actually use it.
I know way too little about pg_upgrade to tell if this is fully safe,
but it does fix the problem in my installation.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
Attachment | Content-Type | Size |
---|---|---|
pg_upgrade_db.patch | text/x-patch | 991 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Alex Hunsaker | 2011-01-28 22:27:06 | Re: arrays as pl/perl input arguments [PATCH] |
Previous Message | Thom Brown | 2011-01-28 21:52:29 | Re: WIP: RangeTypes |