pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: pg_dump question -- did I delete my database -- please help -- urgent
2+ messages / 2 participants
[nested] [flat]

* Re: pg_dump question -- did I delete my database -- please help -- urgent
@ 2006-08-07 14:57 Srinivas Iyyer <srini_iyyer_bio@yahoo.com>
  2006-08-08 05:24 ` Re: pg_dump question -- did I delete my database -- please help -- urgent Thusitha Kodikara <kthusi@yahoo.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Srinivas Iyyer @ 2006-08-07 14:57 UTC (permalink / raw)
  To: Srinivas Iyyer <srini_iyyer_bio@yahoo.com>; pgsql-admin

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 



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: pg_dump question -- did I delete my database -- please help -- urgent
  2006-08-07 14:57 Re: pg_dump question -- did I delete my database -- please help -- urgent Srinivas Iyyer <srini_iyyer_bio@yahoo.com>
@ 2006-08-08 05:24 ` Thusitha Kodikara <kthusi@yahoo.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Thusitha Kodikara @ 2006-08-08 05:24 UTC (permalink / raw)
  To: Srinivas Iyyer <srini_iyyer_bio@yahoo.com>; pgsql-admin

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

^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2006-08-08 05:24 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-08-07 14:57 Re: pg_dump question -- did I delete my database -- please help -- urgent Srinivas Iyyer <srini_iyyer_bio@yahoo.com>
2006-08-08 05:24 ` Thusitha Kodikara <kthusi@yahoo.com>

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