Re: Backup questions
От | Jason Tesser |
---|---|
Тема | Re: Backup questions |
Дата | |
Msg-id | 04875CB4331F0240A0AD66F97097865101137A00@paul обсуждение исходный текст |
Ответ на | Backup questions ("Jason Tesser" <JTesser@nbbc.edu>) |
Список | pgsql-general |
As you can see below it fails on the sequence. REVOKE ALL ON TABLE gbdetail_gbdetailid_seq FROM PUBLIC; pg_restore: LOG: statement: GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE gbdetail_gbdetailid_seq TO jboss; pg_restore: LOG: statement: -- -- TOC entry 275 (OID 883835) -- Name: gbequipmentatt; Type: TABLE; Schema: public; Owner: dbdevel -- Data Pos: 0 -- CREATE TABLE gbequipmentatt ( gbequipmentid bigserial NOT NULL, equipmentlink1 character varying, equipmentlink2 character varying ); pg_restore: NOTICE: CREATE TABLE will create implicit sequence "gbequipmentatt_gbequipmentid_seq" for "serial" column "gbequipmentatt.gbequipmentid" pg_restore: LOG: statement: -- -- TOC entry 276 (OID 883835) -- Name: gbequipmentatt; Type: ACL; Schema: public; Owner: dbdevel -- Data Pos: 0 -- REVOKE ALL ON TABLE gbequipmentatt FROM PUBLIC; pg_restore: LOG: statement: GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE gbequipmentatt TO jboss; pg_restore: LOG: statement: -- -- TOC entry 507 (OID 883835) -- Name: gbequipmentatt_id_seq; Type: ACL; Schema: public; Owner: dbdevel -- Data Pos: 0 -- REVOKE ALL ON TABLE gbequipmentatt_id_seq FROM PUBLIC; pg_restore: [archiver (db)] could not execute query: ERROR: relation "gbequipmentatt_id_seq" does not exist > -----Original Message----- > From: Tom Lane [mailto:tgl@sss.pgh.pa.us] > Sent: Friday, July 30, 2004 1:35 PM > To: Jason Tesser > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Backup questions > > "Jason Tesser" <JTesser@nbbc.edu> writes: > > I am not sure how to be more specific. > > Could you show us the pg_dump -s (schema only) output? > > regards, tom lane
В списке pgsql-general по дате отправления: