Tom Lane wrote: > > Tulio Oliveira <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
