X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 137BA9FB1CA for ; Tue, 8 Aug 2006 02:24:31 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 44790-04 for ; Tue, 8 Aug 2006 02:24:26 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from web56615.mail.re3.yahoo.com (web56615.mail.re3.yahoo.com [66.196.97.59]) by postgresql.org (Postfix) with SMTP id 6926E9FAA6E for ; Tue, 8 Aug 2006 02:24:26 -0300 (ADT) Received: (qmail 93710 invoked by uid 60001); 8 Aug 2006 05:24:25 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=aOBMvZlC4n4zpcItXRfajQd00MZMttOND6Vg5xCFVKUjvAlgecIxHnHCrpYDnckDjrnXHkQjo/2PS3EhUG4wIXqaVtL055P/QV7Xwse68d+Hx60KL//tgXs8s4O+6UAsw92L0kQ5XU/UAnK8HLo5d9vN2orz422hoBfsXI4DM14= ; Message-ID: <20060808052425.93708.qmail@web56615.mail.re3.yahoo.com> Received: from [203.143.27.130] by web56615.mail.re3.yahoo.com via HTTP; Mon, 07 Aug 2006 22:24:25 PDT Date: Mon, 7 Aug 2006 22:24:25 -0700 (PDT) From: Thusitha Kodikara Subject: Re: pg_dump question -- did I delete my database -- please help -- urgent To: Srinivas Iyyer , pgsql-admin@postgresql.org In-Reply-To: <20060807145750.89468.qmail@web38104.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1039139022-1155014665=:84937" Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.796 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, HTML_MESSAGE X-Spam-Level: *** X-Archive-Number: 200608/84 X-Sequence-Number: 22628 --0-1039139022-1155014665=:84937 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hello, Simply looking from the point of recovering the deleted files, why not try something like http://recover.sourceforge.net/linux/ ? Obviously you Postgres error may have to be solved separately. Regards, -Thusitha Srinivas Iyyer 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 $ 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 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 ---------------------------(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 --0-1039139022-1155014665=:84937 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hello,

Simply looking from the point of recovering the deleted files, why not try something like http://recover.sourceforge.net/linux/ ?

Obviously you Postgres error may have to be solved separately.

Regards,
-Thusitha

Srinivas Iyyer <srini_iyyer_bio@yahoo.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
$ 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 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

---------------------------(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

--0-1039139022-1155014665=:84937--