Skip site navigation (1) Skip section navigation (2)

Re: Copying a database

From: Ron Gafron <rgafron(at)sbcglobal(dot)net>
To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Cc: rod(at)iol(dot)ie, pgadmin-support(at)postgresql(dot)org
Subject: Re: Copying a database
Date: 2010-08-13 22:41:52
Message-ID: 4C65CA30.9040707@sbcglobal.net (view raw or flat)
Thread:
Lists: pgadmin-support
  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.
>
>

In response to

pgadmin-support by date

Next:From: Sim ZacksDate: 2010-08-16 06:18:53
Subject: tab from scratch tab
Previous:From: Guillaume LelargeDate: 2010-08-13 10:24:15
Subject: Re: Fwd: pgadmin3 1.10.5 crash (again)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group