Thread: Restoring a pg_dumped file...

I'm sure I'm doing something completely stupid, and it's really not too
important as I don't have any data in this database yet, but I can't get
a file dumped with pg_dump under 7.2.3 to restore with pg_restore in
7.3.

(tjg@reepicheep%) pg_restore
tjg.db_dump                                                        ~
pg_restore: [archiver] input file does not appear to be a valid archive

So, what silly thing am I not doing right?

Thank you.

--
Stand Fast,
    tjg.

Timothy Grant
www.craigelachie.org

On Thu, 2002-12-12 at 21:57, Timothy Grant wrote:
> I'm sure I'm doing something completely stupid, and it's really not too
> important as I don't have any data in this database yet, but I can't get
> a file dumped with pg_dump under 7.2.3 to restore with pg_restore in
> 7.3.
>
> (tjg@reepicheep%) pg_restore
> tjg.db_dump                                                        ~
> pg_restore: [archiver] input file does not appear to be a valid archive
>
> So, what silly thing am I not doing right?

I wonder how you created it?

If you said:  "pg_dump >dumpfile", you can't use pg_restore.  You should
use  "psql <dumpfile"

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight, UK                             http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "Be of good courage, and he shall strengthen your
      heart, all ye that hope in the LORD."
                                  Psalms 31:24

You are exactly correct! I knew I was doing something silly. Thank you
very much.

On Thu, 2002-12-12 at 14:40, Oliver Elphick wrote:
> On Thu, 2002-12-12 at 21:57, Timothy Grant wrote:
> > I'm sure I'm doing something completely stupid, and it's really not too
> > important as I don't have any data in this database yet, but I can't get
> > a file dumped with pg_dump under 7.2.3 to restore with pg_restore in
> > 7.3.
> >
> > (tjg@reepicheep%) pg_restore
> > tjg.db_dump                                                        ~
> > pg_restore: [archiver] input file does not appear to be a valid archive
> >
> > So, what silly thing am I not doing right?
>
> I wonder how you created it?
>
> If you said:  "pg_dump >dumpfile", you can't use pg_restore.  You should
> use  "psql <dumpfile"
>
> --
> Oliver Elphick                                Oliver.Elphick@lfix.co.uk
> Isle of Wight, UK                             http://www.lfix.co.uk/oliver
> GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
>                  ========================================
>      "Be of good courage, and he shall strengthen your
>       heart, all ye that hope in the LORD."
>                                   Psalms 31:24
>
>
--
Stand Fast,
    tjg.

Timothy Grant
www.craigelachie.org