473,699 Members | 2,181 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

contents of pg_database vanished..

Hi,

I'm having some problems with pg_database -system table. It lost all of
it's contents while database was running. It's actually still running but
I don't know what to do because I'm not sure if it will start up at all
after shutdown.

I noticed the problem while trying to use pg_dump:
tuner@xyzzy:~$ /usr/local/pgsql/bin/pg_dump -Ugalleria galleria
pg_dump: missing pg_database entry for database "galleria"

I could probably insert the missing row to pg_database but there are some
columns I'm not sure about. What are datlastsysoid, datvacuumxid and
datfrozenxid?

Btw, pg version is 7.4.1

Thanks..

|\__/|
( oo ) Kari Lavikka - tu***@bdb.fi - (050) 380 3808
__ooO( )Ooo_______ _____ ___ _ _ _ _ _ _ _
""

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 23 '05 #1
2 3056
Kari Lavikka <tu***@bdb.fi > writes:
I noticed the problem while trying to use pg_dump:
tuner@xyzzy:~$ /usr/local/pgsql/bin/pg_dump -Ugalleria galleria
pg_dump: missing pg_database entry for database "galleria"


Hm. The row must still be there, else you could not have got that far.
If you do "select * from pg_database", do you see all the rows you
expect? How about "select * from pg_database where datname = 'galleria'"?

If you see the row with an unqualified select but not with "where
datname =", then I'd bet on the index for pg_database.dat name being
corrupted. You should be able to fix this with REINDEX. Since
pg_database is a shared catalog, that will mean shutting down the
postmaster --- read the details in the REINDEX man page.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 23 '05 #2
Kari Lavikka <tu***@bdb.fi > writes:
I noticed the problem while trying to use pg_dump:
tuner@xyzzy:~$ /usr/local/pgsql/bin/pg_dump -Ugalleria galleria
pg_dump: missing pg_database entry for database "galleria"


Hm. The row must still be there, else you could not have got that far.
If you do "select * from pg_database", do you see all the rows you
expect? How about "select * from pg_database where datname = 'galleria'"?

If you see the row with an unqualified select but not with "where
datname =", then I'd bet on the index for pg_database.dat name being
corrupted. You should be able to fix this with REINDEX. Since
pg_database is a shared catalog, that will mean shutting down the
postmaster --- read the details in the REINDEX man page.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 23 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
1875
by: Rostov | last post by:
I've got a script where I'm trying to toggle the visibility of a div node by a click on an image that is the sibling of the div. So I've got this HTML: <div> <img src="RightPointingTriangle.gif" onclick="openclose(this);"> <span class="title">title</span> <div class="contents"> Hi. This is the contents.
2
1745
by: Paul | last post by:
I've searched this site for a few hours without a solution to my problem. Please help~ In short, the controls on my form have vanished. I can see nothing but a gray screen and grayed out navigator buttons on the lower left of the form, with no record count (118 records) to the right of the navigator buttons as I am used to seeing. The record source of this form is set to tbl_Employees. This table has 118 records as verified by opening...
1
1043
by: G. Völkl | last post by:
Hello, I have a real simple asp.net 2.0 page:: 1 button - 1 textfield If you press the button, the value of the textfield will be added to the arraylist: private x as new arraylist
6
1787
by: John Krueger | last post by:
The FolderBrowserDialog control in my toolbox has vanished! I did not delibratly remove it and it is just not there anymore. I tried to add it back to the toolbox but there isn't even a .NET component (or even a COM) available to select from in the "Customize Toolbox" window! I noticed there is a RESET button on the "Customize Toolbox" window but I have a number of custom controls it said it would delete. I was hesitant about that...
0
365
by: Kari Lavikka | last post by:
Hi, I'm having some problems with pg_database -system table. It lost all of it's contents while database was running. It's actually still running but I don't know what to do because I'm not sure if it will start up at all after shutdown. I noticed the problem while trying to use pg_dump: tuner@xyzzy:~$ /usr/local/pgsql/bin/pg_dump -Ugalleria galleria pg_dump: missing pg_database entry for database "galleria"
0
1209
by: David Garamond | last post by:
I'd like to save the list of users, groups, and databases regularly to a separate file (just in case). The output of pg_dumpall suffices for my need: ================================= DELETE FROM pg_shadow WHERE usesysid <> (SELECT datdba FROM pg_database WHERE datname = 'template0'); CREATE USER ... WITH SYSID ... PASSWORD '...' NOCREATEDB NOCREATEUSER; .... DELETE FROM pg_group;
1
2188
by: Beowulf | last post by:
I have a report laid out in Design View as shown at the end of this message. I have code that performs the following steps: 1. In main report's Report_Open(), DELETE any old rows in tblTOC for this username. 2. In main report's CategoryHeader_Format(), add a row to tblTOC with the current category name and the current page number. 3. In the table of contents subreport, Cancel if NoData event fires.
1
2189
by: ollymr | last post by:
This may be a stupid question -- but on one of the PC's in work, the little + signs for expanding a subdatasheet have vanished -- the subdatasheet option is also greyed out -- I can't find any difference betwenn the settings on this machine and on others -- anyone any ideas ? TIA OLIVER
2
2381
subashini Thiyagarajan
by: subashini Thiyagarajan | last post by:
My My Computer Icon has vanished from the desktop.now made some shortcut. how to bring back my original. while dragging other folder near this icon,my computer has disappeared.
0
8700
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8623
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
8931
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8892
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
5878
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4635
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3064
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2359
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2014
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.