Re: I lost the pg_control file - Mailing list pgsql-general

From Tulio Oliveira
Subject Re: I lost the pg_control file
Date
Msg-id 3AF5D4A2.A4BFCF51@marilia.com
Whole thread Raw
In response to I lost the pg_control file  (Tulio Oliveira <mestredosmagos@marilia.com>)
Responses Re: I lost the pg_control file  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:
>
> Tulio Oliveira <tulio@marilia.com> writes:
> > gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations
> > -I../../src/include
> > -c -o pg_resetxlog.o pg_resetxlog.c
> > gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations pg_resetxlog.o
> > pg_crc.o   -Wl,-rpath,/usr/local/pgsql/lib -lz -lcrypt -lresolv -lnsl
> > -ldl -lm -lbsd  -o pg_resetxlog
> > /usr/bin/ld: cannot find -lbsd
> > collect2: ld returned 1 exit status
> > make: *** [pg_resetxlog] Error 1
>
> Hmm, did you run configure yourself, or are you using configure data
> out of an RPM?  Configure should not have added -lbsd to the compile
> switches if you don't have it available.
>
>                         regards, tom lane

Yeah, I run configure by myself... But I download the lastest PostgreSQL
version 7.1.1 and with this I can compile the pg_resetxlog... Then I ran
it over my $PGDATA directory with 4.5Gb of data.

But then, all data lost. When I "psql dbtest" and type \d, I can't see
any tables in there...

I try many times, and nothing... I have the demaged 4.5Gb backup, but is
not a good idea restore the one-day last backup...

Please, anyone can help-me by TELNET ???

Tulio Oliveira

ICQ# 11530810

regards,


--
Um velho homem sábio disse uma vez: "Quando você atualiza um exploit,
você é
bom. Quando você é o primeiro a hackear cada sucessiva versão de um
produto
que roda em milhões de computadores pela Internet, você cria uma
Dinastia".

pgsql-general by date:

Previous
From: "Muhammad Rusydi"
Date:
Subject: Re: nested if , and how to trigger....
Next
From: Tom Lane
Date:
Subject: Re: I lost the pg_control file