Skip site navigation (1) Skip section navigation (2)

R: Postgresql 9.0b2 : pg_upgrade not passing username to pgdumpall ?

From: "Cassiano, Marco" <mcassiano(at)manord(dot)com>
To: "Bruce Momjian" <bruce(at)momjian(dot)us>
Cc: <pgsql-admin(at)postgresql(dot)org>,<pgsql-testers(at)postgresql(dot)org>
Subject: R: Postgresql 9.0b2 : pg_upgrade not passing username to pgdumpall ?
Date: 2010-06-23 16:02:32
Message-ID: BC53C974C3B9E542BC0A9BD4C5B1168A0CC2D40B@NEWMAIL.manord.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-testers
Thank you Bruce,

I applied the patch and  found two things you might want to take in consideration :

1) dump.c Line 25 should be : 

SYSTEMQUOTE, ctx->new.bindir, ctx->old.port, ctx->user, ctx->output_dir);

And not

SYSTEMQUOTE, ctx->new.bindir, ctx->old.port, ctx->user, ctx->cwd);

(sorry, I'm not confident at producing patch files....)

2) I then recompiled pg_upgrade and reinstalled it.
Now it goes a little bit further but I think there's another point (vacuumdb of the new cluster) in which the username is missing.
You might want to take a look at this output (/tmp/pg_upgrade.log)

....

Checking for presence of required libraries                 ok

| If pg_upgrade fails after this point, you must
| re-initdb the new cluster before continuing.
| You will also need to remove the ".old" suffix
| from /dbms/pgdata-8.4/global/pg_control.old.

Performing Migration
--------------------
Adding ".old" suffix to old global/pg_control               ok
Analyzing all rows in the new cluster                       "/usr/local/pgsql/bin/vacuumdb" --port 5432 --all --analyze >> /tmp/pg_upgrade.log 2>&1
FATAL:  role "postgres" does not exist
vacuumdb: could not connect to database postgres: FATAL:  role "postgres" does not exist

..............

If I launch it manually adding the -U mysuperuser option it works...


Hope this is somehow useful

Regards 

Marco



-----Messaggio originale-----
Da: Bruce Momjian [mailto:bruce(at)momjian(dot)us] 
Inviato: martedì 22 giugno 2010 18:48
A: Cassiano, Marco
Cc: pgsql-admin(at)postgresql(dot)org
Oggetto: Re: [ADMIN] Postgresql 9.0b2 : pg_upgrade not passing username to pgdumpall ?

Cassiano, Marco wrote:
> Hi all,
> 
>  
> 
> it's my first trial with pg_upgrade so I'm surely missing something....
> 
> I'm trying to launch pg_upgrade passing my super user name but 
> pg_dumpall fails with a permission denied error....
> 
> I don't see the username in the pgdumpall call....could it be this the 
> problem ?
> 
> Thank you (I hope this is the right list to post this)

Turns out I was missing the user name designation. I am attaching the patch that fixes this, and a pg_ctl issue on Win32.

-- 
  Bruce Momjian  <bruce(at)momjian(dot)us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + None of us is going to be here forever. +

In response to

Responses

pgsql-admin by date

Next:From: Alvaro HerreraDate: 2010-06-23 17:11:44
Subject: Re: Unable to start Statistics Collector
Previous:From: Glyn AstillDate: 2010-06-23 15:23:39
Subject: Re: parallel option in pg_restore

pgsql-testers by date

Next:From: Josh BerkusDate: 2010-06-23 17:45:42
Subject: Re: local_preload_libraries converts path to lowercase?
Previous:From: Bruce MomjianDate: 2010-06-22 16:48:12
Subject: Re: Postgresql 9.0b2 : pg_upgrade not passing username to pgdumpall ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group