Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group