Hi,
I administer an quite important PGsql v. 7.0.3 installation... We
would very much like to upgrade, BUT we cannot afford to be offline
for a very long period .. half an hour is acceptable.
I have tried to install the new one under a new location and have
done an init-db.. both are running smoothly together (the new one
has a non-default port as long as the old one is necessary)
I have tried :
pg_dumpall > fulldump.sql
/path/to/new/version/bin/psql -h 5431
(inside psql): \i fulldump.sql
### This is the output (and the errors i get) :
You are now connected to database template1.
psql:fulldump.sql:2: ERROR: Relation 'tmp_pg_shadow' already
exists
DELETE 1
psql:fulldump.sql:4: ERROR: pg_ownercheck: invalid user id 27
psql:fulldump.sql:5: ERROR: pg_aclcheck: invalid user id 27
psql:fulldump.sql:6: invalid command \N
psql:fulldump.sql:7: invalid command \N
psql:fulldump.sql:8: invalid command \N
psql:fulldump.sql:9: invalid command \N
psql:fulldump.sql:10: invalid command \N
psql:fulldump.sql:10: invalid command \N
psql:fulldump.sql:11: invalid command \N
psql:fulldump.sql:11: invalid command \N
psql:fulldump.sql:12: invalid command \N
psql:fulldump.sql:12: invalid command \N
psql:fulldump.sql:13: invalid command \N
psql:fulldump.sql:13: invalid command \N
psql:fulldump.sql:14: invalid command \N
psql:fulldump.sql:15: invalid command \N
psql:fulldump.sql:16: invalid command \N
psql:fulldump.sql:17: invalid command \.
psql:fulldump.sql:18: ERROR: parser: parse error at or near
"mailhandler"
psql:fulldump.sql:19: ERROR: pg_aclcheck: invalid user id 27
psql:fulldump.sql:20: invalid command \.
You are now connected to database template1 as user postgres.
psql:fulldump.sql:22: ERROR: CREATE DATABASE: database
"sk" already exists
You are now connected to database sk as user postgres.
psql:fulldump.sql:24: \connect: FATAL 1: user "sk" does not exist
### how do i do it most easily ?
Tia
Svenne
--
svenne@krap.dk
http://www.krap.dk
ICQ 5434480
PGP-key http://keys.pgp.dk:11371/pks/lookup?op=get&search=0xDF484022
PGP @ http://www.pgp.com / http://www.phpi.com
