Re: [GENERAL] vacuum error "left link changed unexpectedly"

rclick_i01 userclick_i02 userclick_i03 userclick_i04 userclick_i05 userclick_i06 userclick_i07 (7 rows) How do I proceed? How can I tell which files are involved? Regards, Ulrich -- Ulrich Wisser / System Developer RELEVANT TRAFFIC SWEDEN AB, Riddarg 17A, SE-114 57 Sthlm, Sweden Direct (+4

Re: [GENERAL] vacuum error "left link changed unexpectedly"

U 2.46s/6.06u sec elapsed 186.45 sec. ERROR: left link changed unexpectedly To me this looks as the index userclick_i01 is corrupted. I can not recompile PG, this is a production system. Is there anything else I could do to find out which file is affected? Ulrich Lane wrote: Ulrich Wisser &

Re: [GENERAL] vacuum error "left link changed unexpectedly"

ekend. Ulrich Ulrich Wisser <[EMAIL PROTECTED]> writes: vacuumdb: vacuuming of database "CLIX2" failed: ERROR: left link changed unexpectedly Hm, is this repeatable? When I wrote the code I thought it was a can't-happen case, which is why the error message is so terse

[GENERAL] vacuum error "left link changed unexpectedly"

d: ERROR: left link changed unexpectedly Any ideas what is wrong? Or how to fix it? Ulrich -- Ulrich Wisser / System Developer RELEVANT TRAFFIC SWEDEN AB, Riddarg 17A, SE-114 57 Sthlm, Sweden Direct (+46)86789755 || Cell (+46)704467893

[GENERAL] vacuum error

res 7.4.2 What does that mean? Can it be fixed? How? TIA Ulrich -- Ulrich Wisser / System Developer RELEVANT TRAFFIC SWEDEN AB, Riddarg 17A, SE-114 57 Sthlm, Sweden Direct (+46)86789755 || Cell (+46)704467893 || Fax (+46)86789769 _

Re: [GENERAL] Can't start PostgreSQL on Fedora Core3

ecurity in general). I just went with the default install and here I am. Ulrich -- Ulrich Wisser RELEVANT TRAFFIC SWEDEN AB, Riddarg 17A, SE-114 57 Sthlm, Sweden Direct (+46)86789755 || Cell (+46)704467893 || Fax (+46)86789769 ___

Re: [GENERAL] Can't start PostgreSQL on Fedora Core3

Hi Tom, sudo /sbin/restorecon -R /var/lib/pgsql worked like a charm! Thank you very much! Ulrich -- Ulrich Wisser RELEVANT TRAFFIC SWEDEN AB, Riddarg 17A, SE-114 57 Sthlm, Sweden Direct (+46)86789755 || Cell (+46)704467893 || Fax (+46)86789769

Re: [GENERAL] Can't start PostgreSQL on Fedora Core3

postgresql-pl-7.4.7-3.FC3.1 postgresql-server-7.4.7-3.FC3.1 postgresql-tcl-7.4.7-3.FC3.1 postgresql-libs-7.4.7-3.FC3.1 postgresql-docs-7.4.7-3.FC3.1 selinux-policy-targeted-1.17.30-2.85 up2date insists that these packages are all up to date. Ulrich Devrim GUNDUZ wrote: -BEGIN PGP SIGNED MESSAGE

[GENERAL] Can't start PostgreSQL on Fedora Core3

name=PG_VERSION dev=dm-1 ino=1255016 scontext=user_u:system_r:postgresql_t tcontext=root:object_r:var_lib_t tclass=file Any ideas are welcome! Thanks Ulrich ---(end of broadcast)--- TIP 6: Have you searched our list archives?

Re: [GENERAL] Blob Fields

Alexandre da Siva wrote: > Blobs is not Implemented on PostgreSQL, but I need to this field type on > PosgreSQL databases, how I can to use this? I'm using delphi... > > > ps: I readed PosgreSQL Manual and other lists and sites, but not get a > answer for my specific problem PostgreSQL has large

[GENERAL] Fedora postgresql not starting

Hi, I installed the latest postgresql packages on my Fedora Core 3 box. PG will not start, even initdb on a new directory fails. Any ideas what could be wrong? Any ideas how to debug? Thanks Ulrich ---(end of broadcast)--- TIP 6: Have you searched

Re: [GENERAL] Data entry - forms design or other APIs etc. - what is there?

layout of Your application where You can use data aware widgets for display and/or editing. Ulrich Schwab ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[GENERAL] Can't get planner to use multicolumn index on large table

Hi! I am trying to get postgres to use my index but it just doesn't. Please Help! It follows the table definition and a series of commands I thought would ensure usage of my index. CREATE TABLE data.question_result ( id bigserial PRIMARY KEY, trial_idbigint

[GENERAL] Foreign key locks

Hi, yes, I have been hit by the, now also known to me, foreign key locking "feature". And yes I did read that I should use "defer" to solve the problem. Question is: Do I have to recreate my schema with all foreign keys set to "initially de

Re: [GENERAL] Hebrew support -- please help !

should show UTF-8. Actually the browser to server communication is the hardest to ensure the right encoding is used. We have a database with Japanese, Hebrew, German, Swedish, French, Spanish and English content. Ulrich ---(end of broadcast)--- TI

[GENERAL] stone-age maintenance procedures ;-)

* frequently. A nightly "vacuum full analyze" frees about 250,000 rows on each of three tables. And yes I will change to 7.4 this week. TIA Ulrich -- Relevant Traffic AB, Riddargatan 10, 11435 Stockholm, Sweden Tel. +46-8

Re: [GENERAL] pg_dump in stand alone backend

Daniel Martini wrote: Hi, Citing Ulrich Wisser <[EMAIL PROTECTED]>: I would like to stop the postmaster every night and run vacuum pg_dump reindex in the stand alone backend. Vacuum and reindex seem to be quite easy, as I can setup a small script with both commands. But what about pg_dump

[GENERAL] pg_dump in stand alone backend

Hi, I would like to stop the postmaster every night and run vacuum pg_dump reindex in the stand alone backend. Vacuum and reindex seem to be quite easy, as I can setup a small script with both commands. But what about pg_dump. That seems "somewhat" more complex.

[GENERAL] Adding missing FROM-clause entry for table "customer"

Hi, what does that line from my logfile mean? Adding missing FROM-clause entry for table "customer" Would pg change my SQL queries on the fly? TIA /Ulrich ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an ind

Re: [GENERAL] insert waiting

Hi John, but how long is the exclusive lock taken? For the whole transaction? My jobs are quite big, and transactions usually take several minutes. I can not afford have all my other jobs stalled for that time. Ulrich I believe foreign key constraints take an exclusive lock on the parent. If you

Re: [GENERAL] Problems using count() with a join - trying to format

Hi Igor, wouldn't select g_name,count(*),sum(u_act) from g1 join users using(g_id) group by g_name do the job? /Ulrich Result can be obtained by: SELECT g1.g_name, (select count(*) from users u1 where g1.g_id = u1.g_id) as users_count, (select count(*) from users u2 where g1.g_id = u2.g_i

[GENERAL] insert waiting

the state "INSERT WAITING". I have some other insert/update process running, but not on the same table. I am absolutely sure, that my insert process is the only one working on that table. Can foreign keys block inserts? TIA Ulrich

Re: [GENERAL] heap errors - should I be worried?

Only yesterday after I used reindex on three tables did I see these problems. I will try to reindex the database tonight. Thanks Ulrich ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregi

[GENERAL] heap errors - should I be worried?

Recreate the index. Should these errors worry me? What do they mean? IS there anything I need to do / should have done? TIA /Ulrich ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] REINDEX problem

a session transscript below. How can I reindex the database? TIA /Ulrich -bash-2.05b$ postgres -D /var/lib/pgsql/data/ -O -P CLIX1 LOG: database system was shut down at 2004-08-12 22:55:29 CEST LOG: checkpoint record is at 11A/63A8F508 LOG: redo record is at 11A/63A8F508; undo record is at 0/0

[GENERAL] How to know which queries are to be optimised?

dynamic queries. I therefor can not determine what are the most common queries. I have used the postgresql logging ption before. Is there a tool to analyze the logfile for the most common and/or most time consuming queries? TIA Ulrich ---(end of broadcast

[GENERAL] Howto handle views/Rules Privileges

Hi! Situation two schemas: webviews: Contains a set of views with insert rules on them, accessed via a GUI. devconf: "Business logic", all the tables, functions, triggers that I want to restrict access to as far as possible.Preferably, I wouldn't even grant usage to the schema. I have a problem

[GENERAL] type conversion date <-> timestamp

Does that query include the 15th January as well as the 15th February? TIA Ulrich ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [GENERAL] [ADMIN] Restoring a Databases that features tserach2

tgreSQL) 7.4.1". I get the same error. When I do not update the dict-settings (setup_ge_ispell.sql) I can not even restore the other datas. Ulrich Andreas Schmitz wrote: How exactly is the dump created and the restore started ? On Thursday 22 April 2004 10:55, Fischer Ulrich wrote

[GENERAL] Restoring a Databases that features tserach2

oes anybody have some experience in this task? Thanks Ulrich -- Ulrich G. Fischer Dipl. Natw. ETH Center Aerodynamics Ruag Aerospace P.O. Box 301CH-6032 Emmen Tel. +41 41 268 23 53 Fax. +41 41 268

[GENERAL] tsearch2: restoring problem

setting connection There should be made an additional entry for my german dicts. But it isn't. Thanks for your help. Ulrich -- Ulrich G. Fischer Dipl. Natw. ETH Center Aerodynamics Ruag Aerospace P.O. Box 301CH-6032 Emme

[GENERAL] repl

From: Strategic Software SA Date: 10/23/98 10:01:40 AM Ref: UESA95770 Hello all Can PostgreSQL do replication? Thank You Ulrich Enslin [EMAIL PROTECTED]