db - Mailing list pgsql-odbc
From | Daniel Phlander |
---|---|
Subject | db |
Date | |
Msg-id | 002f01c33fbc$d0831940$cb566150@phlandernpfjk7 Whole thread Raw |
List | pgsql-odbc |
Hello!
I have a problem:
I have installed PostgreSQL 7.3.3 and I have also put in the db a ( /usr/local/pgsql/bin/pg_dumpall > backup.sql ), which I made from a PostgreSQL 7.2.4. backup.sql; has uploaded with no problem, but now in the applications on which I work I have to make backup.sql from PgSQL 7.3.3 and to put into PgSQL 7.2.4., but I see this is not working (I have errors).
I want to know how can I put a backup.sql made on a PgSQL 7.3.3 and to upload it into PgSQL 7.2.4. ?
I look forward to hear from you! Thanks.
Daniel
[gnuworld@nx2 gnuworld]$ /usr/local/pgsql/bin/psql ccontrol < ccontrol.sql
You are now connected as new user gnuworld.
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
ERROR: parser: parse error at or near "("
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \.
ERROR: parser: parse error at or near "4"
invalid command \.
ERROR: parser: parse error at or near "4"
ERROR: parser: parse error at or near "ACCESS"
ERROR: parser: parse error at or near "moduser"
invalid command \.
ERROR: parser: parse error at or near "gchan"
invalid command \.
ERROR: parser: parse error at or near "190"
invalid command \.
ERROR: parser: parse error at or near "mciuc"
invalid command \.
ERROR: parser: parse error at or near "("
invalid command \.
ERROR: parser: parse error at or near "("
invalid command \.
ERROR: parser: parse error at or near "("
invalid command \.
ERROR: parser: parse error at or near "ACCESS"
invalid command \.
ERROR: parser: parse error at or near "("
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
ERROR: parser: parse error at or near "checkver"
invalid command \.
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index 'opers_pkey' for table 'opers'
ALTER
CREATE
CREATE
CREATE
ERROR: parser: parse error at or near "("
ERROR: parser: parse error at or near "("
ERROR: parser: parse error at or near "("
[gnuworld@nx2 gnuworld]$
You are now connected as new user gnuworld.
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
ERROR: parser: parse error at or near "public"
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
ERROR: parser: parse error at or near "("
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \.
ERROR: parser: parse error at or near "4"
invalid command \.
ERROR: parser: parse error at or near "4"
ERROR: parser: parse error at or near "ACCESS"
ERROR: parser: parse error at or near "moduser"
invalid command \.
ERROR: parser: parse error at or near "gchan"
invalid command \.
ERROR: parser: parse error at or near "190"
invalid command \.
ERROR: parser: parse error at or near "mciuc"
invalid command \.
ERROR: parser: parse error at or near "("
invalid command \.
ERROR: parser: parse error at or near "("
invalid command \.
ERROR: parser: parse error at or near "("
invalid command \.
ERROR: parser: parse error at or near "ACCESS"
invalid command \.
ERROR: parser: parse error at or near "("
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
ERROR: parser: parse error at or near "checkver"
invalid command \.
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index 'opers_pkey' for table 'opers'
ALTER
CREATE
CREATE
CREATE
ERROR: parser: parse error at or near "("
ERROR: parser: parse error at or near "("
ERROR: parser: parse error at or near "("
[gnuworld@nx2 gnuworld]$
pgsql-odbc by date: