Frederic Massot wrote:
> Hi,
>
> How can I know the size of the database on a server Postgresql 7.3.4 ?
There is a chapter in the 7.4 docs called "Managing disk space".
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-1001
+
OK, well I may have some more useful information. The queries that blow up
seem, by and large, to be updates to the session table. Again, some of these
updates are big: I measured one at 50K today.
I suspected that insufficient vacuuming might be involved. I did a full
vacuum and got this for the
Hola Edgar:
Spanish is not my native language -- perhaps you can do about as well with
my English as I did reading your post :-)
What exactly happens? PHP doesn't build? Or doesn't even configure
correctly? What's the output from configure?
-- sgl
> From: "Edgar Cante" <[EMAIL PROTECTED]>
> Dat
kris pal <[EMAIL PROTECTED]> writes:
> I am not sure what the implications of completely deleting the
> 'Regression' database (I don't need the regression testing).
Is it named "Regression" with a capital R? If so, that's not the DB that
is made by the standard regression tests --- that is called
Andrew Farmer <[EMAIL PROTECTED]> writes:
> My question is, if I load the good dump into a clean database, and then
> find the underlying file that represents the broken table and copy it
> over the top of the broken table, am I likely to face any big problems?
This strikes me as a real good way
Thomas Wegner wrote:
> Hello,
>
> where i must place the .pgpass file under win32???
Uh, in 8.0 our .pgpass doesn't work yet. It will in beta2, but for now
you have to define a %HOME% variable and point that to the directory
with .pgpass. In beta2 it will use %USERPROFILE%.
--
Bruce Momjia
Hello,
I inherited a production Postgres database server which has a "Regression" database. The problem is that the size of the objects with in the Regression database are increasing so much that the database has grown into several GB. (Ex: pg_attribute and its index have grown into 2GB each and
I'm running a 7.3.4 on a RedHat 7.2 i686 box. I take daily backups of
my application's database, and last week it failed on one of the
tables. After some checking I found that the rest of the data was ok,
just a large number of tuples on one table were corrupt. I'm pretty sure
it's table corr
Hi,
How can I know the size of the database on a server Postgresql 7.3.4 ?
Regards.
--
==
| FREDERIC MASSOT |
| http://www.juliana-multimedia.com |
| mailto:[EMAIL PROTECTED] |
===Debian=GNU/
Hola necesito ayuda, estoy configurando mi php con soporte para postgresql
pero no logro que tenga soporte, mi strip de configuración es el siguiente
./configure --with-pgsql=/usr/local/pgsql --enable-dbase --enable-dbx
Me pueden ayudar...
Atte.
Edgar Cante
---(e
> From: Tom Lane <[EMAIL PROTECTED]>
> Date: Wed, 25 Aug 2004 15:16:32 -0400
> To: Steve Lane <[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED], Jamie Thomas <[EMAIL PROTECTED]>
> Subject: Re: [ADMIN] Odd query behavior [urgent, but long]
>
> Steve Lane <[EMAIL PROTECTED]> writes:
>> I have enabled pr
Steve Lane <[EMAIL PROTECTED]> writes:
> I have enabled pretty extensive query logging on the 7.1.3 instance. What I
> see is that certain queries take hideously long.
Tell us about foreign keys associated with the table being updated?
An UPDATE would fire triggers for both referencing and referen
Hello all:
I'm seeing some very odd query behavior on postgres 7.1.3. I know that's way
out of date, and I do have a plan in place to upgrade, but any immediate
help will be, well, very helpful.
I have a server running two instances of postgres: 7.1.3 and 7.4.3. Each
supports a different web appl
[EMAIL PROTECTED] ("andres barra") writes:
> hi, somebody can help me???
>
> I tried to create a new database but i can´t.
>
> psql: FATAL: Database "template1" does not exist in the system catalog.
> createdb: database creation failed
>
> I tried to make initdb in another directory and it shows m
14 matches
Mail list logo
