Re: I lost the pg_control file

Tom Lane wrote:
>
> Tulio Oliveira <tulio(at)marilia(dot)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".