Re: Copying a database - Mailing list pgadmin-support

From Raymond O'Donnell
Subject Re: Copying a database
Date
Msg-id 4C651280.3090707@iol.ie
Whole thread Raw
In response to Re: Copying a database  (Guillaume Lelarge <guillaume@lelarge.info>)
Responses Re: Copying a database  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgadmin-support
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.

Ray.

-- 
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie


pgadmin-support by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: PgAdmin Crash
Next
From: Guillaume Lelarge
Date:
Subject: Re: Copying a database