problem with postgresql 7.2 recovery - Mailing list pgsql-admin
From | s.chava@wcom.com (Srinivasa Rao Chava) |
---|---|
Subject | problem with postgresql 7.2 recovery |
Date | |
Msg-id | 66d229f1.0202151208.50d5e8a1@posting.google.com Whole thread Raw |
Responses |
Re: problem with postgresql 7.2 recovery
|
List | pgsql-admin |
Hi I have installed postgresql 7.2. I took the backup with pg_dumpall in postgresql7.1.3 and I tried to restore it in postgresql7.2 with the following command. psql -d template1 -f pgbackups. it is not restoring anything except creating databases, users, but no objects. Below is the full text of the output from recovery [TNETC:/u01/app/pgsql/7.2.0] psql -d template1 -f pgbackups You are now connected to database template1. DELETE 6 CREATE USER CREATE USER CREATE USER CREATE USER CREATE USER CREATE USER DELETE 0 You are now connected to database template1 as user pgsql. You are now connected to database template1 as user pgsql. COMMENT UPDATE 1 You are now connected to database template1 as user pgsql. CREATE DATABASE You are now connected to database mytest as user pgsql. You are now connected as new user develop. psql:pgbackups:62: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'announce_pkey' for table 'announce' CREATE REVOKE GRANT You are now connected as new user pgsql. psql:pgbackups:80: ERROR: stat failed on file '/u01/app/pgsql/7.1.2/lib/plpgsql.so': No such file or directory psql:pgbackups:88: ERROR: PL handler function plpgsql_call_handler() doesn't exist CREATE REVOKE GRANT GRANT You are now connected as new user develop. psql:pgbackups:138: ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'. Pre-installed languages are SQL, C, and internal. Additional languages may be installed using 'createlang'. You are now connected as new user pldev. CREATE psql:pgbackups:164: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'ref_sla_pkey' for table 'ref_sla' CREATE psql:pgbackups:175: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'ref_srv_type_pkey' for table 'ref_srv_type' CREATE psql:pgbackups:186: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'ref_contact_type_pkey' for table 'ref_contact_type' CREATE psql:pgbackups:198: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'cust_realms_pkey' for table 'cust_realms' CREATE psql:pgbackups:218: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'nprivate_label_pkey' for table 'nprivate_label' CREATE psql:pgbackups:238: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'private_label_pkey' for table 'private_label' CREATE You are now connected as new user develop. psql:pgbackups:272: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'contacts_two_pkey' for table 'contacts_two' CREATE psql:pgbackups:285: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'contact_groups_pkey' for table 'contact_groups' CREATE psql:pgbackups:303: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'announce_index_pkey' for table 'announce_index' CREATE psql:pgbackups:315: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'announce_manager_pkey' for table 'announce_manager' CREATE psql:pgbackups:338: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'events_calendar_two_pkey' for table 'events_calendar_two' CREATE psql:pgbackups:352: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'pk_extranet_section' for table 'extranet_section' CREATE psql:pgbackups:373: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'pk_extranet_docs' for table 'extranet_docs' CREATE psql:pgbackups:386: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'extranet_ids_pkey' for table 'extranet_ids' CREATE psql:pgbackups:403: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'pk_extranet_personfolderperms' for table 'extranet_personfolderperms' CREATE psql:pgbackups:419: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'pk_extranet_groupfolderperms' for table 'extranet_groupfolderperms' CREATE psql:pgbackups:440: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'wells_fargo_nciv_pkey' for table 'wells_fargo_nciv' CREATE psql:pgbackups:461: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'pk_extranet_bug' for table 'extranet_bug' CREATE psql:pgbackups:477: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'pk_extranet_bug_notes' for table 'extranet_bug_notes' CREATE psql:pgbackups:499: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'pk_extranet_bug_tasks' for table 'extranet_bug_tasks' CREATE psql:pgbackups:511: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'pk_extranet_bug_number' for table 'extranet_bug_number' CREATE psql:pgbackups:536: ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'. Pre-installed languages are SQL, C, and internal. Additional languages may be installed using 'createlang'. psql:pgbackups:548: ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'. Pre-installed languages are SQL, C, and internal. Additional languages may be installed using 'createlang'. psql:pgbackups:574: ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'. Pre-installed languages are SQL, C, and internal. Additional languages may be installed using 'createlang'. psql:pgbackups:593: ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'. Pre-installed languages are SQL, C, and internal. Additional languages may be installed using 'createlang'. psql:pgbackups:611: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'contact_description_pkey' for table 'contact_description' CREATE psql:pgbackups:632: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'phone_bank_nciv_pkey' for table 'phone_bank_nciv' CREATE You are now connected as new user pldev. CREATE You are now connected as new user pgsql. CREATE You are now connected as new user develop. CREATE You are now connected as new user pgsql. psql:pgbackups:689: ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'. Pre-installed languages are SQL, C, and internal. Additional languages may be installed using 'createlang'. psql:pgbackups:708: ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'. Pre-installed languages are SQL, C, and internal. Additional languages may be installed using 'createlang'. CREATE psql:pgbackups:733: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'authors_pkey' for table 'authors' CREATE CREATE CREATE CREATE CREATE CREATE CREATE CREATE CREATE CREATE You are now connected as new user develop. psql:pgbackups:843: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'financial_data_nciv_pkey' for table 'financial_data_nciv' CREATE psql:pgbackups:864: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'financial_voice_nciv_pkey' for table 'financial_voice_nciv' CREATE psql:pgbackups:885: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'home_mortgage_nciv_pkey' for table 'home_mortgage_nciv' CREATE CREATE CREATE You are now connected as new user pldev. psql:pgbackups:920: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'ref_region_pkey' for table 'ref_region' CREATE psql:pgbackups:936: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'cust_profile_pkey' for table 'cust_profile' CREATE psql:pgbackups:947: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'ref_subregion_pkey' for table 'ref_subregion' CREATE You are now connected as new user pgsql. CREATE REVOKE GRANT GRANT CREATE You are now connected as new user develop. CREATE CREATE You are now connected as new user pgsql. You are now connected as new user pldev. You are now connected as new user develop. You are now connected as new user pldev. You are now connected as new user pgsql. You are now connected as new user develop. You are now connected as new user pgsql. You are now connected as new user develop. You are now connected as new user pldev. You are now connected as new user pgsql. You are now connected as new user pldev. CREATE CREATE CREATE CREATE CREATE CREATE CREATE CREATE CREATE CREATE CREATE CREATE You are now connected as new user develop. CREATE CREATE CREATE CREATE CREATE CREATE CREATE CREATE CREATE CREATE CREATE CREATE CREATE CREATE CREATE psql:pgbackups:3052: ERROR: CreateTrigger: function increment_bug() does not exist psql:pgbackups:3060: ERROR: CreateTrigger: function initids() does not exist psql:pgbackups:3068: ERROR: CreateTrigger: function increment_section() does not exist psql:pgbackups:3076: ERROR: CreateTrigger: function increment_docs() does not exist You are now connected as new user pldev. CREATE CREATE CREATE psql:pgbackups:3109: ERROR: mysequence.setval: you don't have permissions to set sequence mysequence You are now connected to database template1 as user pgsql. CREATE DATABASE psql:pgbackups:3117: \connect: FATAL 1: Database "depg" does not exist in the system catalog. [TNETC:/u01/app/pgsql/7.2.0]
pgsql-admin by date: