Christopher Browne <[EMAIL PROTECTED]> writes:
> Not vacuuming for four months was a severe error, which means that you
> now need to run a really full maintenance cycle. At the next possible
> opportunity, you really need to do a VACUUM FULL on the whole
> database.
Dump, initdb, reload would ve
After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] ("S. C.") belched out:
> We have a postgres 7.4 database which never vacuum for 4 months. I try to
> vacuum one time. But my manager can't bear the low performance of website. So
> I had to kill the vacuum before it finished. Is it ok f
We have a postgres 7.4 database which never vacuum for 4 months. I try to
vacuum one time. But my manager can't bear the low performance of website. So
I had to kill the vacuum before it finished. Is it ok for a postgres 7.4
database never do vacuuming?
We have 10,000 trans every day. That wo
"Bender, Cheryl" <[EMAIL PROTECTED]> writes:
> I need to add an alternate db location for my 7.3.4 server (running on
> FreeBSD 5.2 Release)
> I thought I did everything according to the administrator's guide, but I
> fail at createdb.
How are you starting the postmaster, exactly?
A lot of people
I apologize if this answer is in the archives but my search did not
reveal it.
I need to add an alternate db location for my 7.3.4 server (running on
FreeBSD 5.2 Release)
I thought I did everything according to the administrator's guide, but I
fail at createdb.
I completed the following:
---
G u i d o B a r o s i o <[EMAIL PROTECTED]> writes:
> Ok, problem solved.
> A previous ALTER TABLE DROP COLUMN over this table was performed.
> By some reason, truncate didn't work then. Would like to know why...it does not
> seems to be a very frequent problem, due to the fact I only found one ch
No
habla Espanola!!!
Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
-Original Message-From: Christian Hache
[mailto:[EMAIL PROTECTED]Sent: Tuesday, September 07, 2004
7:07 AMTo: [EMAIL PROTECTED]Subject: [ADMIN]
Asignasr permisos a usuarios
Hola,
les comento mi
Hola,
les comento mi inquietud, ya instale PostgreSQL
7.4.3 en Red Hat y funciona tod bien, accedo a la BD a traves de access sobres
Windows desde otros workstation, lo que quiero hacer es otorgarle a casi todos
los usuaiors permisos de lectura sobre las tablas y a otros dos de lectura y
esc
Ok, problem solved.
A previous ALTER TABLE DROP COLUMN over this table was performed.
By some reason, truncate didn't work then. Would like to know why...it does not seems
to be a very frequent problem, due to the fact I only found one chat on the mailing
lists talking about this issue, and was
Sorry for crossposting, didn't know where to post.
Any hint/help on this?!
db_postgres1=# truncate ref_v2_drs_valid_product ;
ERROR: expected both swapped tables to have TOAST tables
I need to truncate this table, this is the first time I see this error.
Regards,
Guido
--
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Tue, 7 Sep 2004, H.J. Sanders wrote:
2 - 3 times a day we find in the logfile the message:
ERROR: RemoveFunction : function 't_r2_srl()' does not exist.
AFAIR, if DROP FUNCTION is called and it cannot find the function
specified, the error above
Hello list.
2 - 3 times a day we find in the logfile the message:
ERROR: RemoveFunction : function 't_r2_srl()' does not exist.
As I cannot find a function with this name in our coding, does anyone know
what it means or can give a hint where to look for.
Thanks
Henk Sanders
--
13 matches
Mail list logo
