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

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

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