Re: [SQL] restoring a dump

2001-06-28 Thread Wei Weng
Do not understand your question. On 28 Jun 2001 16:32:47 -0700, Phuong Ma wrote: > I tried using pg_restore, but it did not restore the dump successfully. > Maybe it is the syntax I'm using, but I remember reading that you cannot > use the pg_restore to restore a dump that uses INSERT. Does an

Re: [SQL] restoring a dump

2001-06-28 Thread Phuong Ma
Peter Eisentraut wrote: > > Phuong Ma writes: > > > pg_dump -C -D -F t > test.tar > > tar -xvf test.tar > > psql restore.sql > > psql test < 19.dat > > psql test < 20.dat .. and so on > > psql test < toc.dat > > I believe you're supposed to use pg_restore on the tar file itself. > > -- > Peter

[SQL] restoring a dump

2001-06-28 Thread Phuong Ma
Hello, I have been trying to restore my dump and it seems like it is not working. I put the dump in a tar file and when I untarred it, there are several .dat files, a toc.dat file, and a restore.sql file. I used psql to restore these files into a database. I first started restoring the restor