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

From: Håkan Jacobsson <hakan(dot)jacobsson(at)relevanttraffic(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Restore database from zipped textfile (.sql) created by pg_dumpall
Date: 2007-08-08 15:11:22
Message-ID: 46B9DD1A.2050705@relevanttraffic.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,

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

gunzip -c /filename/.gz | psql dbname

/
Should I use another cmd?

/regards, Håkan Jacobsson
/

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Emi Lu 2007-08-08 19:18:16 Dump all objects under a specific schema
Previous Message L. Rahyen 2007-08-06 18:04:33 Re: Strange crashes in JDBC code in multithreaded application.