From: Srinivas Iyyer <srini_iyyer_bio@yahoo.com>
To: Srinivas Iyyer <srini_iyyer_bio@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: Re: pg_dump question -- did I delete my database -- please help -- urgent
Date: Mon, 7 Aug 2006 07:57:50 -0700 (PDT)
Message-ID: <20060807145750.89468.qmail@web38104.mail.mud.yahoo.com> (raw)
In-Reply-To: <20060807131225.33009.qmail@web38113.mail.mud.yahoo.com>
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
$ sudo /sbin/restorecon -R /var/lib/pgsql
$ sudo /etc/rc.d/init.d/postgresql start
Initializing database:
[ OK ]
Starting postgresql service:
[ OK ]
$ psql -d mir-test
psql: FATAL: database "mrnatest" does not exist
$ psql -d arraydb
psql: FATAL: database "arraydb" does not exist
I am very much worried and I feel blood is not running
any more in me.
Please folks, tell me if something is really wrong.
The reason I donot have a backup also is that, my
pg_dump is not working.
when pg_dump'ed my database I created 0 bits file.
Very eagerly looking forward for some help...please..
thanks
--- Srinivas Iyyer <srini_iyyer_bio@yahoo.com> wrote:
> *** Apologies for re-posting this e-mail ****
>
> Dear group,
> I have a strange problem. apologies if this is the
> wrong place, however as a first option i am posting
> here. I have to subscribe to other special mailing
> lists.
>
>
> I have two databases in my system.
>
> In firstdb i am having the following problem:
> firstdb=# \d targets
> ERROR: could not access status of transaction 362
> DETAIL: could not open file
> "/var/lib/pgsql/data/pg_clog/0000": No such file or
> directory
>
> when I vacuumed it:
> $ vacuumdb firstdb
> vacuumdb: vacuuming of database "firstdb" failed:
> ERROR: could not access status of transaction 11
> DETAIL: could not open file
> "/var/lib/pgsql/data/pg_clog/0000": No such file or
> directory
>
>
>
> Second problem:
>
> Issue with secondb - arraydb
>
>
>
> $ vacuumdb arraydb
> VACUUM
>
> Suspecting there is something going on with
> postgres,
> I wanted to take a backup of the arraydb.
>
> here is what I am doing:
>
> $ sudo pg_dump arraydb >
> arraydb_bcup_Aug_05_2006.dump
>
> $ ls -lh
> total 8.0K
> -rw-r--r-- 1 speri postgres 0 Aug 5 20:17
> arradb_bcup_Aug_05_2006.out
>
>
> There is nothing in this. I created dumps long back
> and they are heavy.
>
> what could be the problem in the cases of first and
> second problems.
>
> looking forward to hear from experts eagerly.
>
> Thanks
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam
> protection around
> http://mail.yahoo.com
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please
> send an appropriate
> subscribe-nomail command to
> majordomo@postgresql.org so that your
> message can get through to the mailing list
> cleanly
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: srini_iyyer_bio@yahoo.com
Subject: Re: pg_dump question -- did I delete my database -- please help -- urgent
In-Reply-To: <20060807145750.89468.qmail@web38104.mail.mud.yahoo.com>
References: <20060807131225.33009.qmail@web38113.mail.mud.yahoo.com> <20060807145750.89468.qmail@web38104.mail.mud.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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