recovery fail - Mailing list pgsql-general

From Łukasz Bieniek
Subject recovery fail
Date
Msg-id 20100825131515.B2A49190583F@fwb.poczta.interia.pl
Whole thread Raw
Responses Re: recovery fail
Re: recovery fail
Re: recovery fail
List pgsql-general
I'have made a backup my DB with pg_dump its (' pg_dump -U username dbname >backupfilename.sql.gz. When i want to
restoreit ( I drop the old database ,creaete new and language to it and i type a command 'cat
backupfilename.sql.gz|gunzip|/usr/local/pgsql/bin/psql-U username dbname) this backup restore my all tables but its
losesrelations to some tables. and when it is restoring sysem send me messeges about missing relations . I think it is
aboutorder in this recovery data from backup. How to resolve this problem? 


---------------------------------------------------------------------
Wez kredyt przez internet. Atrakcyjne oprocentowanie, bez zaswiadczen!
http://linkint.pl/f27d6


pgsql-general by date:

Previous
From: Joshua Berry
Date:
Subject: Optimizing queries that use multiple tables and many order by columns
Next
From: Denis BUCHER
Date:
Subject: Re: recovery fail