Re: Upgrade data

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: josue <josue(at)lamundial(dot)hn>
Cc: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>, Richard Huxton <dev(at)archonet(dot)com>, PgSQL General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Upgrade data
Date: 2005-03-30 22:55:13
Message-ID: 87k6nooib2.fsf@asmodeus.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

josue <josue(at)lamundial(dot)hn> writes:

> I did a pg_dumpall and this sentence to restore it back
>
> ./psql template1 -U postgres -p 9981 < /home2/tmp/dbtest.tar

You need to use 'pg_restore' for tar format dumps.

-Doug

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mark Fox 2005-03-30 23:06:38 Days in month query
Previous Message Kemin Zhou 2005-03-30 22:46:37 join error?