pg_restore valid archive
Hi,
I'm trying to upgrade to 7.2 from 7.0. I first tried pg_dump from
7.0 and then pg_restore. It gave me "input file does not appear to be
a valid archive". I did a bit of research and found that versions of
pg_dump/restore are incompatible, so I pg_dumped it from the 7.2
pg_dump. It still gives me the same error. What do I need for a
valid archive? I'm doing something like:
pg_dump -h oldmachine mydb > pgmydb
None of the following work.
pg_restore pgmydb
pg_restore -d mydb pgmydb
pg_restore -d mydb -f pgmydb
Is there any trick to doing this? I can't even dump/restore a simple
database on the new machine.
Thanks!
So I used:
psql mydb < pgmydb
and it worked like a charm.
What's the deal with pg_restore? Is it just noise? The
docs show it working. Not a big deal, but I can't get it
to work.
Thanks.
eel@javabox.com (Eel) wrote in message news:<a62a408.0202151814.15a4dcc@posting.google.com>...
Show quoted text
Hi,
I'm trying to upgrade to 7.2 from 7.0. I first tried pg_dump from
7.0 and then pg_restore. It gave me "input file does not appear to be
a valid archive". I did a bit of research and found that versions of
pg_dump/restore are incompatible, so I pg_dumped it from the 7.2
pg_dump. It still gives me the same error. What do I need for a
valid archive? I'm doing something like:pg_dump -h oldmachine mydb > pgmydb
None of the following work.
pg_restore pgmydb
pg_restore -d mydb pgmydb
pg_restore -d mydb -f pgmydbIs there any trick to doing this? I can't even dump/restore a simple
database on the new machine.Thanks!
eel@javabox.com (Eel) writes:
Hi,
I'm trying to upgrade to 7.2 from 7.0. I first tried pg_dump from
7.0 and then pg_restore. It gave me "input file does not appear to be
a valid archive". I did a bit of research and found that versions of
pg_dump/restore are incompatible, so I pg_dumped it from the 7.2
pg_dump. It still gives me the same error. What do I need for a
valid archive? I'm doing something like:
If you're dumping in straight SQL format (the default), just use
'psql' to do the restore:
$ psql -f <dumpfile> <dbname>
-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863
Import Notes
Reply to msg id not found: eel@javabox.com'smessageof15Feb2002181438-0800
eel@javabox.com (Eel) writes:
So I used:
psql mydb < pgmydb
and it worked like a charm.
What's the deal with pg_restore? Is it just noise? The
docs show it working. Not a big deal, but I can't get it
to work.
It only works with the '-Ft' and '-Fc' dump formats, since they're not
plain SQL. Maybe the docs could be clearer...
-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863
Import Notes
Reply to msg id not found: eel@javabox.com'smessageof16Feb2002070609-0800
On Sat, 2002-02-16 at 15:06, Eel wrote:
What's the deal with pg_restore? Is it just noise? The
docs show it working. Not a big deal, but I can't get it
to work.
You weren't using the -F option to pg_dump. According to the reference
manual, that is necessary to make an archive that pg_restore can read.
--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
"My sheep hear my voice, and I know them, and they
follow me; And I give unto them eternal life; and they
shall never perish, neither shall any man pluck them
out of my hand." John 10:27,28