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

From: Håkan Jacobsson <hakan(dot)jacobsson(at)relevanttraffic(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: [JDBC] Restore database from zipped textfile (.sql) created by pg_dumpall
Date: 2007-08-09 09:27:03
Message-ID: 46BADDE7.6080604@relevanttraffic.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

The table indexes aren't restored when I run this command:

gunzip -c /filename/.gz | psql dbname

/
Should I use another cmd? Or am I missing a parameter?

/regards, Håkan Jacobsson

Responses

Browse pgsql-general by date

  From Date Subject
Next Message M S 2007-08-09 10:48:45 failed to unlink, Permission denied
Previous Message cluster 2007-08-09 09:14:06 Re: tsearch2: plainto_tsquery() with OR?