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

Re: Copying a database

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

In response to

Responses

pgadmin-support by date

Next:From: Guillaume LelargeDate: 2010-08-13 09:55:01
Subject: Re: Copying a database
Previous:From: Guillaume LelargeDate: 2010-08-13 05:33:31
Subject: Re: PgAdmin Crash

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