josue <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly