pg_dump and pg_dumpall error

From: s(dot)chava(at)wcom(dot)com (Srinivasa Rao Chava)
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_dump and pg_dumpall error
Date: 2002-02-20 19:48:03
Message-ID: 66d229f1.0202201148.10c71bc2@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Gaetano Mendola 2002-02-20 19:52:53 Building binary...
Previous Message Tom Lane 2002-02-20 19:32:40 Re: Postgres Log Rolling