Thread: 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