pg_dump and pg_dumpall error

Поиск
Список
Период
Сортировка
От s.chava@wcom.com (Srinivasa Rao Chava)
Тема pg_dump and pg_dumpall error
Дата
Msg-id 66d229f1.0202201148.10c71bc2@posting.google.com
обсуждение исходный текст
Ответы Re: pg_dump and pg_dumpall error  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список 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

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Gaetano Mendola"
Дата:
Сообщение: Building binary...
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: How to set time zone permanently