Re: Importing Database

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
>
>