Обсуждение: Problem creating backup of schema

 <br /> Hi<br /> I run windows xp, pgdemo 1.10.3.<br /> In this version I can no longer create a backup when schema
hasbeen changed.<br /> this is what I do,<br />  <br /> I have a schema in one database, export that one.<br /> Restore
ininto another database.<br /> Rename the schema, try to make a backup of it and get the error<br />  <br /> pg_dump:
Nomatching schemas were found<br />pg_dump: *** aborted because of error<br /><br /> This worked in version 1.10.1
(don'tknow about 1.10.2)<br />  <br /> Is this meant to be and if so what is the proper way to make a backup of a
renamedschema?<br />  <br /> thanks<br /> Niklas<br /><br /><hr />Chatta från inkorgen. Se möjligheterna med Hotmail!
<ahref="http://springpack.msn.se" target="_new">Klicka här!</a> 

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
rod@iol.ie

<br /><style>
.ExternalClass .ecxhmmessage P
{padding:0px;}
.ExternalClass body.ecxhmmessage
{font-size:10pt;font-family:Verdana;}
</style>  <br />I sure mean pgAdmin :)<br />I rename it via pgAdmin's interface<br />what is the sql command to rename
aschame that way?<br /> <br />/Niklas<br /> <br />> Date: Tue, 1 Jun 2010 15:28:28 +0100<br />> From:
rod@iol.ie<br/>> To: niklaso@hotmail.com<br />> CC: pgadmin-support@postgresql.org<br />> Subject: Re:
[pgadmin-support]Problem creating backup of schema<br />> <br />> On 01/06/2010 15:16, Niklas Olsson wrote:<br
/>>> I run windows xp, pgdemo 1.10.3.<br />> <br />> I'm sure you mean pgAdmin. :-)<br />> <br />>
>I have a schema in one database, export that one.<br />> > Restore in into another database.<br />> >
Renamethe schema, try to make a backup of it and get the error<br />> > <br />> > pg_dump: No matching
schemaswere found<br />> > pg_dump: *** aborted because of error<br />> <br />> How are you renaming it?
ViapgAdmin's interface (right click -><br />> properties, etc) or with SQL commands though an edit window or
psql?If<br />> the latter, you'll need to refresh pgAdmin's view of the schema after<br />> you rename it.<br
/>><br />> Ray.<br />> <br />> <br />> -- <br />> Raymond O'Donnell :: Galway :: Ireland<br />>
rod@iol.ie<br/>> <br />> -- <br />> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)<br
/>>To make changes to your subscription:<br />> http://www.postgresql.org/mailpref/pgadmin-support<br /><br /><hr
/>Chatta från inkorgen. Se möjligheterna med Hotmail! <a href="http://springpack.msn.se/">Klicka här!</a><br /><br
/><hr/>Hotmail i mobilen på 5 sekunder! <a href="http://www.microsoft.com/sverige/windows/windowslive/thenewbusy.aspx"
target="_new">Klickahär!</a> 

On 03/06/2010 08:22, Niklas Olsson wrote:
> 
>  
> I sure mean pgAdmin :)

:-)

> I rename it via pgAdmin's interface
> what is the sql command to rename a schame that way?

Here you go:
 http://www.postgresql.org/docs/8.4/static/sql-alterschema.html

However, if you're renaming via pgAdmin, then my theory is incorrect - I
only ran into problems when I altered things outside of pgAdmin,
rendering pgAdmin's view of them invalid.

Ray.

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

Le 01/06/2010 16:16, Niklas Olsson a écrit :
>  
> 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?
>  

I tried that and it did work for me. My process:
* connect to db1* click on schema s1* right click to dump the schema* connect to db2* right click to restore schema s1*
refreshdb* click on schema s1* right click, properties, to rename it (new name: s2)* right click to dump the schema
 

And, no issues, schema s2 is dumped.

Have you forgotten a step?or did I? did you try on 1.12 beta?


-- 
Guillaumehttp://www.postgresql.frhttp://dalibo.com