[support] restoring drupal site - postgresql database

[Ivan Sergio Borgonovo]

On Fri, 27 May 2011 15:20:39 -0400 (EDT)
Max Pyziur <pyz at brama.com> wrote:

> 
> Greetings,
> 
> While restoring one of my drupal-related databases, I get the
> following error/warning messages:
> 
> ERROR:  permission denied to set session authorization
> ERROR:  must be owner of schema public

How did you create the DB?

> The restore process is issued from a command line:
> > psql drupal1 < drupal1.out

What user are you using to perform this command?

Why didn't you use pg_dump/pg_restore?

Did you remember to create the DB user on the pg cluster?

During restore pg is trying to execute

SET SESSION AUTHORIZATION $username;
the username you're connecting with psql
if username doesn't have ownership of public schema.

I think that if that command fail you're going to create all the
object in the DB with the wrong ownership... and that may be a
problem.

-- 
Ivan Sergio Borgonovo
http://www.webthatworks.it