Re: [JDBC] Restore database from zipped textfile (.sql) created by pg_dumpall

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Håkan Jacobsson <hakan(dot)jacobsson(at)relevanttraffic(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [JDBC] Restore database from zipped textfile (.sql) created by pg_dumpall
Date: 2007-08-09 15:59:53
Message-ID: 16333.1186675193@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

=?ISO-8859-1?Q?H=E5kan_Jacobsson?= <hakan(dot)jacobsson(at)relevanttraffic(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Leif B. Kristensen 2007-08-09 16:14:43 Re: Modified FIFO queue and insert rule
Previous Message Scott Marlowe 2007-08-09 15:49:38 Re: timestamp skew during 7.4 -> 8.2 upgrade