On Mon, Feb 09, 2004 at 08:57:13PM -0500, Christopher Browne ([EMAIL PROTECTED]) wrote:
> There are three fairly good books in printed form:
I would add to these:
PostgreSQL by Douglas & Douglas
Developer's Library
Published about a year ago.
--
Ken Dyke,
406.581.0495
-
Interesting discussions on IDE drives and their write caches.
I have a question...
You mentioned that you'd see the problem during a large number of
concurrent transactions. My question is, is this a necessary condition
for the database crashing when the plug was pulled, or did you need use
a
Hey All,
I'm running 7.4.1 and am having problem when my app starts loading up on the
database. I want to verify the data coming back from the queries is correct
from the server side (not application side), as then I'll be sure my app is
squirrelly (or the db is).
I don't see any options in pos
Log in as root, then "su - postgres" and type in "pg_autovacuum --help"
and see if you get a response from that. If so, the the autovacuum
daemon is there, and all you have to do to get it running it its basic
format is to run it with 'pg_autovacuum -D'.
On Tue, 10 Feb 2004, Jeremy Smith wrote
I actually had to install version 7.4.0 as there weren't any RPMs for 7.4.1
on Redhat 7.3. I am setting up some tables using phpPGadmin right now, and
there is a link for "vacuum" so maybe that's it..
Jeremy
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of s
You're welcome. Glad it all worked for you. If it's any consolation,
that's probably the hardest stuff you'll have to deal with in postgresql.
do the 7.4.1 rpms include the autovacuum daemon? If so, get it set up to
run and you shouldn't have to worry too much about holding postgresql's
han
Thanks so much Scott,
I followed this tutorial (linking it in case anyone has a similar troubles
in the future) on installing the RPMs:
http://www.lyris.com/lm_help/7.8/installing_postgresql_usin.html and it
worked out great!
Jeremy
-Original Message-
From: scott.marlowe [mailto:[EMAIL P
On Tue, 10 Feb 2004, Rajesh Kumar Mallah wrote:
>
>
> Greetings,
>
> Can tsearch V1 and V2 exist in the same database simultaneously?
> I have read in past that its difficult , but is it possible for the
> desperate?
quite peacefully, no problem
>
>
> regds
> mallah.
>
>
> --
On Tue, 10 Feb 2004, Peter Galbavy wrote:
> scott.marlowe wrote:
> > I don't know who you think you are, but I've physically tested the
> > stuff I'm talking about. Care to qualify what you mean?
>
> I would genuinely be interested in seeing the results and the methodology.
>
> > IDE drives (al
--On Tuesday, February 10, 2004 09:33:20 -0500 Robert Treat
<[EMAIL PROTECTED]> wrote:
On Sat, 2004-02-07 at 21:35, Palle Girgensohn wrote:
Hi,
We use postgresql for rather large databases. For a typical
installation, a pg_restore takes a couple of hours, at least (the
dumpfiles are usually 2-4
On Mon, 9 Feb 2004, Tom Lane wrote:
> "scott.marlowe" <[EMAIL PROTECTED]> writes:
> > That said we have a really HUGE (~200 drive) IDE storage array my web /
> > app server sits on top of. No clue if that thing will reliably work under
> > a database, and I'm in no hurry to find out.
>
> > B
"Jeremy Smith" <[EMAIL PROTECTED]> writes:
> From that I figured that I must need to update to a more current version of
> PostgreSQL. I downloaded the .tar.gz for 7.4.1 and followed the
> instructions, and installed it in my usr/local folder. Everything seemed
> to compile correctly. I didn't
Greetings,
Can tsearch V1 and V2 exist in the same database simultaneously?
I have read in past that its difficult , but is it possible for the
desperate?
regds
mallah.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Tue, 10 Feb 2004, Tom Lane wrote:
> "scott.marlowe" <[EMAIL PROTECTED]> writes:
> >> Unfortunately not --- at checkpoint time, the constraint goes the other
> >> way. We have to be sure all the data file updates are down to disk
> >> before we write a checkpoint record to the WAL log. So you
"scott.marlowe" <[EMAIL PROTECTED]> writes:
>> Unfortunately not --- at checkpoint time, the constraint goes the other
>> way. We have to be sure all the data file updates are down to disk
>> before we write a checkpoint record to the WAL log. So you can still
>> get screwed if the data-file driv
Hi Jeremy. Updating major versions (i.e. 7.2 to 7.3 or 7.4) requires you
to dump and restore your database.
This page explains it:
http://www.postgresql.org/docs/7.4/static/install-upgrading.html
If you still need some more help, feel free to ask, we're a pretty
responsive community.
-
Hi,
I wondered if there's other server log parser than
pgAnalyzer 2.0. My goal is to have a cron trying to match server log file
content with a list of regular expressions.
I wondered if it exists a ready-to-use list of
regular expressions adapted to posgreSQL server log file content.
Tha
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Ed Wong) wrote:
> I am an oracle dba and new to postgresql. Could you tell me what is
> the best postgres book out there to start with? I am looking for a
> book which is sort of a complete reference including some dba chapters
> as w
hola,
i was searching around but havent found waht im looking for: how can i kill
a user-connection of the listet connections in pg_stat_activitys ? i dont me
the postmaster-process.
thanks for helping me out,
markus
--
GMX ProMail (250 MB Mailbox, 50 FreeSMS, Virenschutz, 2,99 EUR/Monat...)
I am an oracle dba and new to postgresql. Could you tell me what is
the best postgres book out there to start with? I am looking for a
book which is sort of a complete reference including some dba chapters
as well.
Thanks in advance.
---(end of broadcast)
Hi,
I have owned a server for about a year, and apparently PostgreSQL 7.2 was
originally installed with Redhat. I made an attempt to set up a database on
the current Postgres setup, but when trying to set up my configure files in
WHM (Cpanel) I received the error:
Setting up Postgres Config...Do
On Sat, 2004-02-07 at 21:35, Palle Girgensohn wrote:
> Hi,
>
> We use postgresql for rather large databases. For a typical installation, a
> pg_restore takes a couple of hours, at least (the dumpfiles are usually 2-4
> gigabytes or so, including BLOBs). The machines are expected to be up 24/7,
On Tue, Feb 10, 2004 at 10:13:42 -0200,
Rodrigo Sakai <[EMAIL PROTECTED]> wrote:
>
> We are using PostgreSQL for a lot of distinct databases, and so the problem is,
> when occurs an error on just one database and we have to restart the postmaster
> process, it kills all the others databases
Hi,
What does "dump" refer to in this message? I've deleted any databases
i had.
apt-get install postgresql
Reading Package Lists... Done
Building Dependency Tree... Done
Suggested packages:
libpgperl libpgtcl postgresql-dev pgaccess python-pygresql python-psycopg
python-popy python-pgsql pgdo
Hi,
We are using PostgreSQL for a lot of distinct databases, and so the problem is, when
occurs an error on just one database and we have to restart the postmaster process, it
kills all the others databases that do not have problem, because there is only one
instance controling the databa
scott.marlowe wrote:
> I don't know who you think you are, but I've physically tested the
> stuff I'm talking about. Care to qualify what you mean?
I would genuinely be interested in seeing the results and the methodology.
> IDE drives (all the ones I've ever tested) LIE about their write
> cach
26 matches
Mail list logo
