Received: from newmail.DKFZ-Heidelberg.DE (newmail.inet.dkfz-heidelberg.de [193.174.53.39]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g11EbYl77737 for ; Fri, 1 Feb 2002 09:37:34 -0500 (EST) (envelope-from d.richter@dkfz-heidelberg.de) Received: from perkeo.inet.dkfz-heidelberg.de (perkeo.inet.dkfz-heidelberg.de [193.174.61.66]) by newmail.DKFZ-Heidelberg.DE (8.9.3/8.9.3/DKFZ-8.9.3) with ESMTP id PAA21525 for ; Fri, 1 Feb 2002 15:37:37 +0100 (MET) Received: from dkfz.de (perkeo.inet.dkfz-heidelberg.de [193.174.61.66]) by perkeo.inet.dkfz-heidelberg.de (980427.SGI.8.8.8/DKFZ-8.6.4) with ESMTP id PAA19272 for ; Fri, 1 Feb 2002 15:36:04 +0100 (MET) Message-ID: <3C5AA7D4.5E63CA2B@dkfz.de> Date: Fri, 01 Feb 2002 15:36:04 +0100 From: "David M. Richter" Organization: German Cancer Research Center X-Mailer: Mozilla 4.7 [en] (X11; I; IRIX64 6.4 IP27) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: pg_vlock / vacuum Content-Type: multipart/mixed; boundary="------------E043571196FCBBBF04E312DB" X-Archive-Number: 200202/11 X-Sequence-Number: 6443 This is a multi-part message in MIME format. --------------E043571196FCBBBF04E312DB Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello! Ive got that message: psql -c vacuum NOTICE: LockRelease: locktable lookup failed, no lock ERROR: Can't create lock file. Is another vacuum cleaner running? If not, you may remove the pg_vlock file in the /usr/local/pgsql/data/base/chili directory Whats about this? We are using Suse Linux 7.3 with postgres 6.5.3. I cannot see a file named pg_vlock in that directory! Did anyone of You got the same message? Any experiences with pg_vlock? What is pg_vlock exactly doing? I will thankful appreciate every hint! DAvid --------------E043571196FCBBBF04E312DB Content-Type: text/x-vcard; charset=iso-8859-1; name="d.richter.vcf" Content-Transfer-Encoding: base64 Content-Description: Card for David M. Richter Content-Disposition: attachment; filename="d.richter.vcf" YmVnaW46dmNhcmQgCnVybDtxdW90ZWQtcHJpbnRhYmxlOmh0dHA6Ly9tYmku REtGWi1IZWlkZWxiZXJnLmRlLz0wRD0wQQpuOk0uIFJpY2h0ZXI7RGF2aWQK eC1tb3ppbGxhLWh0bWw6RkFMU0UKb3JnOkRldXRzY2hlcyBLcmVic2ZvcnNj aHVuZ3N6ZW50cnVtL0dlcm1hbiBDYW5jZXIgUmVzZWFyY2ggQ2VudGVyO0Rp dmlzaW9uIE1lZGl6aW5pc2NoZSB1bmQgQmlvbG9naXNjaGUgSW5mb3JtYXRp awp2ZXJzaW9uOjIuMQplbWFpbDtpbnRlcm5ldDpkLnJpY2h0ZXJAZGtmei1o ZWlkZWxiZXJnLmRlCmFkcjtxdW90ZWQtcHJpbnRhYmxlOjs7SW0gTmV1ZW5o ZWltZXIgRmVsZCAyODAgICAgICAgICAgICAgICAgICAgICB1cmw6IGh0dHA6 Ly9tYmkuREtGWi1IZWlkZWxiZXJnLmRlLz0wRD0wQUQtNjkxMjAgSGVpZGVs YmVyZywgR2VybWFueSAgICAgIDtIZWlkZWxiZXJnO0dlcm1hbnk7Owp4LW1v emlsbGEtY3B0OjstMTcwMjQKZm46RGF2aWQgTS4gUmljaHRlcgplbmQ6dmNh cmQK --------------E043571196FCBBBF04E312DB--