pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Import Database
2+ messages / 2 participants
[nested] [flat]

* Import Database
@ 2005-03-23 03:31  root <root@weyland.caerdroia.org>
  0 siblings, 1 reply; 2+ messages in thread

From: root @ 2005-03-23 03:31 UTC (permalink / raw)
  To: pgsql-admin

This is a little odd, and I can't quite figure out how to do it.

I have a postgres 7.2.2 database, without the DB_VERSION file, so I'm assuming
this is an "alternate location" - as you can tell, I'm not a DBA.  Anyway,
the machine it was on got hacked, and I backed off the things I thought were
important, reinstalled the OS and put the other things, including this DB,
back into place.  Problem: I don't have the /var/lib/pgsql part of my old
installation, and now I have an apparently-good postgres 7.2.2 installation,
and an apparently-good database, but I cannot get the postgres server to
recognize the old database.

Obviously, without this I cannot dump and re-import, so I'm at a bit of a lss
as to what to do.  Is it possible to tell postgres that a database already
exists, and just to use it?  (I do know the information on the user who
owns the database, and the old passwords and such.)

Thanks

-jeff



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

* Re: Import Database
@ 2005-03-27 16:06  Alvaro Herrera <alvherre@dcc.uchile.cl>
  parent: root <root@weyland.caerdroia.org>
  0 siblings, 0 replies; 2+ messages in thread

From: Alvaro Herrera @ 2005-03-27 16:06 UTC (permalink / raw)
  To: root <root@weyland.caerdroia.org>; +Cc: pgsql-admin

On Tue, Mar 22, 2005 at 09:31:45PM -0600, root wrote:

> I have a postgres 7.2.2 database, without the DB_VERSION file, so I'm assuming
> this is an "alternate location" - as you can tell, I'm not a DBA.  Anyway,
> the machine it was on got hacked, and I backed off the things I thought were
> important, reinstalled the OS and put the other things, including this DB,
> back into place.  Problem: I don't have the /var/lib/pgsql part of my old
> installation,

Exactly what did you back up?  What are the contents of the directory
you are trying to "attach" ?

If you didn't backup a pg_clog directory, you are pretty much hosed, I
think.

-- 
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"On the other flipper, one wrong move and we're Fatal Exceptions"
(T.U.X.: Term Unit X  - http://www.thelinuxreview.com/TUX/)



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


end of thread, other threads:[~2005-03-27 16:06 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-03-23 03:31 Import Database root <root@weyland.caerdroia.org>
2005-03-27 16:06 ` Alvaro Herrera <alvherre@dcc.uchile.cl>

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