Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group