I am now a little confused.
I ran the following with all but localhost connections disabled
vacuumdb --full --verbose -t casedocument -d tigris > vacfull.log 2>&1
which produced the following output:
INFO: vacuuming "public.casedocument"
INFO: "casedocument": found 0 removable, 39663 nonremov
On Apr 28, 2006, at 10:34 AM, Andy Shellam wrote:
My future plan for when my database grows larger, is with the use
of WAL logging – have a base backup taken on a Sunday morning (our
quietest time), ship this to the hot-standby once a week, and start
it off in a recovery mode (using my rolli
On Apr 28, 2006, at 10:23 AM, Andy Shellam wrote:
I've developed and am now testing a new "rolling-WAL" script, and have
noticed something a little peculiar with Postgres 8.1.3.
Note I intend to make this script public once testing has been
carried out -
if anyone is interested in testing
Hi Tom,Thanks for this. Do you know why Postgres was asking for 0001.history? Surely it would know by the presence of the backup_label file, and its contents that it needs to go straight for the xx.backup file, which should exist?What other files is Postgres likely to be asked for during
selecting pg_attributes for the casedocument table shows
there is column with the following attributes
24216115|"pg.dropped.2"|0|0|-1|2|0|-1|-1|f|"x"|"i"|f|f|
t|t|
I also noticed a few other tables have a similar "dropped" column.
Could this be the reference to the toast table th
Yes I suppose that was the problem...the harwdare failure was responsible
for the corrupted pg_attribute.
But I was suprise because I had a RAID 0/1 and the data got corrupted on
the second disk as well.
I am now trying to restore things from last backup and transaction logs.
Thanks all.
Regards
Hi
I was only out to do a quick test and used the binary
postgresql-8.1.x-x.zip - with installer that is. Now I don´t want it
on my windows machine. If I go to add and remove programs I find no way to
remove the installation, nor in the postgresql menu. Does anyone know
what's wrong or how to go a
Hi
I have huge problem.
Since 8.1 PostgreSQL don't make an OIDs by default.
I dumped my database from v7.4 and move into v8.1.
I didn't see any errors so it seems to be correct.
If I tried to use database I realise that database have not OID's.
Is any solution to add the OID's into this database a
First let me divulge the pertinent info:
database server:
-
Linux 2.6.8.1
postgres 8.1.0
webserver:
---
Linux 2.6.8.1
Apache 2.0.53, mod_jk, tomcat 5.0.28
jdbc-driver 8.1-404.jdbc3
libpq.so.4.1
We have Java client objects using jdbc, some JNI C code us
Help me ,please.
What difference between installation PGSQL on win-2000 and
win-2000-server or on WIN-XP ?
When i try to connect to installed PGSQL on win-xp or win-200-server
from other host of local net, i get the message :
Connection refused (0x274D/10061)
Is the server running on
Does anyone have a function or query that will loop through all the dbs in a
cluster, gather all the oids for every table, then call
pg_stat_get_db_blocks_fetched(oid)and pg_stat_get_db_blocks_hit(oid),
subtracting the latter from the former to get an estimate of kernel read()
calls? I would l
using (tomcat with a connection pool max=20, postgres with max
connections set to 100)
Sometimes we will look into the database using pgadmin3 and will want
to add a column to a table. The webapp is NOT in use at the time (its
running and has 5 connections in the pool) but no one is logged in and
> I was only out to do a quick test and used the binary
> postgresql-8.1.x-x.zip - with installer that is. Now I
> don´t want it on my windows machine. If I go to add and
> remove programs I find no way to remove the installation, nor
> in the postgresql menu. Does anyone know what's wrong or h
If you're running Windows XP Service Pack 2 - you'll need to either turn off the Windows Firewall completely (not recommended) or tell it to create an exception for port 5432.You can do this through Control Panel > Windows Firewall.This is the same on Windows Server 2003.Andy[EMAIL PROTECTED] wrote
Warren Little <[EMAIL PROTECTED]> writes:
> Could this be the reference to the toast table that is preventing the
> vacuum from deleting the toast data? And what purges "dropped" columns
> if not a full vacuum.
Actually, the way that toast references work is that they'll go away at
the next updat
[EMAIL PROTECTED] writes:
> Hi Tom,Thanks for this. Do you know why Postgres was asking for
> 0001.history? Surely it would know by the presence of the
> backup_label file, and its contents that it needs to go straight for the
> xx.backup file, which should exist?
It still needs to worry
16 matches
Mail list logo
