Your name : Olivier Jeannet
Your email address : ojeannet@slb.com
System Configuration
---------------------
Architecture (example: Intel Pentium) : Intel Pentium
Operating System (example: Linux 2.0.26 ELF) : Linux 2.2.13 ELF
PostgreSQL version (example: PostgreSQL-6.5.1): PostgreSQL-7.0
Compiler used (example: gcc 2.8.0) : gcc version egcs-2.91.66
Please enter a FULL description of your problem:
------------------------------------------------
I have downloaded PostgreSQL V7.0, compiled and installed it (it was
quite easy) on another location than 6.5 .
I want to save the database used in the 6.5 version to put it on the
7.0 version. On 6.5, I typed "pg_dumpall >/tmp/db.out" . Then, on 7.0,
I typed "psql -d template1 -f /tmp/db.out" (I followed the INSTALL file).
By the way the database is not very big, the output is 2.5 MB.
The problem is that the output of pg_dumpall doesn't totally work, and I
found that some statements are not in the proper order. So I edited the
output, made some cuts and pastes, and was able to successfully restore the
database. The few statements I had to put earlier in the output file are
"CREATE FUNCTION" statements, like :
CREATE FUNCTION "countadm_moduletable" (int4 ) RETURNS int4 AS 'SELECT
count(*) FROM ADM_MODULETABLE WHERE MODULETABLEID = $1' LANGUAGE 'SQL';
Does anyone know about this problem ?
Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
I can give the original scripts used to create the database, they are
quite small :
-rw-r--r-- 6795 May 15 10:07 STAR_createTables.sql
-rw-r--r-- 1500 May 15 10:07 STAR_createIndexes.sql
-rw-r--r-- 7586 May 22 17:55 STAR_fillTables.sql
-rw-r--r-- 2611 May 15 12:27 SERPME_createTables.sql
-rw-r--r-- 1188 May 15 12:31 SERPME_createIndexes.sql
-rw-r--r-- 755 May 15 12:33 SERPME_createTransacRecords.sql
If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
No idea.
--
Olivier Jeannet - POS Servers team
My Windoz PC didn't work well because I had not rebooted it enough...