Gary Stainburn wrote:
> At the risk of starting to stray OT for this list, how do you go about
> installing SRPMS - I've never done anything like that before.
An easier way to do this would be to download the postgresql tarball.
Download the following:
http://www.postgresql.org/ftpsite/v7.1.2
I have a database that has two tables. One of the tables gets changed
very often. (like every 5 minutes). The values that where in the table
are replaced with a new set of values with new unique keys. Now, I vacuum
these tables fairly often, but the pkey files for these tables never seem
to g
pg_hba.confg?
My Postgresql is unable to read the one which i have.
Many thanks
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
dear all,
I am developing a client application with C++ Builder 3 to access a
Database designed with PostgreSQL 7.0.4 using a BDE alias through the ODBC
driver.
I would like to have a form where I can add users to my users table of my
database and also create the corresponding entry to the pos
On Monday 13 August 2001 22:28, Alan Gutierrez wrote:
> Gary Stainburn wrote:
> > At the risk of starting to stray OT for this list, how do you go about
> > installing SRPMS - I've never done anything like that before.
> An easier way to do this would be to download the postgresql tarball.
Nop
On Wednesday 08 August 2001 12:15, Gary Stainburn wrote:
> I downloaded the postgresql-7.1.2 rpms and tried to install them - I had 20
> lines of failed dependancies. I downloaded the RPMS for those, and ended
> up with 70+ lines of failed dependancies.
The current PGDG RPMset will work just fi
Dear All,
I'm having some problems using embedded SQL with Unicode. My client and
server both are UNICODE. I have a bit of code which is :-
wchar_t * name;
How do I express name such that it will work with the embedded SQL
preprocessor, BTW I'm on the latest postgres builds ?
S
[EMAIL PROTECTED] writes:
> I have a database that has two tables. One of the tables gets changed
> very often. (like every 5 minutes). The values that where in the table
> are replaced with a new set of values with new unique keys. Now, I vacuum
> these tables fairly often, but the pkey files
It's probably beyond me, but other than the obvious (stopping and restarting
postmaster) have you tried a database dump and restore? Did that fix the problem? It
should, at least, re-create all the indexes...
--- Allan.
Ariunbold Gerelt-Od wrote:
> Hi guys,
> Suddenly, the processes for
Thanks for that Alan,
However, as the box I was putting it onto is a new one, I am making an effort
to stick to RPM's this time, as much as an academic exerciser as anything
else.
I actually found it quite easy to download the SRPM and build all the binary
RPMs from it. It also means that if
[EMAIL PROTECTED] writes:
> I tried switching
> to PostgreSQL 7.1 when it first came out, but it now handles ansynchronous
> notification differently to the point where my old code doesn't work
> anymore.
Uh ... what? I don't recall that we changed NOTIFY behavior in 7.1.
There's certainly no o
> Yeah, VACUUM doesn't shrink indexes presently (it's on the TODO
> list...).
>
> > PostgreSQL version 7.0.3 running under Linux.
>
> You could try REINDEX to rebuild the indexes, but I'd recommend updating
> to 7.1.2 (or soon, 7.1.3) first. I don't recall whether REINDEX is
> available/trustwo
Greetings. I'm looking into to doing some detailed performance
monitoring of a Postgres instance (as a general project, not for a
specific setup). I was inspired to research it after spending some
time setting up the same for Oracle, which has some built-in handling
for MIBs (generic and Oracle-
13 matches
Mail list logo
