Skip site navigation (1) Skip section navigation (2)

Re: Read db files directly

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mingzuo Shen <mzshen(at)yahoo(dot)com>
Cc: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Read db files directly
Date: 2006-07-28 20:03:34
Message-ID: 635.1154117014@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Mingzuo Shen <mzshen(at)yahoo(dot)com> writes:
> when I say psql shows nothing,
> I really mean "nothing".
> No error messages.

> Of course if I create a new db, psql -l shows my
> new db.

> psql -l
>        List of databases
>   Name  |  Owner   | Encoding
> --------+----------+-----------
>  testdb | postgres | SQL_ASCII
> (1 row)

This sounds like transaction XID wraparound in pg_database.  What
vacuuming policy have you been following?  It'd possibly work to
do "vacuum pg_database" to fix it, but if so you've got other
problems ...

			regards, tom lane

In response to

pgsql-admin by date

Next:From: Mingzuo ShenDate: 2006-07-28 20:28:16
Subject: Re: Read db files directly
Previous:From: Scott MarloweDate: 2006-07-28 19:58:42
Subject: Re: Read db files directly

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group