My bad...user and database not recognized after reboot

From: Gan Uesli Starling <alias(at)starling(dot)us>
To: pgsql-novice(at)postgresql(dot)org
Subject: My bad...user and database not recognized after reboot
Date: 2005-11-14 01:12:23
Message-ID: 4377E477.4050205@starling.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

This is on NetBSD 2.0.2 and PostgreSQL 8.0.3

I made a not-so-wise move...

I had run out of space on Unix directory /var and had
decided to move it. I not so cleverly used 'tar -cf' and
'tar -xf' to restore /var in its new location. Alas, it
seems to have set all ownerships in /var to root. Oops!

So...after reboot of the OS, psql now refuses to recognize
the former user (me) or my one and only database. But I am
sure my DB and all are still there because if I do this as
below...

cd /usr/pgdata
ls -laR base > /home/pkg/share/httpd/htdocs/pgsql/ls.txt

,,,which can be viewed here...

http://69.51.152.43/pgsql/ls.txt

...as lots and lots of numbered files, all of dates that
spread over the period of my database being created and
built. I'm guessing that is my database and all, yes?
Surely it is still there and intact...but unrecognized
somehow...I am guessing.

If that be the case, how might I get psql to admit
existence thereof and again allow access?

TIA,

Gan Starling
Kalamazoo MI
USA

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2005-11-14 03:23:24 Re: My bad...user and database not recognized after reboot
Previous Message stig erikson 2005-11-13 22:11:52 Re: Install RPM Pre-req