pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
I: file system backup of postgresql db onto another installation
2+ messages / 2 participants
[nested] [flat]

* I: file system backup of postgresql db onto another installation
@ 2005-04-14 17:15  Giovanni Gualdi <giovanni.gualdi@freefile.it>
  0 siblings, 1 reply; 2+ messages in thread

From: Giovanni Gualdi @ 2005-04-14 17:15 UTC (permalink / raw)
  To: pgsql-admin

of course, I did take care of postmaster.pid file, removing it when
necessary...

thanks
Giovanni

  _____  

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


Hi all,
 
I created a DB with PostgreSql 8.0.0beta4, and filled it up with data. It is
installed on Windows 2000 server.
 
I turned off the service for some regular maintainance, 
but for some reasons the PostgreSQL service cannot restart anymore.
I get the following error:
 
"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."
 
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.
 
 
Now my big problem is 
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).
 
I tried all ways to copy the 
\data directory and all its content inside a working installation of
PostgreSQL 8.0 
(not of 8.0.0beta4 since I cannot find anywhere the those installation
files), 
 
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 =)
 
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.
 
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...)
 
is there any way, 
any utility, to recover the data of a postgres DB just starting from the
file system?
 
thanks in advance,
Giovanni

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: I: file system backup of postgresql db onto another installation
@ 2005-04-18 21:32  Steve Garcia <sgarcia@bak.rr.com>
  parent: Giovanni Gualdi <giovanni.gualdi@freefile.it>
  0 siblings, 0 replies; 2+ messages in thread

From: Steve Garcia @ 2005-04-18 21:32 UTC (permalink / raw)
  To: pgsql-admin

Giovanni Gualdi wrote:
> of course, I did take care of postmaster.pid file, removing it when
> necessary...
> thanks
> Giovanni

<snip>

>     is there any way,
>     any utility, to recover the data of a postgres DB just starting from
>     the file system?

I did find a utility which does exactly what you want.... Except that it
appears that it was abandoned in 2003 and only supports up to 7.3.  It
gave me errors when I tried to run it on a 7.4 database.  The utility
was called pgfsck and it was written in Perl, so it should be moderately
portable.  Someone who understood the new file structure could probably
bring it back to life...

I managed to solve my problem without loss of data, by dumb luck more
than anything else.

Good luck!



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-04-18 21:32 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-04-14 17:15 I: file system backup of postgresql db onto another installation Giovanni Gualdi <giovanni.gualdi@freefile.it>
2005-04-18 21:32 ` Steve Garcia <sgarcia@bak.rr.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox