Postgres Pro
Downloads
Home   >   mailing lists

Re: [JDBC] Restore database from zipped textfile (.sql) created by pg_dumpall - Mailing list pgsql-general

From Tom Lane
Subject Re: [JDBC] Restore database from zipped textfile (.sql) created by pg_dumpall
Date
Msg-id 16333.1186675193@sss.pgh.pa.us
Whole thread Raw
In response to [JDBC] Restore database from zipped textfile (.sql) created by pg_dumpall  (Håkan Jacobsson <hakan.jacobsson@relevanttraffic.com>)
List pgsql-general
Tree view 
=?ISO-8859-1?Q?H=E5kan_Jacobsson?= <hakan.jacobsson@relevanttraffic.com> writes:
> The table indexes aren't restored when I run this command:
> gunzip -c /filename/.gz | psql dbname

Since you haven't shown us what commands are in that file or what output
you get, it's impossible to make any intelligent response to this.

            regards, tom lane

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: timestamp skew during 7.4 -> 8.2 upgrade
Next
From: "Leif B. Kristensen"
Date:
Subject: Re: Modified FIFO queue and insert rule