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

Re: Importing Database

From: "Nick Fankhauser" <nickf(at)ontko(dot)com>
To: <acchung(at)mit(dot)edu>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Importing Database
Date: 2002-06-25 01:57:30
Message-ID: NEBBLAAHGLEEPCGOBHDGKEEBFDAA.nickf@ontko.com (view raw or flat)
Thread:
Lists: pgsql-admin
Well, since it is already in text format, just load it normally:

psql <database name> -f 20020422_project_summaries.gz

psql doesn't care what the name is so long as the internal format is OK.

If you want to, you can rename it. (I probably would to avoid confusion
among the humans.)

-Nick

--------------------------------------------------------------------------
Nick Fankhauser  nickf(at)ontko(dot)com  Phone 1.765.935.4283  Fax 1.765.962.9788
Ray Ontko & Co.     Software Consulting Services     http://www.ontko.com/

> -----Original Message-----
> From: pgsql-admin-owner(at)postgresql(dot)org
> [mailto:pgsql-admin-owner(at)postgresql(dot)org]On Behalf Of acchung(at)mit(dot)edu
> Sent: Monday, June 24, 2002 10:30 AM
> To: pgsql-admin(at)postgresql(dot)org
> Subject: [ADMIN] Importing Database
>
>
> Hi,
>
> I'm trying to import this database into postgresql.
> The file is called 20020422_project_summaries.gz.
> When I gunzip it, I get:
>
> postgres(at)E52BPS588R /Databases
> $ gunzip 20020422_project_summaries.gz
>
> gunzip: 20020422_project_summaries.gz: not in gzip format
>
> When I type less 20020422_project_summaries.gz, I get the
> text of the database of this file.  So it seems that it's already unzipped
> but has the .gz extension.  how do I import this file
> as a database into postgresql?  I'm running cygwin and pgAdmin II
> on a win2k computer.
>
> Alex
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
>




In response to

pgsql-admin by date

Next:From: Harry YauDate: 2002-06-25 02:58:22
Subject: Mulit-User Locking??
Previous:From: Lee HarrDate: 2002-06-25 00:32:18
Subject: Re: Importing Database

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