pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / 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> 2006-09-27 16:53 ` Re: having trouble restoring a database from files Andrea Gozzi <andrea.gozzi@linuxrevolution.eu> 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: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> 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