I just restored my database from a pg_dump backup version 7.0.3 to 7.1.2. It appears to work in that I can select * from users ...yada.
But tied to AOLserver and trying to get a page up I get this error:
[-conn0-] Notice: Querying 'select nextval('sec_id_seq') from dual; Notice: dbinit: sql(localhost::tgndata): 'select nextval 'sec_id_seq') from dual' Error: Database operation "1row" failed (exception NSINT, "Query did not return a row.") Database operation "1row" failed (exception NSINT, "Query did not return a row.") while executing "ns_db 1row $db [db_sql_prep $sql" (procedure "database_to_tcl_string" line 6) invoked from within "database_to_tcl_string $db "select sec_id_seq.nextval from dual"" (procedure "ad_assign_session_id" line 9) invoked from within "ad_assign_session_id $db" (procedure "ad_validate_security_info" line 16) invoked from within "ad_validate_security_info -secure $secure" (procedure "ad_verify_and_get_user_id" line 3)
I searched for 'sec_id_seq' in /www/doc/sql and came up with nothing. Perhaps it is something that didn't get restored with from the dump???
Pages that don't call the database come up fine...