Thread: How can I recovery old Data from files and folders on windows?
I got some problem on PostgreSQL 8 for windows so I uninstall and reinstall it again. Before I uninstall PostgreSQL 8 I already backup all files and folders (copy all to other place). The problem is how can I restore by use files and folders that I already backup. If I try to restore by put all of it back it will be make a same error. I just want to restore only DATA (databases, functions, views, users, group etc). Please suggest me that How can I recovery old Data from files and folders on windows?
Hi! You can't. You'll have to restore your erroneous version first, then dump your data, the reinstall and use restore to restorethe data you want. Kind regards Markus > -----Ursprüngliche Nachricht----- > Von: pgsql-general-owner@postgresql.org > [mailto:pgsql-general-owner@postgresql.org] Im Auftrag von > Premsun Choltanwanich > Gesendet: Dienstag, 7. Dezember 2004 10:49 > An: pgsql-general@postgresql.org > Betreff: [GENERAL] How can I recovery old Data from files and > folders on windows? > > I got some problem on PostgreSQL 8 for windows so I uninstall > and reinstall it again. Before I uninstall PostgreSQL 8 I > already backup all files and folders (copy all to other place). > > The problem is how can I restore by use files and folders > that I already backup. If I try to restore by put all of it > back it will be make a same error. I just want to restore > only DATA (databases, functions, views, users, group etc). > > Please suggest me that How can I recovery old Data from > files and folders on windows? > > ---------------------------(end of > broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to > majordomo@postgresql.org >
L.S.
I noticed the following :
Workstation used to build RC1:
2.4.21-260-athlon, i686 athlon i386 GNU/Linux
Configured with :
./configure
--enable-thread-safety
--disable-shared
--prefix=/usr/src/postgresql/install
Error during make install :
in directory src/bin/pg_ctl
gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wendif-labels
-fno-strict-aliasing pg_ctl.o -L../../../src/interfaces/libpq -lpq
-L../../../src/port -Wl,-rpath,/usr/src/postgresql/install/lib -lpgport -lz
-lreadline -lcrypt -lresolv -lnsl -ldl -lm -o pg_ctl
../../../src/interfaces/libpq/libpq.a(fe-secure.o)(.text+0x140): In function
`pq_block_sigpipe':
: undefined reference to `pthread_sigmask'
../../../src/interfaces/libpq/libpq.a(fe-secure.o)(.text+0x1e0): In function
`pq_reset_sigpipe':
: undefined reference to `pthread_sigmask'
collect2: ld gaf exit-status 1 terug
There seems to be a missing option '-lpthread' here, adding it properly links
the file.
The same goes for pg_restore, pg_dumpall, psql, createdb, createlang,
createuser, dropdb, droplang, dropuser, clusterdb and vacuumdb.
--
Best,
Frank.
What do you show for PTHREAD_* in Makefile.global? Is this another platform where the library doesn't remember dependencies used when it was built? It is Linux so I wouldn't think so. --------------------------------------------------------------------------- Frank van Vugt wrote: > L.S. > > I noticed the following : > > > Workstation used to build RC1: > > 2.4.21-260-athlon, i686 athlon i386 GNU/Linux > > > Configured with : > > ./configure > --enable-thread-safety > --disable-shared > --prefix=/usr/src/postgresql/install > > > Error during make install : > > in directory src/bin/pg_ctl > > gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wendif-labels > -fno-strict-aliasing pg_ctl.o -L../../../src/interfaces/libpq -lpq > -L../../../src/port -Wl,-rpath,/usr/src/postgresql/install/lib -lpgport -lz > -lreadline -lcrypt -lresolv -lnsl -ldl -lm -o pg_ctl > ../../../src/interfaces/libpq/libpq.a(fe-secure.o)(.text+0x140): In function > `pq_block_sigpipe': > : undefined reference to `pthread_sigmask' > ../../../src/interfaces/libpq/libpq.a(fe-secure.o)(.text+0x1e0): In function > `pq_reset_sigpipe': > : undefined reference to `pthread_sigmask' > collect2: ld gaf exit-status 1 terug > > > There seems to be a missing option '-lpthread' here, adding it properly links > the file. > > The same goes for pg_restore, pg_dumpall, psql, createdb, createlang, > createuser, dropdb, droplang, dropuser, clusterdb and vacuumdb. > > > > > > -- > Best, > > > > > Frank. > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
> What do you show for PTHREAD_* in Makefile.global? PTHREAD_CFLAGS = -pthread -D_REENTRANT -D_THREAD_SAFE -D_POSIX_PTHREAD_SEMANTICS PTHREAD_LIBS = -lpthread > Is this another platform where the library doesn't remember dependencies > used when it was built? It is Linux so I wouldn't think so. Yeah, early in the beta-cycle builds on my Slackware v9.1 server showed symptoms like this, but these were already handled a while ago. This comes up just now since I started to use RC1 on my development workstation, which runs SuSE (v9.0 for that matter, will be able to try v9.1 in a couple of hours and v9.2 tomorrow, it you'd like). -- Best, Frank.
I just confirmed that the same goes for: Linux 2.6.5-7.111.5-default, i686 i686 i386 GNU/Linux (SuSE v9.1) Makefile.global holds: PTHREAD_CFLAGS = -pthread -D_REENTRANT -D_THREAD_SAFE -D_POSIX_PTHREAD_SEMANTICS PTHREAD_LIBS = -lpthread Would you like confirmation for v9.2 as well? -- Best, Frank.