Postgres Pro
Downloads
Home   >   mailing lists

restore a dump db from tar file - Mailing list pgsql-general

From Alain Roger
Subject restore a dump db from tar file
Date
Msg-id 75645bbb0810060107q44f28a51ge60c09e1c6d6602c@mail.gmail.com
Whole thread Raw
Responses Re: restore a dump db from tar file  ("Filip Rembiałkowski" <plk.zuber@gmail.com>)
Re: restore a dump db from tar file  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Re: restore a dump db from tar file  (Raymond O'Donnell <rod@iol.ie>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: General data warehousing questions
Next
From: Markus Wanner
Date:
Subject: Re: [Pkg-postgresql-public] Postgres major version support policy on Debian