Orphaned files in the subdirectory of the database - Mailing list pgsql-novice

From David Alexander Krois
Subject Orphaned files in the subdirectory of the database
Date
Msg-id 0703C91BBDB67F4F980FD2FA2A56665C015E44C4@scan-data.s-can.local
Whole thread Raw
List pgsql-novice

I am working with a small psql database (<1GB) of version 8.3.3 on an industrial application. The OS is Windows xp embedded.

 

To keep the database in size, I schedule vacuum full and reindex in my program once a day. When I experienced disk size shortage, I found files of ~50MB in the subdirectory of my database (in \data\base\<oid of my db>\), which were (seemingly) not touched by vacuum/reindex (last modified date older then of the other files). I checked them with oid2name – they are not in the database.

 

Can anybody tell me, what these orphaned files are, where they come from, and how to proceed with them? Is it safe to delete them?

Thanks in advance,

David Krois


 

"YES WE SCAN !"

---------------------------------------------------------------------

NEW ! > pH-independent Chlorine Sensor <

---------------------------------------------------------------------

The chlori::lyser is a revolutionary pH- and flow- independent sensor for monitoring free chlorine or total chlorine. The digital sensor runs on RS485-Modbus, comes works-calibrated, and allows simple "plug & measure" functionality on all s::can terminals, panels, and software. It's internal buffer electrolyte allows pH-independent measurement between pH 4 to 10+, and it's 3 electrode system provides extremely stable readings, even at high fluctuations of pH, temperature and flow - with only a minimal requirement for maintenance.

plug&measure installation on an s::can panel is recommended. Combine it with our pH, conductivity in just one flow-cell and on one panel, or combine with one of our turbidity or spectral sensors on an extra panel,

and you will own the most cost efficient, compact and reliable solution for your water monitoring purpose available today, at practically zero running costs.

 

For more information please visit our website http://www.s-can.at or call your local dealer.

 

---------------------------------------------------------------------

s::can - intelligent, optical, online

 

scan Messtechnik GmbH

Brigittagasse 22-24

A-1200 Wien/Vienna

tel. +43 1 219 73 93 - 0

fax +43 1 219 73 93 - 12

http://www.s-can.at/

 

SALES@s-can.at Verkauf / Sales

ACCOUNTING@s-can.at Rechnungen / Invoicing

OFFICE@s-can.at Administration / Office

MARKETING@s-can.at Marketing

SUPPORT@s-can.at Technische Unterstuetzung / Technical Support

SERVICE@s-can.at Reparaturen / Repairs

PROCUREMENT@s-can.at Einkauf / Procurement

JOBS@s-can.at Bewerbungen / Jobs

LEGAL@s-can.at Rechtsfragen / Legal questions

 

Geschaeftsfuehrer/President: DI Andreas Weingartner

Firmenbuchnummer/Incorporation No: FN178880i

Gerichtsstand/Court of Jurisdiction: Wien/Vienna

 

---------------------------------------------------------------------

Haftungserklaerung / Disclaimer

Der Inhalt dieses E-Mails ist rein informativ und spiegelt nicht notwendigerweise den Standpunkt der Firma s::can Messtechnik GmbH wieder.

Sollten Sie eine verbindliche Auskunft benoetigen, wenden Sie sich bitte an LEGAL@s-can.at.

This electronic message does not necessarily reflect the official point of view of s::can Messtechnik GmbH and is considered as informal information.

To receive a formally binding answer we invite you to contact LEGAL@s-can.at.

---------------------------------------------------------------------


pgsql-novice by date:

Previous
From: Mathieu Dubois
Date:
Subject: Re: cast bytea to double precision[]
Next
From: Soviet
Date:
Subject: PostgreSQL on Amazon EC2/EBS