[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
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
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
> 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
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
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/
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
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
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
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
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
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
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
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
+
14 matches
Mail list logo
