restore a dump db from tar file

From: "Alain Roger" <raf(dot)news(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: restore a dump db from tar file
Date: 2008-10-06 08:07:31
Message-ID: 75645bbb0810060107q44f28a51ge60c09e1c6d6602c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

i backup my database "sewe" using a standard process.
1. it backups only database and not roles :-( roles are backuped separately.
2. backup is a tar file
3. backup command is : pg_dump -v -o -U myuser -ci -Ft -f sewe.tar sewe

Question
how can i restore it now ?
could something like that could work on Windows XP ?
createdb sewe
gunzip -c sewe.tar | psql sewe

--
Alain
------------------------------------
Windows XP SP3
PostgreSQL 8.2.4 / MS SQL server 2005
Apache 2.2.4
PHP 5.2.4
C# 2005-2008

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Luis Castillo 2008-10-06 08:27:04 question
Previous Message Scott Marlowe 2008-10-06 02:07:00 Re: General data warehousing questions