Dear Gurus:
My Server and me have had a very bad weekend, starting Friday afternoon.
I am running Debian Sarge, Postgresql 7.4.6 with linux kernel 2.6.8.
I am running a Postgresql backed application on a remote server. The system
has a system drive, on which the Postgresql database runs and ther
Milen A. Radev wrote:
Of course you were both right - we found one small brain-dead perl
script that "executed an infinite loop in under 2 seconds" and in every
loop "pings" the DB using an empty query (well that's the implementation
in the perl pgsql driver). The responsible were punished.
So, whe
Mitchell Laks <[EMAIL PROTECTED]> writes:
> Well, the raid1 failed (or is failing - or is trying its hardest to fail, not
> clear yet...). This should not have affected the Postgresql database as it is
> safely on a separate drive.
Try turning off the power, physically disconnecting the raid1, an
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I have installed a script that executes vacuumdb for all DBs in my
cluster (run by cron every night):
BEGIN
#!/bin/sh
# cron script to vacuum pgsql databases
#
PG_VACUUM_LOG=/var/log/pg_vacuum
echo St
I have completed installation of PostgreSQL (8.0.1) on Windows XP SP1.
I must say that I'm newbie in postgres world.
I've readed manual and changed conf file:
#---
# RUNTIME STATISTICS
#
Hello
I try to restore
a dump of a PostgreSQL 7.4 db into PostgrSQL 8.0.1 on Windows XP SP1 When using pgadmin III it asks for a *.backup file which I do not
have and the OK button is greyed out when selecting the dump file - thus this
does not work.
When using psql as I do it on Linux (Sus
I made a mistake, I droped the template0 database...
How can I recreate it?
Thanks
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
[EMAIL PROTECTED] ("Subbiah, Stalin") writes:
> I created schema name "foo_schema" different from user name "foo".
> However, when I created the schema, I had specified authorization set to
> foo user.
>
> Does that mean, if the owner of the schema and schema name are
> different, then only way,
=?UTF-8?Q?Pawe=C5=82_Boi=C5=84ski?= <[EMAIL PROTECTED]> writes:
> The question is why I don't see any changes in statistics ? (both in
> pgadmin and by quering for example "pg_statio_user_tables" )
Did you remember to restart the postmaster after changing the config
file? I think some of these ar
Guys,
I need some help to decide when i should reindex the indexes in the table.
Postgresql 7.4.5 and linux O.S.
Below is the results of vacuum analyze verbose on the table
INFO: vacuuming "public.rpt_metrics"
INFO: index "rpt_metrics_date_network_advertiser" now contains
102960776 row versions
Hi guys,
I have been browsing around and reading up on PostgreSQL
performance to try and tweak our system at the office, as its performance is
not that great.
Many people say that PG is a great DB, and I know that our
problems are purely a setup issue.
After a complete server re
Gourish Singbal <[EMAIL PROTECTED]> writes:
> I need some help to decide when i should reindex the indexes in the table.
> ...
> When should i ideally reindex this table ?.
> (once in a month, weeklyetc)
It seems to need reindexing now, but that tells us nothing about how
often you might need
Thank you Tom and Frank!
As usual you gurus were 100% on target.
I had a raid1 failure on my data drive which caused the /var partition on my
system drive to fill with kernel messages in /var/log/messages from the
failing /dev/hdg1 drive.
Therefore, when I logged in remotely and tried to work
13 matches
Mail list logo
