X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 61468D1B7D0 for ; Tue, 15 Jun 2004 20:31:41 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 78143-01 for ; Tue, 15 Jun 2004 23:31:35 +0000 (GMT) Received: from trade-india.com (unknown [61.16.154.82]) by svr1.postgresql.org (Postfix) with SMTP id 95DCCD1B215 for ; Tue, 15 Jun 2004 20:31:29 -0300 (ADT) Received: (qmail 5232 invoked from network); 15 Jun 2004 23:15:18 -0000 Received: from system100.trade-india-local.com (HELO ?192.168.0.100?) (192.168.0.100) by system66.trade-india-local.com with SMTP; 15 Jun 2004 23:15:18 -0000 Message-ID: <40CF86F9.4000609@trade-india.com> Date: Wed, 16 Jun 2004 05:02:09 +0530 From: Rajesh Kumar Mallah User-Agent: Mozilla Thunderbird 0.6 (X11/20040502) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Cc: bm@turtle-entertainment.de Subject: Re: pg_xlog folder lost ! References: <57920.61.16.154.82.1087297680.squirrel@mail.trade-india.com> In-Reply-To: <57920.61.16.154.82.1087297680.squirrel@mail.trade-india.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=CLICK_BELOW X-Spam-Level: X-Archive-Number: 200406/185 X-Sequence-Number: 13845 I could start the postmaster after doing pg_resetxlog . The docs tell that a dump reload of the database should be done. I am trying to do that by starting a new postmaster in a seprate port and using pg_dumpall while i do that i get some minor errors like ALTER USER arvind SET search_path TO 'erp'; ERROR: schema "erp" does not exist and some ownership related errors like SET SESSION AUTHORIZATION 'rt_user'; SET ........ ........ CREATE INDEX attachments1 ON attachments USING btree (parent); ERROR: must be owner of relation attachments Following are the grant sequence on table attachments obtained by grepping the output REVOKE ALL ON TABLE attachments FROM PUBLIC; REVOKE ALL ON TABLE attachments FROM rt_user; GRANT ALL ON TABLE attachments TO postgres WITH GRANT OPTION; GRANT ALL ON TABLE attachments TO rt_user; is it some bug with pg_dumpall/pg_dump ? i am using 7.4.1 btw , shall now try with 7.4.3 Regds Mallah. mallah@trade-india.com wrote: >>Rajesh Kumar Mallah wrote: >> >> >>>Hi, >>> >>>The harddrive on which i had linked pg_xlog >>>has been lost. I have all other folders except that >>>which are in a seperate drive are present. >>> >>>Can i get my data back using pg_resetxlog ? >>> >>> >>Give it a try: create the xlog folder again and run pg_resetxlog. >> >> > > >Thanks. My hosting company is yet to bring the machine >up. I have tried this process in my local machine and it >works. > >I think this process only gets the data till last checkpoint >reliably . I hope its correct. > >Regds >Mallah > > > > >>Regards, >>Bjoern >> >> > > > >----------------------------------------- >Over 1,00,000 exporters are waiting for your order! Click below to get >in touch with leading Indian exporters listed in the premier >trade directory Exporters Yellow Pages. >http://www.trade-india.com/dyn/gdh/eyp/ > > > >---------------------------(end of broadcast)--------------------------- >TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > > >