Check the psql-hackers archive. I know this topic, how to do this, and
concerns about this was addressed 2-4 weeks ago.
-Original Message-
From: JT Kirkpatrick [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, April 13, 1999 12:51 PM
To: '[EMAIL PROTECTED]'
Ok, two days into this and I still can't find archives on how to increase
my tuple limit. Can anyone provide me with instructions on how to increase
my tuple limit?? 8k is not enough for our application - ok, enough for
90%, but not the 10%. I would like to at least double it. Maybe there a
I have Postgres running on a Sun sparc station under solaris 2.6 .
I did my compile and install as the user "postgres" and all is fine.
I want to install it on another computer as a different
owner than postgres. On that computer, I would also like to install
it in a different directory locati
> Is there a way in postgresql to find the current user status within a
> database like sp_who in Sybase?
>
If you do a ps command, you will see the postgres arguments show the
user, database, and command on most platforms.
--
Bruce Momjian| http://www.op.net/~candl
What version of PostgreSQL are you running? I thought this was only a
problem with relatively old releases...swore we fixed it around v6.1 or so
...
On Tue, 13 Apr 1999, Piotr Plizga wrote:
> In the data postgresgl directory ( $PGDATA/data ) there is file
> named : pg_time ( table pg_time ).
I am connecting to postgres 6.4.2 through microsoft access97 using an obdc
driver. I am converting some access files into postgres. I have a certain
field that contains NOTES (a text datatype), and some of them can contain
quite a bit of data! Well, as I am pulling the info into postgres, ce
In the data postgresgl directory ( $PGDATA/data ) there is file
named : pg_time ( table pg_time ). This file increases very fast.
How to administrate size of this file ? Stop postgres, remove file ?
What about consistency of database ( for instnce dates in DBA ) and
pg_time ?
