Re: restoring a dump - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: restoring a dump
Date
Msg-id Pine.LNX.4.30.0106282326370.724-100000@peter.localdomain
Whole thread Raw
In response to restoring a dump  (Phuong Ma <pma@commandprompt.com>)
List pgsql-sql
Phuong Ma writes:

> pg_dump -C -D -F t > test.tar
> tar -xvf test.tar
> psql restore.sql
> psql test < 19.dat
> psql test < 20.dat .. and so on
> psql test < toc.dat

I believe you're supposed to use pg_restore on the tar file itself.

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter



pgsql-sql by date:

Previous
From: "Ari Nepon"
Date:
Subject: Still stuck on a left join
Next
From: "Josh Berkus"
Date:
Subject: Re: Still stuck on a left join