Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id C79FC9F95E7 for ; Mon, 20 Aug 2007 13:12:15 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 25174-02 for ; Mon, 20 Aug 2007 13:12:14 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 201839F95C0 for ; Mon, 20 Aug 2007 13:12:15 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.8/8.13.8) with ESMTP id l7KGCD4A076037 for ; Mon, 20 Aug 2007 13:12:13 -0300 (ADT) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.8/8.13.8/Submit) id l7KG33qX071432 for pgsql-admin@postgresql.org; Mon, 20 Aug 2007 13:03:03 -0300 (ADT) (envelope-from news) From: cipher X-Newsgroups: pgsql.admin Subject: Re: SOS. Database Lost Date: Mon, 20 Aug 2007 04:45:19 -0700 Organization: http://groups.google.com Lines: 64 Message-ID: <1187610319.287605.49280@k79g2000hse.googlegroups.com> References: <16e1f7ed0708200324w227a4f86q4fd3337f4a402f00@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Complaints-To: groups-abuse@google.com In-Reply-To: <16e1f7ed0708200324w227a4f86q4fd3337f4a402f00@mail.gmail.com> User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.4) Gecko/20070515 Firefox/2.0.0.4,gzip(gfe),gzip(gfe) X-HTTP-Via: 1.1 proxy.intra.getmobile.de:3128 (squid/2.5.STABLE6), 1.0 netcache-3 (NetCache NetApp/6.0.4), 1.0 netcache-3 (NetCache NetApp/6.0.4), 1.1 netcache-6 (NetCache NetApp/6.0.4) Complaints-To: groups-abuse@google.com Injection-Info: k79g2000hse.googlegroups.com; posting-host=85.158.137.195; posting-account=ps2QrAMAAAA6_jCuRt2JEIpn5Otqf_w0 To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/226 X-Sequence-Number: 26557 Hi, I'm not a specialist in Postgres, but I would do the following: 1=2E Backup your data directories and install the old version of postgres (8.0.1). It seems, that the format of the data files has been changed. 2=2E Restore your data files. If you have luck, then your database should be working. 3=2E After that, make a dump of your database(s). Under Linux, there is a tool name "pg_dump". Maybe use can also use pgadmin to create this dump. Note: pg_dump writes to standard output - pipe it to a file! 4=2E Uninstall postgres and install the new version. 5=2E Execute the dump files. Under Linux, you can do so with the the "psql" command. I hope, this could be a litte help to you. Greetings and good luck Markus On 20 Aug., 12:24, l.perr...@gmail.com ("luis perruca") wrote: > Hi All: I'm From Spain and I'll try to write in english as best as > possible: > > I'm new in the list, and I have a serious problem: I am novice with > Postgresql and I haven't found any solution. > I Wil descrive the scenario: > > I have Postgresql 8.0.1 running on Windows 2003 Server. > I have a Backup of my database, but is a little old > > And here is my problem: > > First, the Postgresql service didn't started (really started, but shut do= wn > immediatly) > then I copied all the "postgresql" folder in other place, uninstalled and > reinstalled Postgresql, and then overwrite the "data" folder with the one > from the copy that I did. > > Now, the service starts properly, but the database doesn=B4t work. I did > "pg_resetxlog" (I don=B4t know what it does, but I saw it somewhere). > > From pgAdmin III, I see the database, I access it, I see the tables and > their properties, but no data. I get the error "xlog flush request > 6D/432AAAA8 is not satisfied --- flushed only to 0/C03D020 CONTEXT: writ= ing > block 925 of relation 16631/17254/18128" when I try to view the tables > > I would need to know if I can recover the data from the tables and how to= do > it. > I thank any suggestion that can help. > > Luis Perruca