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

Started by Håkan Jacobssonover 18 years ago2 messagesgeneral
Jump to latest
#1Håkan Jacobsson
hakan.jacobsson@relevanttraffic.com

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Håkan Jacobsson (#1)
Re: [JDBC] Restore database from zipped textfile (.sql) created by pg_dumpall

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