Re: database dump then restore on another system?

On Thu, Nov 09, 2006 at 08:54:20AM -0500, Rick Schumeyer wrote:
> To date I have always used pg on a system where I had pg superuser status.
> I'm trying to move a database from such a system to one where I am just
> a user, and I'm having a couple of problems.
>
> The first is, the output of pg_dump has a lot of lines like:
>
> ALTER FUNCTION some_function OWNER TO rick;
>
> The user 'rick' does not exist on the target system. I've looked at the
> help for pg_dump...it looks like specifying "no-owner" will skip these
> lines. Are there any side effects I need to be aware of?

Yes; everything will be owned by whatever user loads the dump in. In
this case, that's probably what you want.

> The second problem is the statement:
>
> CREATE PROCEDURAL LANGUAGE plpgsql;
>
> Apparently I need to be a pg superuser to do this? Do I need to get the
Yes.

> db admin to run this statement before I load the database? What if,
Yes.

> during testing, I need to drop/create the database? Do I need the admin
> to run something every time?

Yes, unless he adds it to template1.
--
Jim Nasby jim(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)