X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id F1FA153D9F for ; Thu, 14 Apr 2005 14:14:31 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 19719-09 for ; Thu, 14 Apr 2005 17:14:23 +0000 (GMT) Received: from posta.freefile.it (unknown [217.220.152.131]) by svr1.postgresql.org (Postfix) with ESMTP id 7400B5402D for ; Thu, 14 Apr 2005 14:14:20 -0300 (ADT) Received: from dev009it ([172.16.172.118]) by posta.freefile.it (8.12.8/8.12.8) with ESMTP id j3EHqaa8014868 for ; Thu, 14 Apr 2005 19:52:36 +0200 Message-Id: <200504141752.j3EHqaa8014868@posta.freefile.it> From: "Giovanni Gualdi" To: Subject: I: file system backup of postgresql db onto another installation Date: Thu, 14 Apr 2005 19:15:32 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0084_01C54126.549794B0" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 Thread-Index: AcVBFNO/AFzJviluSd2txcXna0ErVAAAKAsg X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.028 tagged_above=0 required=5 tests=HTML_60_70, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200504/225 X-Sequence-Number: 17238 This is a multi-part message in MIME format. ------=_NextPart_000_0084_01C54126.549794B0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable of course, I did take care of postmaster.pid file, removing it when necessary... thanks Giovanni _____ =20 Da: Giovanni Gualdi [mailto:giovanni.gualdi@freefile.it]=20 Inviato: gioved=EC 14 aprile 2005 19.10 A: 'pgsql-admin@postgresql.org' Oggetto: file system backup of postgresql db onto another installation Hi all, =20 I created a DB with PostgreSql 8.0.0beta4, and filled it up with data. = It is installed on Windows 2000 server. =20 I turned off the service for some regular maintainance,=20 but for some reasons the PostgreSQL service cannot restart anymore. I get the following error: =20 "Could not start the PostgreSQL Database Server [version # inserted = here] service on local computer. The service did not return an error. This could be an internal Windows error or an internal service error. If the problem persists, contact your system administrator." =20 I've no idea what could cause the problem, but looking on the net i = found that it could be a bug of the beta releases of postgres. Anyway, i tried to turn of as many services as i could from my server, = but it's still impossible to run the postgresql service. =20 =20 Now my big problem is=20 how to get the data out of the DB, since i don't have any recent dump of = the data (I've just the backup of the schema). =20 I tried all ways to copy the=20 \data directory and all its content inside a working installation of PostgreSQL 8.0=20 (not of 8.0.0beta4 since I cannot find anywhere the those installation files),=20 =20 I also updated the paths in \data\postmaster.conf and \data\global\config_exec_params, but the service crashes as soon as I try to run it: the error is the = same as before. (NET HELPMSG 3534, very useful =3D) =20 I even tried to uninstall 8.0.0beta4, keeping the \data directory, and = then installing on it the new 8.0, but still I have the same problem. =20 i've no idea why i cannot run it... should I change any configuration file? or is there a compatibility issue between 8.0.0beta4 and 8.0? = (strange...) or is the DB files corrupted in any way? (strange, since the server = didn't have any error or interruption...) =20 is there any way,=20 any utility, to recover the data of a postgres DB just starting from the file system? =20 thanks in advance, Giovanni ------=_NextPart_000_0084_01C54126.549794B0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
of=20 course, I did take care of postmaster.pid file, removing it when=20 necessary...
thanks
Giovanni

Da: Giovanni Gualdi=20 [mailto:giovanni.gualdi@freefile.it]
Inviato: gioved=EC 14 = aprile=20 2005 19.10
A: = 'pgsql-admin@postgresql.org'
Oggetto: file=20 system backup of postgresql db onto another = installation

Hi=20 all,
 
I = created a DB=20 with PostgreSql 8.0.0beta4, and filled it up with data. = It is installed = on Windows=20 2000 server.
 
I = turned off the=20 service for some regular maintainance,
but=20 for some=20 reasons the PostgreSQL service cannot restart = anymore.
I = get the=20 following error:
 
"Could not=20 start the PostgreSQL Database Server [version # inserted = here]
service on=20 local computer.
The service did not return an error. This could be = an=20 internal Windows
error or an internal service error.
If the = problem=20 persists, contact your system administrator."
 
I've = no idea what=20 could cause the problem, but looking on the net i found that it could = be a bug=20 of the beta releases of postgres.
Anyway, i tried to=20 turn of as many services as i could from my server, but it's still = impossible=20 to run the postgresql service.
 
 
Now = my big problem=20 is
how = to get the=20 data out of the DB, since i don't have any recent dump of the = data=20 (I've=20 just the backup of the schema).
 
I = tried all ways=20 to copy the
\data directory=20 and all its content inside a working installation of PostgreSQL 8.0=20
(not = of 8.0.0beta4=20 since I cannot find anywhere the those installation files),=20
 
I = also updated the=20 paths in \data\postmaster.conf and=20 \data\global\config_exec_params,
but = the service=20 crashes as soon as I try to run it: the error is the same as=20 before.
(NET = HELPMSG 3534,=20 very useful =3D)
 
I = even tried to=20 uninstall 8.0.0beta4, keeping the \data directory, and then installing = on it=20 the new 8.0, but still I have the same problem.
 
i've = no idea why i=20 cannot run it...
should I change=20 any configuration file?
or = is there a=20 compatibility issue between 8.0.0beta4 and 8.0?=20 (strange...)
or = is the DB files=20 corrupted in any way? (strange, since the server didn't have any error = or=20 interruption...)
 
is = there any way,=20
any=20 utility, to recover the data of a postgres DB just starting from = the file=20 system?
 
thanks in=20 advance,
Giovanni
------=_NextPart_000_0084_01C54126.549794B0--