pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
having trouble restoring a database from files
2+ messages / 2 participants
[nested] [flat]

* having trouble restoring a database from files
@ 2006-09-27 16:19  Trefethen, Zachary J <zachary.j.trefethen@lmco.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Trefethen, Zachary J @ 2006-09-27 16:19 UTC (permalink / raw)
  To: pgsql-admin

Hello - 

 

I searched through the archives but didn't find a solution to the exact
situation I am in - please help if you can. 

 

had a server go down (running RHEL3), don't have one of my databases
backed up, but have the /var/lib/pgsql/ directory backed up.

 

I set up a new server and installed postgres on it, then untar'd my
/var/lib/pgsql files into the new server, to attempt to restore the
databases, but now postgresql won't start.

 

[root@ew root]# service rhdb start

Starting PostgreSQL - Red Hat Edition service:             [FAILED]

 

Any ideas on what might be preventing the service from starting?

 

Thanks!

 

Josh

 

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

* Re: having trouble restoring a database from files
@ 2006-09-27 16:53  Andrea Gozzi <andrea.gozzi@linuxrevolution.eu>
  parent: Trefethen, Zachary J <zachary.j.trefethen@lmco.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Andrea Gozzi @ 2006-09-27 16:53 UTC (permalink / raw)
  To: Trefethen, Zachary J <zachary.j.trefethen@lmco.com>; +Cc: pgsql-admin

Hi.
I was in the same situation a while ago, and compiling PG from source
solved the issue.
After installation is complete just run 

> postmaster -D /var/lib/pgsql/

and everything should be back as before.

Andrea.

On Wed, 2006-09-27 at 12:19 -0400, Trefethen, Zachary J wrote:
> Hello – 
> 
>  
> 
> I searched through the archives but didn’t find a solution to the
> exact situation I am in – please help if you can. 
> 
>  
> 
> had a server go down (running RHEL3), don’t have one of my databases
> backed up, but have the /var/lib/pgsql/ directory backed up.
> 
>  
> 
> I set up a new server and installed postgres on it, then untar’d
> my /var/lib/pgsql files into the new server, to attempt to restore the
> databases, but now postgresql won’t start.
> 
>  
> 
> [root@ew root]# service rhdb start
> 
> Starting PostgreSQL - Red Hat Edition service:             [FAILED]
> 
>  
> 
> Any ideas on what might be preventing the service from starting?
> 
>  
> 
> Thanks!
> 
>  
> 
> Josh
> 
>  
> 

Attachments:

  signature.asc (application/pgp-signature, 188B) download

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


end of thread, other threads:[~2006-09-27 16:53 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-09-27 16:19 having trouble restoring a database from files Trefethen, Zachary J <zachary.j.trefethen@lmco.com>
2006-09-27 16:53 ` Andrea Gozzi <andrea.gozzi@linuxrevolution.eu>

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