Re: Copying a database

Le 13/08/2010 11:38, Raymond O'Donnell a écrit :
> On 13/08/2010 06:32, Guillaume Lelarge wrote:
> 
>> If you want a plain (SQL) dump, you have to tick the "Only schema"
>> checkbox before doing the dump. You don't have anything special to on
>> the restore step.
> 
> It may be worth adding to this that you need to restore a plain dump via
> psql on the command line:
> 
>   psql -U <username> -f <sql file name> <database name>
> 
> There has been confusion in the past with people trying to use the
> "Restore" command in pgAdmin with plain dumps - this uses pg_restore,
> which is intended for custom dumps only.
> 

Oops, sure, you're right. I completely forgot that one.


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