Yes I would like to see system tables, that is correct is there any
way to see all those tables.
For example in MySQL there is mysql database where you have all system
tables.
David Stanaway wrote:
On Tuesday, January 15, 2002, at 07:08 PM, Roman
Gavrilov wrote:
David Stanaway
wrote:
On Wed, 16 Jan 2002 00:42:52 -0500
Tom Lane <[EMAIL PROTECTED]> wrote:
> > VACUUM ANALYZE takes over an hour, and it's edging up by a couple
> > minutes per day.
>
> Care to try 7.2?
>
We will, but due to other issues we can't until things stabilize in
some other areas. Even then, how often i
Hmmm... I've installed PostgreSQL 7.1.3 with the Red Hat 7.2 installation
package, and everything works fine when connecting from localhost as the
postgres user, but when I try to connect via TCP I get the usual
"connectDBStart() -- ..." error suggesting that postmaster was started
without the "-i
Rasmus-
Try adding a line to pg_hba.conf for localhost specifically- I'd guess that
the request is coming in with that address rather than the local machine's
IP address.
use a line like this:
host all 127.0.0.1 255.0.0.0 trust
-Nick
---
"Nick Fankhauser" <[EMAIL PROTECTED]> writes:
> Try adding a line to pg_hba.conf for localhost specifically- I'd guess that
> the request is coming in with that address rather than the local machine's
> IP address.
Another possibility is that the connection request is being dropped on
the floor b
Mirek Hankus <[EMAIL PROTECTED]> writes:
> after some tables are copied error occures
> pg_dump: [tar archiver] could not write to tar member (wrote 1087,
> attempted 5365)
> pg_dump: *** aborted because of error
If you were writing on a disk file I'd say you've run out of disk space.
Since you
On Wednesday, January 16, 2002, at 07:09 PM, Roman Gavrilov wrote:
Yes I would like to see system tables, that is correct is there any way to see all those tables.
For example in MySQL there is mysql database where you have all system tables.
Please read the documentation. I have already told y
In Postgresql the data file are created and named in numeric format,
instead of text format.
I would like move some of big tables' files to another disk. But how
to find out which file belong to which table.
How to map the numeric files to its respective database objects?
Thanks in advance for an
On 16 Jan 2002, Srinivasa Rao Chava wrote:
> In Postgresql the data file are created and named in numeric format,
> instead of text format.
> I would like move some of big tables' files to another disk. But how
> to find out which file belong to which table.
> How to map the numeric files to its
