Re: I lost the pg_control file

Tom Lane wrote:
>
> Tulio Oliveira <mestredosmagos(at)marilia(dot)com> writes:
> > I just lost the pg_control file, located in /usr/local/pgsql/data/global
>
> How did that happen?
>
> > I start a new INITDB after rename the PG_DATA directory to another name,
> > but if I copy the pg_control file to real data directory, I receive a
> > "NO FILE POINTER ERROR"...
>
> I think you could recover by copying in a freshly-initialized pg_control
> (be sure you make it with the same locale setting as before!) and then
> running the pg_resetxlog utility from contrib. You'll probably have to
> use the -f switch to pg_resetxlog ... read its README file!
>
> Once you get the postmaster to start, do NOT make any changes to the
> database, or you will be very sorry :-(. Run pg_dumpall, then reload
> the data into a correctly initialized database.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl

Thanks, Tom Lane,

But I can't compile the pg_resetxlog !!!

in /usr/src/postgresql-7.1rc4/contrib/pg_resetxlog directory, I typed
"make" and the result is:

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

And even I chmod 777 pg_resetxlog, and try ./pg_resetxlog -f $PGDATA, I
get an error "bash: ./pg_resetxlog.o: cannot execute binary
file"

Please, what can I do ???

regards,

tulio oliveira

--
Tulio Oliveira
Akácia Tecnologia
www.akacia.com.br
tulio(at)akacia(dot)com(dot)br