pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Database disappeared
5+ messages / 4 participants
[nested] [flat]

* Database disappeared
@ 2005-07-27 09:49  Marco Rademeyer <mrademeyer@pnp.co.za>
  0 siblings, 2 replies; 5+ messages in thread

From: Marco Rademeyer @ 2005-07-27 09:49 UTC (permalink / raw)
  To: pgsql-admin


Hi 

I have a very strange problem. 
I was importing about 5 gigs of data last night. 

When I got in this morning the script had completed. But my database has
disappeared. I login to the databases , but all the tables are gone. 

in the /var/lib/postgresql/data/base/17164/ . The data is still there. 

When logged into the databases 

\d  gives me the following output:
 'no relations found '

Is there any way that I can put these relations back? 
Any help would be great.

Regards
Marco Rademeyer 


Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? 
If you don't have web access, the disclaimer can be mailed to you on request. 
Disclaimer requests to be sent to it-security@pnp.co.za 
 



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

* Re: Database disappeared
@ 2005-07-27 10:13  Guido Barosio <gbarosio@gmail.com>
  parent: Marco Rademeyer <mrademeyer@pnp.co.za>
  1 sibling, 0 replies; 5+ messages in thread

From: Guido Barosio @ 2005-07-27 10:13 UTC (permalink / raw)
  To: Marco Rademeyer <mrademeyer@pnp.co.za>; +Cc: pgsql-admin

You mention:
 script has ended -> so, it was a piece of sql sentences, no drop at any 
time?
 databases disappeared -> the db is not any more, or the relations are not 
more there?
 Could this script create a schema and moved everything on this schema?
 try postgresql-shell # \dn
 That should list your schemas.
 On 7/27/05, Marco Rademeyer <mrademeyer@pnp.co.za> wrote: 
> 
> 
> Hi
> 
> I have a very strange problem.
> I was importing about 5 gigs of data last night.
> 
> When I got in this morning the script had completed. But my database has
> disappeared. I login to the databases , but all the tables are gone.
> 
> in the /var/lib/postgresql/data/base/17164/ . The data is still there.
> 
> When logged into the databases
> 
> \d gives me the following output:
> 'no relations found '
> 
> Is there any way that I can put these relations back?
> Any help would be great.
> 
> Regards
> Marco Rademeyer
> 
> 
> Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093
> ?
> If you don't have web access, the disclaimer can be mailed to you on 
> request.
> Disclaimer requests to be sent to it-security@pnp.co.za
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
> 



-- 
"Adopting the position that you are smarter than an automatic
optimization algorithm is generally a good way to achieve less
performance, not more" - Tom Lane.

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

* Re: Database disappeared
@ 2005-07-27 14:23  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Marco Rademeyer <mrademeyer@pnp.co.za>
  1 sibling, 1 reply; 5+ messages in thread

From: Tom Lane @ 2005-07-27 14:23 UTC (permalink / raw)
  To: Marco Rademeyer <mrademeyer@pnp.co.za>; +Cc: pgsql-admin

Marco Rademeyer <mrademeyer@pnp.co.za> writes:
> I have a very strange problem. 
> I was importing about 5 gigs of data last night. 

> When I got in this morning the script had completed. But my database has
> disappeared. I login to the databases , but all the tables are gone. 

Sounds a whole lot like transaction ID wraparound :-(.  How long ago did
you last do a database-wide VACUUM?

			regards, tom lane



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

* Re: Database disappeared
@ 2005-07-27 15:12  Marco Rademeyer <mrademeyer@pnp.co.za>
  parent: Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 5+ messages in thread

From: Marco Rademeyer @ 2005-07-27 15:12 UTC (permalink / raw)
  To: pgsql-admin


hi All

I seems to be that the script that I was running to do the VACUUM FULL
on the databases was not doing its job. 

I have run a VACUUM FREEZ on the databases. This has brought back some
of the Databases. I am waiting for it to complete. 

I was getting warparound errors. When I tried to do a vacuum. 

Thanks for the VACUUM idea. I thought it was happening every Sunday. 

Thanks for the help. 

Regards
Marco 

On Wed, 2005-07-27 at 10:23 -0400, Tom Lane wrote:
> Marco Rademeyer <mrademeyer@pnp.co.za> writes:
> > I have a very strange problem. 
> > I was importing about 5 gigs of data last night. 
> 
> > When I got in this morning the script had completed. But my database has
> > disappeared. I login to the databases , but all the tables are gone. 
> 
> Sounds a whole lot like transaction ID wraparound :-(.  How long ago did
> you last do a database-wide VACUUM?
> 
> 			regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
> 
> !DSPAM:42e79f14190891268238603!
> 
> 
> Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? 
> If you don't have web access, the disclaimer can be mailed to you on request. 
> Disclaimer requests to be sent to it-security@pnp.co.za 
> 


Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? 
If you don't have web access, the disclaimer can be mailed to you on request. 
Disclaimer requests to be sent to it-security@pnp.co.za 
 



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

* Re: Database disappeared
@ 2005-07-27 15:30  Rainer J. H. Brandt <rjhb@bb-c.de>
  parent: Marco Rademeyer <mrademeyer@pnp.co.za>
  0 siblings, 0 replies; 5+ messages in thread

From: Rainer J. H. Brandt @ 2005-07-27 15:30 UTC (permalink / raw)
  To: pgsql-admin

Hello everybody,

sorry if you consider this off-topic, but (despite the serious
situation, sorry again) I thought this was funny:

Marco wrote
> I was getting warparound errors. When I tried to do a vacuum.

after Tom had written
>> Sounds a whole lot like transaction ID wraparound :-(.  How long ago did
>> you last do a database-wide VACUUM?

Perhaps a warparound might be a nice solution for a wraparound problem.

Greetings, Rainer
----------------------------------------------------------------------
Rainer J. H. Brandt                            email:     rjhb@bb-c.de
Brandt & Brandt Computer GmbH                  web:        www.bb-c.de
Kamberg 111                                    phone:  +49 2448 919126
D 53940 Hellenthal                             mobile: +49 172 9593205





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


end of thread, other threads:[~2005-07-27 15:30 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-07-27 09:49 Database disappeared Marco Rademeyer <mrademeyer@pnp.co.za>
2005-07-27 10:13 ` Guido Barosio <gbarosio@gmail.com>
2005-07-27 14:23 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-07-27 15:12   ` Marco Rademeyer <mrademeyer@pnp.co.za>
2005-07-27 15:30     ` Rainer J. H. Brandt <rjhb@bb-c.de>

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