Thread: pg_dump and pg_dumpall error
Hai, I have built postgresql 7.2.0 from CVS tree to fix the pg_dump and pg_dumpall problems. But even after installing it from cvs file, it is still giving the same errors. The previous veriosn is 7.1.3 from which I took pg_dumpall. I could not restore the database in 7.2 with psql. Is there any alternative to fix this problem. I edited and changed the dump to point to the new path. i.e pgsql/7.2.0/lib etc. Here is the error file $ more errfile psql:/u01/app/pgsql/7.2.0/pgdepg.out:22: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'announce_pkey' for table 'a nnounce' psql:/u01/app/pgsql/7.2.0/pgdepg.out:98: ERROR: permission denied psql:/u01/app/pgsql/7.2.0/pgdepg.out:124: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'ref_sla_pkey' for table 'r ef_sla' psql:/u01/app/pgsql/7.2.0/pgdepg.out:135: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'ref_srv_type_pkey' for tab le 'ref_srv_type' psql:/u01/app/pgsql/7.2.0/pgdepg.out:146: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'ref_contact_type_pkey' for table 'ref_contact_type' psql:/u01/app/pgsql/7.2.0/pgdepg.out:158: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'cust_realms_pkey' for tabl e 'cust_realms' psql:/u01/app/pgsql/7.2.0/pgdepg.out:178: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'nprivate_label_pkey' for t able 'nprivate_label' psql:/u01/app/pgsql/7.2.0/pgdepg.out:198: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'private_label_pkey' for ta ble 'private_label' psql:/u01/app/pgsql/7.2.0/pgdepg.out:232: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'contacts_two_pkey' for tab le 'contacts_two' psql:/u01/app/pgsql/7.2.0/pgdepg.out:245: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'contact_groups_pkey' for t able 'contact_groups' psql:/u01/app/pgsql/7.2.0/pgdepg.out:263: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'announce_index_pkey' for t able 'announce_index' psql:/u01/app/pgsql/7.2.0/pgdepg.out:275: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'announce_manager_pkey' for table 'announce_manager' psql:/u01/app/pgsql/7.2.0/pgdepg.out:298: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'events_calendar_two_pkey' for table 'events_calendar_two' psql:/u01/app/pgsql/7.2.0/pgdepg.out:312: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'pk_extranet_section' for t able 'extranet_section' psql:/u01/app/pgsql/7.2.0/pgdepg.out:333: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'pk_extranet_docs' for tabl e 'extranet_docs' psql:/u01/app/pgsql/7.2.0/pgdepg.out:346: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'extranet_ids_pkey' for tab le 'extranet_ids' psql:/u01/app/pgsql/7.2.0/pgdepg.out:363: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'pk_extranet_personfolderpe rms' for table 'extranet_personfolderperms' psql:/u01/app/pgsql/7.2.0/pgdepg.out:379: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'pk_extranet_groupfolderper ms' for table 'extranet_groupfolderperms' psql:/u01/app/pgsql/7.2.0/pgdepg.out:400: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'wells_fargo_nciv_pkey' for table 'wells_fargo_nciv' psql:/u01/app/pgsql/7.2.0/pgdepg.out:421: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'pk_extranet_bug' for table 'extranet_bug' psql:/u01/app/pgsql/7.2.0/pgdepg.out:437: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'pk_extranet_bug_notes' for table 'extranet_bug_notes' psql:/u01/app/pgsql/7.2.0/pgdepg.out:459: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'pk_extranet_bug_tasks' for table 'extranet_bug_tasks' psql:/u01/app/pgsql/7.2.0/pgdepg.out:471: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'pk_extranet_bug_number' fo r table 'extranet_bug_number' psql:/u01/app/pgsql/7.2.0/pgdepg.out:496: ERROR: permission denied psql:/u01/app/pgsql/7.2.0/pgdepg.out:508: ERROR: permission denied psql:/u01/app/pgsql/7.2.0/pgdepg.out:534: ERROR: permission denied psql:/u01/app/pgsql/7.2.0/pgdepg.out:553: ERROR: permission denied psql:/u01/app/pgsql/7.2.0/pgdepg.out:571: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'contact_description_pkey' for table 'contact_description' psql:/u01/app/pgsql/7.2.0/pgdepg.out:592: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'phone_bank_nciv_pkey' for table 'phone_bank_nciv' psql:/u01/app/pgsql/7.2.0/pgdepg.out:693: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'authors_pkey' for table 'a uthors' psql:/u01/app/pgsql/7.2.0/pgdepg.out:803: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'financial_data_nciv_pkey' for table 'financial_data_nciv' psql:/u01/app/pgsql/7.2.0/pgdepg.out:824: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'financial_voice_nciv_pkey' for table 'financial_voice_nciv' psql:/u01/app/pgsql/7.2.0/pgdepg.out:845: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'home_mortgage_nciv_pkey' f or table 'home_mortgage_nciv' psql:/u01/app/pgsql/7.2.0/pgdepg.out:880: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'ref_region_pkey' for table 'ref_region' psql:/u01/app/pgsql/7.2.0/pgdepg.out:896: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'cust_profile_pkey' for tab le 'cust_profile' psql:/u01/app/pgsql/7.2.0/pgdepg.out:957: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'ref_subregion_pkey' for ta ble 'ref_subregion' psql:/u01/app/pgsql/7.2.0/pgdepg.out:3138: ERROR: CreateTrigger: function increment_bug() does not exist psql:/u01/app/pgsql/7.2.0/pgdepg.out:3146: ERROR: CreateTrigger: function initids() does not exist psql:/u01/app/pgsql/7.2.0/pgdepg.out:3154: ERROR: CreateTrigger: function increment_section() does not exist psql:/u01/app/pgsql/7.2.0/pgdepg.out:3162: ERROR: CreateTrigger: function increment_docs() does not exist psql:/u01/app/pgsql/7.2.0/pgdepg.out:3195: ERROR: mysequence.setval: you don't have permissions to set sequence mysequence Any help is appreciated and thanks in advance. chava
On 20 Feb 2002, Srinivasa Rao Chava wrote: > Hai, > I have built postgresql 7.2.0 from CVS tree to fix the pg_dump and > pg_dumpall > problems. But even after installing it from cvs file, it is still > giving the same errors. The previous veriosn is 7.1.3 from which I > took pg_dumpall. > I could not restore the database in 7.2 with psql. > Is there any alternative to fix this problem. I edited and changed the > dump to > point to the new path. i.e pgsql/7.2.0/lib etc. What are the lines that go with the permission denied errors?