[pgadmin-support] Problem creating backup of schema

[Niklas Olsson]

 

Hi

I run windows xp, pgdemo 1.10.3.

In this version I can no longer create a backup when schema has been changed.

this is what I do,

 

I have a schema in one database, export that one.

Restore in into another database.

Rename the schema, try to make a backup of it and get the error

 

pg_dump: No matching schemas were found
pg_dump: *** aborted because of error


This worked in version 1.10.1 (don't know about 1.10.2)

 

Is this meant to be and if so what is the proper way to make a backup of a 
renamed schema?

 

thanks

Niklas
  
_
Vårfina smileys till Messenger här!
http://springpack.msn.se

Re: [pgadmin-support] Problem creating backup of schema

[Raymond O'Donnell]

On 01/06/2010 15:16, Niklas Olsson wrote:
> I run windows xp, pgdemo 1.10.3.

I'm sure you mean pgAdmin. :-)

> I have a schema in one database, export that one.
> Restore in into another database.
> Rename the schema, try to make a backup of it and get the error
>  
> pg_dump: No matching schemas were found
> pg_dump: *** aborted because of error

How are you renaming it? Via pgAdmin's interface (right click ->
properties, etc) or with SQL commands though an edit window or psql? If
the latter, you'll need to refresh pgAdmin's view of the schema after
you rename it.

Ray.


-- 
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie

-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support