Re: Can't import databases with pg_dump. Why? - Mailing list pgsql-general

From Doug McNaught
Subject Re: Can't import databases with pg_dump. Why?
Date
Msg-id m3n0op2hps.fsf@varsoon.wireboard.com
Whole thread Raw
In response to Can't import databases with pg_dump. Why?  ("Antonio G. - Geotronix" <nightnavigator@libero.it>)
List pgsql-general
"Antonio G. - Geotronix" <antonio@sunstone.it> writes:

> In your reply you told me that I'm not using pg_dump to restore. But as
> you can see in my previus message I am using pg_dump :-)

Well, it's wrong.  ;)  I phrased my response badly--I meant "You
shouldn't try to use pg_dump to restore, because it won't work."

Try it like this:

psql famiglia <  /mnt/redhat/home/postgres_postgres/famiglia.dump

This assumes your dump is in SQL format, which pg_dump creates by
default.  If you used custom or tar format, you need to use
'pg_restore' instead.  See the documentation for more info...

-Doug

pgsql-general by date:

Previous
From: Chris Bowlby
Date:
Subject: Re: Inquiry From Form [pgsql]
Next
From: Bruno Wolff III
Date:
Subject: Re: Sequence - Use calculated start value?