From: | Erwin Moller <erwin(at)_removespam_dexus(dot)nl> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Newbie needs help: How to create a 'plain' 7.3 database in 7.2.1? |
Date: | 2003-02-26 09:02:12 |
Message-ID: | 3E5C8294.4060605@_removespam_dexus.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Dear reader,
Is it possible to create a 'plain' database made under Postgres 7.3 on a
Postgres 7.2.1 installation?
(With 'plain' I mean: nothing special like own functions, but only
tables, sequences, PK's, FK's, UNIQUE. Just the basics.)
I am looking for some kind of pg_dump from 7.3 whoose output can be used
to recreate the database on the 7.2.1 machine.
At the moment I keep getting errors on the sequences-settings as
produced by pg_dump.
Theese are the commands I use:
pg_dump:(On Postgres 7.3)
pg_dump -D mydatabase > mydb.txt
recreate (On Postgres 7.2.1) like this:
psql -d mydatabase -f mydb.txt
But it seems that Postgres7.2.1 doesn't understand this command:
SELECT pg_catalog.setval ('tbluser_userid_seq', 11, true);
and all similar sequence-set commands.
ERROR: parser: parse error at or near "("
What should I do?
Can I dump in another way, a 7.2.1-safe way?
Should I edit the output by hand somehow?
Please help!
Regards,
Erwin
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Alberer | 2003-02-26 09:12:03 | how to recover after harddisk error |
Previous Message | Antti Haapala | 2003-02-26 08:56:21 | Re: How do I change the server encoding? |