By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,811 Members | 1,978 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,811 IT Pros & Developers. It's quick & easy.

Lost databases

P: n/a
Hi !

I'm in the ultimate state of dispair. Over the night some of my
databases just disapeared. But they did not dissaper totally. I can
still connect to them but I cannot dump them. When doing a "select *
from pg_database" I see only 2 databases I hardly ever use (they are
used once in a couple of mounths). Template0 and template1 are missing.
All the databases that I currently use dissapeared!

Please help me to restore the integrity of the system. I'm in dense fog
here :(

Liviu

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 23 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Let's start with the version of postgresql you're using.
Next, were you running VACUUM FULL regularly?

It sounds like XID wraparound to me, no idea how to solve that. Got
backups?

On Wed, Nov 10, 2004 at 12:56:33PM +0200, Liviu BURCUSEL wrote:
Hi !

I'm in the ultimate state of dispair. Over the night some of my
databases just disapeared. But they did not dissaper totally. I can
still connect to them but I cannot dump them. When doing a "select *
from pg_database" I see only 2 databases I hardly ever use (they are
used once in a couple of mounths). Template0 and template1 are missing.
All the databases that I currently use dissapeared!

Please help me to restore the integrity of the system. I'm in dense fog
here :(

Liviu

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html
--
Martijn van Oosterhout <kl*****@svana.org> http://svana.org/kleptog/ Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you can sue them.


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQFBkf3IY5Twig3Ge+YRAuzWAJ44gB4QSEDBDdcwihDDQ+ cHyzuvQACfSyil
eqEDU8yMWpXW4L9FX4qTEtU=
=s4QB
-----END PGP SIGNATURE-----

Nov 23 '05 #2

P: n/a
--- Liviu BURCUSEL <li***@voxline.ro> wrote:
Hi !

I'm in the ultimate state of dispair. Over the night
some of my
databases just disapeared. But they did not dissaper
totally. I can
still connect to them but I cannot dump them. When
doing a "select *
from pg_database" I see only 2 databases I hardly
ever use (they are
used once in a couple of mounths). Template0 and
template1 are missing.
All the databases that I currently use dissapeared!

Please help me to restore the integrity of the
system. I'm in dense fog
here :(
What Postgresql version is this? Your problem sounds
like "oid wraparound". There was a recent discussion
of this on the list; try the list archives to see what
was recommended in that case.

Liviu

---------------------------(end of
broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html



__________________________________
Do you Yahoo!?
Check out the new Yahoo! Front Page.
www.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 23 '05 #3

P: n/a
On Wed, 10 Nov 2004 08:11:01 -0800 (PST)
Jeff Eckermann <je************@yahoo.com> wrote:
--- Liviu BURCUSEL <li***@voxline.ro> wrote:
Hi !

I'm in the ultimate state of dispair. Over the night
some of my
databases just disapeared. But they did not dissaper
totally. I can
still connect to them but I cannot dump them. When
doing a "select *
from pg_database" I see only 2 databases I hardly
ever use (they are
used once in a couple of mounths). Template0 and
template1 are missing.
All the databases that I currently use dissapeared!

Please help me to restore the integrity of the
system. I'm in dense fog
here :(


What Postgresql version is this? Your problem sounds
like "oid wraparound". There was a recent discussion
of this on the list; try the list archives to see what
was recommended in that case.

The Postgresql version is 7.4.1

Thanks. I'll look in the archive.

Liviu

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 23 '05 #4

P: n/a
Martijn van Oosterhout wrote:
Let's start with the version of postgresql you're using.
Next, were you running VACUUM FULL regularly?

It sounds like XID wraparound to me, no idea how to solve that. Got
backups?

On Wed, Nov 10, 2004 at 12:56:33PM +0200, Liviu BURCUSEL wrote:
Hi !

I'm in the ultimate state of dispair. Over the night some of my
databases just disapeared. But they did not dissaper totally. I can
still connect to them but I cannot dump them. When doing a "select *
from pg_database" I see only 2 databases I hardly ever use (they are
used once in a couple of mounths). Template0 and template1 are missing.
All the databases that I currently use dissapeared!

Please help me to restore the integrity of the system. I'm in dense fog
here :(

Liviu

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html


Only VACUUM FULL solves XID wraparound problem? I mean VACUUM FULL locks
the entire table.

How can I test if I am close to XID wraparround?

Kostis
Nov 23 '05 #5

P: n/a
Look at the documentation here:

http://www.postgresql.org/docs/7.4/i...intenance.html

The upshot is that you should vacuum every table in the database at
least once every billion transaction. It doesn't have to be a VACUUM
FULL, just run VACUUM without specifying a table.

There's some info in there about how to work out when it is necessary.

Hope this helps,

On Tue, Nov 16, 2004 at 12:22:46PM +0200, Kostis Mentzelos wrote:
Only VACUUM FULL solves XID wraparound problem? I mean VACUUM FULL locks
the entire table.

How can I test if I am close to XID wraparround?

Kostis

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html
--
Martijn van Oosterhout <kl*****@svana.org> http://svana.org/kleptog/ Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you can sue them.


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQFBmzYoY5Twig3Ge+YRArxiAJ4sWdm5m9ndEfOGw8A/llXaDQ2cDQCfU8z9
qYE/OHWhBF3Jvy1uRoRQ0YY=
=ibwG
-----END PGP SIGNATURE-----

Nov 23 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.