Brooks, Jason wrote:
Hello,
I have a data file dumped from a pgsql database version 7.1.2. I am
having troubles restoring this data to a new database server version
8.1.5. Are there some gotcha's involved, did the format change, or some
such?
If you still have the 7.1.2 database use the 8.1.5 (you should be
running 8.1.8) pg_dump to connect and make the backup. Then restore.
J
I have used the createdb command to make the basic database. it's when
I use the \i option in psql that I see invalid commands, syntax errors,
invalid roles, etc.
The original file was created with pg_dump -cou.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Jason Brooks ~ (503) 641-3440 x1861
Direct ~ (503) 924-1861
Email to: [EMAIL PROTECTED]
Twiki: http://twiki.wrs.com/do/view/Main/JasonBrooks
Senior Systems Administration Analyst
Wind River Systems
8905 SW Nimbus ~ Suite 255
Beaverton, Or 97008
---------------------------(end of broadcast)---------------------------
TIP 1: 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
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings