From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | rod(at)iol(dot)ie |
Cc: | Ron Gafron <rgafron(at)sbcglobal(dot)net>, pgadmin-support(at)postgresql(dot)org |
Subject: | Re: Copying a database |
Date: | 2010-08-13 09:55:01 |
Message-ID: | 4C651675.9030506@lelarge.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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.
--
Guillaume
http://www.postgresql.fr
http://dalibo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2010-08-13 10:24:15 | Re: Fwd: pgadmin3 1.10.5 crash (again) |
Previous Message | Raymond O'Donnell | 2010-08-13 09:38:08 | Re: Copying a database |