Обсуждение: How to rebuild tables
Hello list, a few days ago my HD crashed. Unfortunally i have only a copy of the PGDATA-directory, no pg_dump-file. I installed the samepostgresql-version (6.3.2) on another system (tested it with some test-db/-tables) and then copied the PGDATA-directoryto that computer, but that wan't work. The postmaster start correct but every frontend-command ends witherrors (can't find db in pg_database). What should i do to recover these databases. Is there a tool to use the old tables in the new database. Why doen't work postgresql with these PGDATA-directory ? Sincerely, kuMichaelis. ------------------------------- I I I Kay-Uwe Michaelis I I Am Bachableiter 3 I I 85464 Neufinsing I I Tel: 08121-974659 I I Fax: 08121-989785 I I email: kum@kumichaelis.de I I I -------------------------------
On Fri, May 31, 2002 at 07:47:40AM +0200, Kay-Uwe Michaelis wrote: > Hello list, > > a few days ago my HD crashed. Unfortunally i have only a copy of the PGDATA-directory, no pg_dump-file. I installed thesame postgresql-version (6.3.2) on another system (tested it with some test-db/-tables) and then copied the PGDATA-directoryto that computer, but that wan't work. The postmaster start correct but every frontend-command ends witherrors (can't find db in pg_database). > > What should i do to recover these databases. > Is there a tool to use the old tables in the new database. > Why doen't work postgresql with these PGDATA-directory ? Well, you should create the db, then copy the files. Then you need to hope the pg_xlog directory backed up too. if not, there is some kind of reset log somewhere which may allow you to read it. but it's still dodgy. -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > Canada, Mexico, and Australia form the Axis of Nations That > Are Actually Quite Nice But Secretly Have Nasty Thoughts About America
Search the documentation does not work right now: Warning: Unable to connect to PostgreSQL server: connectDBStart() -- connect() failed: Connection refused Is the postmaster running (with -i) at 'db.postgresql.org' and accepting connections on TCP/IP port 5432? in /usr/local/www/www/idocs/opendb.php on line 3 Unable to access database -- Kaare Rasmussen --Linux, spil,-- Tlf: 3816 2582 Kaki Data tshirts, merchandize Fax: 3816 2501 Howitzvej 75 Åben 14.00-18.00 Web: www.suse.dk 2000 Frederiksberg Lørdag 11.00-17.00 Email: kar@kakidata.dk
> Search the documentation does not work right now: What I was trying to find was information about full text indexing. It's supposed to be used in a search engine. But maybe someone knows a search engine in Perl optimized for PostgreSQL? One that works ? ;-) -- Kaare Rasmussen --Linux, spil,-- Tlf: 3816 2582 Kaki Data tshirts, merchandize Fax: 3816 2501 Howitzvej 75 Åben 14.00-18.00 Web: www.suse.dk 2000 Frederiksberg Lørdag 11.00-17.00 Email: kar@kakidata.dk
On Fri, 31 May 2002, Kaare Rasmussen wrote: > > Search the documentation does not work right now: > > What I was trying to find was information about full text indexing. > > It's supposed to be used in a search engine. But maybe someone knows a > search engine in Perl optimized for PostgreSQL? > > One that works ? ;-) It works but it's not in perl and it doesn't do scoring but it is available from the contrib tree as tsearch. I seem to remember there is another search facility in there that is much closer to the original [open]FTS but I can't remember what it is called. It's fairly obvious from the directory name though. -- Nigel J. Andrews Director --- Logictree Systems Limited Computer Consultants
You certainly need openfts ( openfts.sourceforge.net ) which is based
on contrib/tsearch module. tsearch is our step to integrate openfts search
engine into postgresql. I'd recommend download openfts from CVS -
it's stable and better than last official release. The only thing
we need is to add some documentation. Also I've finished web crawler
for personal site and cgi search script. But didn't commited yet to CVS.
The problem is lack of time. Sorry
Oleg
On Fri, 31 May 2002, Nigel J. Andrews wrote:
>
>
> On Fri, 31 May 2002, Kaare Rasmussen wrote:
>
> > > Search the documentation does not work right now:
> >
> > What I was trying to find was information about full text indexing.
> >
> > It's supposed to be used in a search engine. But maybe someone knows a
> > search engine in Perl optimized for PostgreSQL?
> >
> > One that works ? ;-)
>
> It works but it's not in perl and it doesn't do scoring but it is available
> from the contrib tree as tsearch. I seem to remember there is another search
> facility in there that is much closer to the original [open]FTS but I can't
> remember what it is called. It's fairly obvious from the directory name though.
>
>
>
>
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
try archives.postgresql.org? On Fri, 31 May 2002, Kaare Rasmussen wrote: > Search the documentation does not work right now: > > Warning: Unable to connect to PostgreSQL server: connectDBStart() -- > connect() failed: Connection refused Is the postmaster running (with -i) at > 'db.postgresql.org' and accepting connections on TCP/IP port 5432? in > /usr/local/www/www/idocs/opendb.php on line 3 > Unable to access database > > -- > Kaare Rasmussen --Linux, spil,-- Tlf: 3816 2582 > Kaki Data tshirts, merchandize Fax: 3816 2501 > Howitzvej 75 �ben 14.00-18.00 Web: www.suse.dk > 2000 Frederiksberg L�rdag 11.00-17.00 Email: kar@kakidata.dk > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >
Kay-Uwe Michaelis <kum@kumichaelis.de> writes:
> a few days ago my HD crashed. Unfortunally i have only a copy of the PGDATA-directory, no pg_dump-file. I installed
thesame postgresql-version (6.3.2) on another system (tested it with some test-db/-tables) and then copied the
PGDATA-directoryto that computer, but that wan't work. The postmaster start correct but every frontend-command ends
witherrors (can't find db in pg_database).
This should work, if you copy the *entire* $PGDATA directory tree. You
cannot copy just part (the pg_log file has to be in sync with all the data
files).
BTW, 6.3.2 is very ancient history --- you *really* should update.
regards, tom lane
See: http://www.postgresql.org/idocs/index.php?runtime-config.html On Fri, 31 May 2002, Kaare Rasmussen wrote: > Search the documentation does not work right now: > > Warning: Unable to connect to PostgreSQL server: connectDBStart() -- > connect() failed: Connection refused Is the postmaster running (with -i) at > 'db.postgresql.org' and accepting connections on TCP/IP port 5432? in > /usr/local/www/www/idocs/opendb.php on line 3 > Unable to access database > > -- > Kaare Rasmussen --Linux, spil,-- Tlf: 3816 2582 > Kaki Data tshirts, merchandize Fax: 3816 2501 > Howitzvej 75 Åben 14.00-18.00 Web: www.suse.dk > 2000 Frederiksberg Lørdag 11.00-17.00 Email: kar@kakidata.dk > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >