on re-starting i lost access to a database

From: Michael Case <mecase(at)ucdavis(dot)edu>
To: pgsql-novice(at)postgresql(dot)org
Subject: on re-starting i lost access to a database
Date: 2001-01-19 00:14:35
Message-ID: 3A6786EB.157775BE@ucdhep.ucdavis.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

hi,

setting up for the first time i was able to get going and even created a
table in miketestdb. i then left for a while, now i started up again,
and the miketestdb files are still there, but (and maybe this was the
wrong thing to do) after following the same procedure the second time, i
ended up with no access to miketestdb (the files are still there!). the
error is FATAL 1: .... pg_database, which does only have template1 and
some other db in it. how do i revive miketestdb?

installation is redhat 6.2, the psql i think is 6.5.3, there is a
postgresql file in /etc/rc.d/init.d but i have not been using that, i've
been logging in as postgres and doing things (i.e. initdb)
interactively. i am using a PGDATA2 variable to
/home/postgresqldbs/data and that is where miketestdb was created last
time. i have done the initlocation on $PGDATA2 and wonder if by doing
so, the pg_database was re-initialized and "forgot" that miketestdb is
there.

i also used createuser to ad me as allowed to create databases and being
a superuser. for some reason, it forgot that too. i MAY have erased
some files after i quit playing with this last time.

i can not search the archives of any of the lists since the search is
busted on the site

http://postgresql.readysetnet.com/mhonarc/pgsql-novice/

thanks for any help.

--
Michael E. Case
UC Davis
case(at)ucdhep(dot)ucdavis(dot)edu
(530) 754-7226

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2001-01-19 01:59:29 Re: Yikes! Bitten by line length?
Previous Message Oliver Elphick 2001-01-19 00:02:41 Re: [NOVICE] Re: Interval output format