Re: Did I wipe off my database -- please help - urgent

On 8/7/06 11:19 AM, "Srinivas Iyyer" <srini_iyyer_bio(at)yahoo(dot)com> wrote:

> Dear Group,
>
> Please help me if you can. I am in a the most gravest
> situation. here
>
>
> I read the bug report :
> https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=143208
> reason:
>
> I got error when i tried \dt
> relation "pg_catalog.pg_user" does not exist.
>
> After reading some responses Comment#21 and Comment#22
> (I have no clue why I am getting that error and no
> idea about SELinux).
>
> I tried the following:
> $sudo /etc/rc.d/init.d/postgresql stop
> $ psql -d mrnatest
> psql: could not connect to server: S
> Is the server running locally and accepting
> connections on Unix domain socket
> "/tmp/.s.PGSQL.5432"?
>
> $ sudo rm -rf /var/lib/pgsql/data

Sri,

If you actually executed the command above and your data was stored in this
location (/var/lib/pgsql/data, a common location on linux for a data
directory), you just deleted the data directory and all the data on your
server. I could be wrong here, but I seriously hope you have a backup of
the machine....

Sean