From: cipher <markus.doerschmidt@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: SOS. Database Lost
Date: Mon, 20 Aug 2007 04:45:19 -0700
Message-ID: <1187610319.287605.49280@k79g2000hse.googlegroups.com> (raw)
In-Reply-To: <16e1f7ed0708200324w227a4f86q4fd3337f4a402f00@mail.gmail.com>
References: <16e1f7ed0708200324w227a4f86q4fd3337f4a402f00@mail.gmail.com>
Hi,
I'm not a specialist in Postgres, but I would do the following:
1. 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. Restore your data files. If you have luck, then your database
should be working.
3. 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. Uninstall postgres and install the new version.
5. 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 down
> 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´t work. I did
> "pg_resetxlog" (I don´t 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: writing
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: markus.doerschmidt@gmail.com
Subject: Re: SOS. Database Lost
In-Reply-To: <1187610319.287605.49280@k79g2000hse.googlegroups.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox