pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedDatabase disappeared
5+ messages / 4 participants
[nested] [flat]
* Database disappeared
@ 2005-07-27 09:49 Marco Rademeyer <mrademeyer@pnp.co.za>
2005-07-27 10:13 ` Re: Database disappeared Guido Barosio <gbarosio@gmail.com>
2005-07-27 14:23 ` Re: Database disappeared Tom Lane <tgl@sss.pgh.pa.us>
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 09:49 Database disappeared Marco Rademeyer <mrademeyer@pnp.co.za>
@ 2005-07-27 10:13 ` Guido Barosio <gbarosio@gmail.com>
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 09:49 Database disappeared Marco Rademeyer <mrademeyer@pnp.co.za>
@ 2005-07-27 14:23 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-07-27 15:12 ` Re: Database disappeared 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 09:49 Database disappeared Marco Rademeyer <mrademeyer@pnp.co.za>
2005-07-27 14:23 ` Re: Database disappeared Tom Lane <tgl@sss.pgh.pa.us>
@ 2005-07-27 15:12 ` Marco Rademeyer <mrademeyer@pnp.co.za>
2005-07-27 15:30 ` Re: Database disappeared Rainer J. H. Brandt <rjhb@bb-c.de>
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 09:49 Database disappeared Marco Rademeyer <mrademeyer@pnp.co.za>
2005-07-27 14:23 ` Re: Database disappeared Tom Lane <tgl@sss.pgh.pa.us>
2005-07-27 15:12 ` Re: Database disappeared Marco Rademeyer <mrademeyer@pnp.co.za>
@ 2005-07-27 15:30 ` Rainer J. H. Brandt <rjhb@bb-c.de>
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