Re: [URGENT] Problems recovering database

Hello Bjoern,

Thanks for the tip. It worked to start the DB but when I issue:

psql -l

I can't see my databases :( Sorry for being such a pain but I am no
postgresql expert and I really need to recover these databases.

I know, "where's the backup" ... I wonder the same ... :((

/B

On Wed, 14 May 2003, Björn Metzdorf wrote:

> > It complains
> >
> > DEBUG:  open of /usr2/pgsql/data/pg_xlog/0000000000000000 (log file 0,
> > segment 0) failed: No such file or directory
> > DEBUG:  invalid primary checkpoint record
> > DEBUG:  open of /usr2/pgsql/data/pg_xlog/0000000000000000 (log file 0,
> > segment 0) failed: No such file or directory
> > DEBUG:  invalid secondary checkpoint record
> >
> > But these files were not present in the 'data' directory from this
> > server, only these:
> >
> > $ ls
> > 00000010000000B7  00000010000000B8  00000010000000B9  00000010000000BA
> > 00000010000000BB  00000010000000BC  00000010000000BD  00000010000000BE
> >
> > Any ideas on how should I proceed?
>
> try pg_resetxlog from contrib.
>
> Regards,
> Bjoern
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

--

--- Bruno Mattarollo <bruno@web1.greenpeace.org> ---
    SysAdmin & TechLead - Greenpeace International
    http://www.greenpeace.org/
----------------------------------------------------