Home > mailing lists

Re: Import 2GB .sql file - Mailing list pgadmin-support

From	Patrick Headley
Subject	Re: Import 2GB .sql file
Date	January 3, 2020 02:28:41
Msg-id	18f4a129-957c-d5dc-2d94-140d5507cb61@linxco-inc.com Whole thread Raw
In response to	Re: Import 2GB .sql file (Christophe Pettus <xof@thebuild.com>)
List	pgadmin-support

Is that a 2GB backup or data file? The methods to import the data will be different depending on what you are starting with.

Patrick Headley
Linx Consulting, Inc.
(303) 916-5522
pheadley@linxco-inc.com
www.linxco-inc.com

On 1/2/20 4:20 PM, Christophe Pettus wrote:

On Jan 2, 2020, at 11:03, Travis Harris <travis@tapy.com> wrote:

I have a 2GB sql file that I need to import.

You might try just importing it with psql; that's probably the most effective way of getting it done.

--
-- Christophe Pettus  xof@thebuild.com

From: Christophe Pettus
Date: 03 January 2020, 02:20:39
Subject: Re: Import 2GB .sql file

From: Patrick Headley
Date: 03 January 2020, 02:32:47
Subject: Re: Import 2GB .sql file