Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 96ED22E3419 for ; Tue, 22 Jan 2008 12:06:59 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 26113-09 for ; Tue, 22 Jan 2008 12:05:31 -0400 (AST) Received: from mail.autorevenue.com (ip-208.178.167.106.gblx.net [208.178.167.106]) by postgresql.org (Postfix) with ESMTP id 9AD892E33A9 for ; Tue, 22 Jan 2008 12:05:25 -0400 (AST) Received: (qmail 17656 invoked from network); 22 Jan 2008 11:05:18 -0500 Received: from unknown (HELO dei26g028575) (msteben@10.10.1.20) by mail.autorevenue.com with SMTP; 22 Jan 2008 11:05:18 -0500 From: "Mark Steben" To: Subject: no entry on pg_database for a live database Date: Tue, 22 Jan 2008 11:05:02 -0500 Message-ID: <000101c85d10$8bab2c10$14010a0a@dei26g028575> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0002_01C85CE6.A2D52410" X-Mailer: Microsoft Office Outlook 11 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.3790.2992 Thread-Index: AchdEIuYEMQ/107jRQO2HzOxZ4/Pyw== X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/222 X-Sequence-Number: 27996 This is a multi-part message in MIME format. ------=_NextPart_000_0002_01C85CE6.A2D52410 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit I have a situation I thought was impossible. I have a live postgres database with 4 application tables. I can access it through PSQL. But there is no record of this database on the PG_DATABASE catalog table. And I therefore cannot perform a PG_DUMP backup because it errors with, You guessed it, 'No entry on pg_database' We haven't done backups As these are workfile temporary tables. But I've primed one of these Tables with permanent data for performance. I'm running version 7.4.5. Do I have to do a drop-recreate or is there Some other way around this? Any ideas would be appreciated Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480 Pleasant Street Suite B200 Lee, MA 01238 413-243-4800 Home Office 413-243-4809 Corporate Fax msteben @autorevenue.com Visit our new website at www.autorevenue.com IMPORTANT: The information contained in this e-mail message is confidential and is intended only for the named addressee(s). If the reader of this e-mail message is not the intended recipient (or the individual responsible for the delivery of this e-mail message to the intended recipient), please be advised that any re-use, dissemination, distribution or copying of this e-mail message is prohibited. If you have received this e-mail message in error, please reply to the sender that you have received this e-mail message in error and then delete it. Thank you. Come Visit Us at NADA! Booth #5735N February 9th - February 12th Moscone Center in San Francisco, CA ------=_NextPart_000_0002_01C85CE6.A2D52410 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I have a situation I thought was = impossible.

 

I have a live postgres database with 4 application tables.  = I can access it through PSQL.

But there is no record of this database on the PG_DATABASE = catalog table.

And I therefore cannot perform a PG_DUMP backup because it = errors with,

You guessed it, ‘No entry on pg_database’  We = haven’t done backups

As these are workfile temporary tables. But I’ve primed = one of these

Tables with permanent data for = performance.

 

I’m running version 7.4.5.   Do I have to do a drop-recreate or is there

Some other way around this?

 

Any ideas would be appreciated

 

Mark Steben

Senior Database Administrator
@utoRevenue™
A Dominion = Enterprises Company
480 = Pleasant Street
Suite = B200
Lee, MA 01238
413-243-4800 Home Office 
413-243-4809 Corporate Fax

msteben@autorevenue.com

Visit our = new website at
www.autorevenue.com

 

IMPORTANT: The information = contained in this e-mail message is confidential and is intended only for the named addressee(s). If the reader of this e-mail message is not the intended recipient (or the individual responsible for the delivery of this e-mail = message to the intended recipient), please be advised that any re-use, = dissemination, distribution or copying of this e-mail message is prohibited.  If = you have received this e-mail message in error, please reply to the sender that = you have received this e-mail message in error and then delete it.  Thank = you.

Come Visit Us at NADA! =  Booth #5735N
February 9th - February 12th
Moscone Center in San = Francisco, CA

 

------=_NextPart_000_0002_01C85CE6.A2D52410--