Postgres Pro
Downloads
Home   >   mailing lists

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

From Håkan Jacobsson
Subject [JDBC] Restore database from zipped textfile (.sql) created by pg_dumpall
Date
Msg-id 46BADDE7.6080604@relevanttraffic.com
Whole thread Raw
Responses Re: [JDBC] Restore database from zipped textfile (.sql) created by pg_dumpall  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: cluster
Date:
Subject: Re: tsearch2: plainto_tsquery() with OR?
Next
From: M S
Date:
Subject: failed to unlink, Permission denied