473,573 Members | 2,627 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 3051
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
1869
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
1739
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...
1
1037
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
1782
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"...
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...
0
1202
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...
1
2183
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...
1
2182
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
2376
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
7668
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...
1
7735
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...
0
8035
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...
1
5556
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5257
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...
0
3698
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3694
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2166
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
0
992
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...

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.