Re: Copying a database

Thanks for the information. Much appreciated.

Ron

On 8/13/2010 4:55 AM, Guillaume Lelarge wrote:
> 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.
>
>