Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TGHnE-00070G-IA for pgsql-admin@postgresql.org; Mon, 24 Sep 2012 23:10:25 +0000 Received: from nm14-vm4.bullet.mail.ne1.yahoo.com ([98.138.91.174]) by makus.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1TGHnB-0003Gk-LM for pgsql-admin@postgresql.org; Mon, 24 Sep 2012 23:10:23 +0000 Received: from [98.138.90.55] by nm14.bullet.mail.ne1.yahoo.com with NNFMP; 24 Sep 2012 23:10:19 -0000 Received: from [98.138.226.169] by tm8.bullet.mail.ne1.yahoo.com with NNFMP; 24 Sep 2012 23:10:19 -0000 Received: from [127.0.0.1] by omp1070.mail.ne1.yahoo.com with NNFMP; 24 Sep 2012 23:10:19 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 649265.58169.bm@omp1070.mail.ne1.yahoo.com Received: (qmail 17885 invoked by uid 60001); 24 Sep 2012 23:10:19 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1348528219; bh=JLSlSNfAFQtix6+rK5OGcqelP0tNNwkto4yzO7qRrug=; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=f12MgRqy65C1AgbywMQKhgWaysVWA99O9Ceuyj/Cv74evZSID4rlINpV9vuA5r/fcBbfHKfI3G6roq4xEK3fPShE8CQjp/Y+tQ3YEkC3QdlVtU+MC5Yp7RlXKMFQ3LWCVqfQw/lhF+33Zj+hOGAFB6RqPOvSlf7zJ+jpIQeXkUE= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=X39y9fOePqKlcPa+UpsS/Y0woYCsXLhRPXpQgk3c1vBBZhGr/tNyOaN6DcbXNAhabZRazZ9A1rU9L/VpQ6fSLfEjrjSZOMqAIF0gw3Ea6JgETUq7QhMdKNlGDkLHGtCtUl+Jfu3ez4G6hcL6GHXcfrxgzbyfwx7O/EBKoQk1va8=; X-YMail-OSG: PA1RwpkVM1m_mI6HlV0vwDE8SqFvAcSP.YLNYwCseqQMTTI fwa_hila7XDr26Wv5zE2zhAHxZWddOgQBYPC8nLF6FKteH0Cuw0BalxQQwyR JFMdqgQMx46Tm1Fp_KCIbPSp6BlkSRrTdXw9cW1Oim.XzzTjiLD7mzEScO3A YPO_nfGPYm2hevtKM3syxmOOoFHCy7ITjo4jedT0EI.ougwT9kMhwPeLuYbP Szqh2gRbrlH7if5vqbSM0dytWEcohiETj3OQD2JsR9nvWf2IiG_MepVDvA1_ 2v6Yp.qt8WoZYe.4.ZubGxKLe9RztzlqH7XqcJUu4tz6jKYrSMItUqjDPunK 4dTPLuA6FL2.pDqEaZzYLieFYOc6piO0_IB_YLby93U7ExQC_6v4eC2CBkr_ SeZMVT93PXUO8egluFwZVGKp7I5Q..6WqyDpUJzVx314cWBae6q7ttlrDMFv 2WZ0Hg_tJAhaG14Kz06lVc7XcayhcVvpMfEqqQjczYOpbaBTCRgRhc_QTnTC kgVMtQcI7JNHqUhzUYulzFwQf5BI_0VwhRoZgE3QwYBFXjbrids7d Received: from [98.210.146.78] by web125905.mail.ne1.yahoo.com via HTTP; Mon, 24 Sep 2012 16:10:19 PDT X-Mailer: YahooMailWebService/0.8.121.434 Message-ID: <1348528219.13794.YahooMailNeo@web125905.mail.ne1.yahoo.com> Date: Mon, 24 Sep 2012 16:10:19 -0700 (PDT) From: Greg Williamson Reply-To: Greg Williamson Subject: file descriptors still open to deleted files To: "pgsql-admin@postgresql.org" MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: -0.3 (/) X-Archive-Number: 201209/143 X-Sequence-Number: 40084 On a postgres 9.1.3 system we are seeing repeated problems with vanishng di= sk space. The problem is resolved by restarting the postgres cluster.=0A=0A= This cluster is replicated to another server (which does not show the same = problem). It has several databases -- one very low activity currently ( all= tables unlogged), one with lots of inserts and some reads (all logged), an= d one database which is created hourly and then dropped after making a copy= .=0A=0AIt is this later operation that I suspect is causing the issues sinc= e we did not see this before this database was made conjured up. =A0=0A=0AO= ur monitors show that from inside postgres the database size regularly rise= s as the transient database is created and drops again when the database is= dropped. But monitors that look as disk space as reported by system utilit= ies see a steadily dropping amount of disk space.=0A=0AI can post further i= nformation if you give me some pointers as to what to look for.=0A=0AThanks= !=0A=0AGreg Williamson=0A=0Apostgres(at)db11:5432=3D# select version();=0A= =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0= =A0 =A0 =A0 =A0 =A0 =A0 =A0version =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0= =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=0A--------= ---------------------------------------------------------------------------= ---------------------------=0A=A0PostgreSQL 9.1.3 on x86_64-unknown-linux-g= nu, compiled by gcc-4.4.real (Ubuntu 4.4.3-4ubuntu5) 4.4.3, 64-bit=0A(1 row= )=0A=0ASays one of our sysads:=0A"These are single disk systems. single non= -raid sata. Using xfs as the filesystem like the rest of the dbs."=A0=0A=0A= The gritty details of before and after as seen through a couple of commands= .=0A=0ABEFORE=0A$ =A0df -h=0AFilesystem =A0 =A0 =A0 =A0 =A0 =A0Size =A0Used= Avail Use% Mounted on=0A/dev/sda3 =A0 =A0 =A0 =A0 =A0 =A0 =A067G =A0 60G = =A07.4G =A089% /=0Anone =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A07.9G =A0180K =A0= 7.9G =A0 1% /dev=0Anone =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A07.9G =A0 =A0 0 = =A07.9G =A0 0% /dev/shm=0Anone =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A07.9G =A0 = 56K =A07.9G =A0 1% /var/run=0Anone =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A07.9G = =A0 =A0 0 =A07.9G =A0 0% /var/lock=0Anone =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A07.9G =A0 =A0 0 =A07.9G =A0 0% /lib/init/rw=0A/dev/sda1 =A0 =A0 =A0 =A0 = =A0 =A0 184M =A0 31M =A0144M =A018% /boot=0A=0AAFTER:=0Apostgres@db11:~$ df= -h=0AFilesystem =A0 =A0 =A0 =A0 =A0 =A0Size =A0Used Avail Use% Mounted on= =0A/dev/sda3 =A0 =A0 =A0 =A0 =A0 =A0 =A067G =A0 38G =A0 30G =A057% /=0Anone= =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A07.9G =A0180K =A07.9G =A0 1% /dev=0Anone= =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A07.9G =A0 =A0 0 =A07.9G =A0 0% /dev/shm= =0Anone =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A07.9G =A0 56K =A07.9G =A0 1% /var= /run=0Anone =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A07.9G =A0 =A0 0 =A07.9G =A0 0= % /var/lock=0Anone =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A07.9G =A0 =A0 0 =A07.9= G =A0 0% /lib/init/rw=0A/dev/sda1 =A0 =A0 =A0 =A0 =A0 =A0 184M =A0 31M =A01= 44M =A018% /boot=0A=0ABEFORE:=0Apostgres@db11:~$ du -h /var/lib/postgresql/= 9.1/main=0A480K/var/lib/postgresql/9.1/main/global=0A28K/var/lib/postgresql= /9.1/main/pg_xlog/archive_status=0A8.0G/var/lib/postgresql/9.1/main/pg_xlog= =0A47M/var/lib/postgresql/9.1/main/pg_clog=0A8.0K/var/lib/postgresql/9.1/ma= in/pg_notify=0A0/var/lib/postgresql/9.1/main/pg_serial=0A16K/var/lib/postgr= esql/9.1/main/pg_subtrans=0A0/var/lib/postgresql/9.1/main/pg_twophase=0A8.0= K/var/lib/postgresql/9.1/main/pg_multixact/members=0A8.0K/var/lib/postgresq= l/9.1/main/pg_multixact/offsets=0A16K/var/lib/postgresql/9.1/main/pg_multix= act=0A5.9M/var/lib/postgresql/9.1/main/base/1=0A5.9M/var/lib/postgresql/9.1= /main/base/11938=0A5.9M/var/lib/postgresql/9.1/main/base/11946=0A5.0G/var/l= ib/postgresql/9.1/main/base/16387=0A5.9M/var/lib/postgresql/9.1/main/base/1= 6392=0A5.9M/var/lib/postgresql/9.1/main/base/16402=0A0/var/lib/postgresql/9= .1/main/base/pgsql_tmp=0A520M/var/lib/postgresql/9.1/main/base/16424=0A5.9M= /var/lib/postgresql/9.1/main/base/16449=0A1.4G/var/lib/postgresql/9.1/main/= base/1418400=0A6.1M/var/lib/postgresql/9.1/main/base/2047839=0A6.8G/var/lib= /postgresql/9.1/main/base=0A0/var/lib/postgresql/9.1/main/pg_tblspc=0A216K/= var/lib/postgresql/9.1/main/pg_stat_tmp=0A15G/var/lib/postgresql/9.1/main= =0A=0AAFTER:=0Apostgres@db11:~$ du -h /var/lib/postgresql/9.1/main=0A480K/v= ar/lib/postgresql/9.1/main/global=0A=0A28K/var/lib/postgresql/9.1/main/pg_x= log/archive_status=0A8.0G/var/lib/postgresql/9.1/main/pg_xlog=0A47M/var/lib= /postgresql/9.1/main/pg_clog=0A8.0K/var/lib/postgresql/9.1/main/pg_notify= =0A0/var/lib/postgresql/9.1/main/pg_serial=0A64K/var/lib/postgresql/9.1/mai= n/pg_subtrans=0A0/var/lib/postgresql/9.1/main/pg_twophase=0A8.0K/var/lib/po= stgresql/9.1/main/pg_multixact/members=0A8.0K/var/lib/postgresql/9.1/main/p= g_multixact/offsets=0A16K/var/lib/postgresql/9.1/main/pg_multixact=0A5.9M/v= ar/lib/postgresql/9.1/main/base/1=0A5.9M/var/lib/postgresql/9.1/main/base/1= 1938=0A5.9M/var/lib/postgresql/9.1/main/base/11946=0A5.0G/var/lib/postgresq= l/9.1/main/base/16387=0A5.9M/var/lib/postgresql/9.1/main/base/16392=0A5.9M/= var/lib/postgresql/9.1/main/base/16402=0A0/var/lib/postgresql/9.1/main/base= /pgsql_tmp=0A520M/var/lib/postgresql/9.1/main/base/16424=0A5.9M/var/lib/pos= tgresql/9.1/main/base/16449=0A1.4G/var/lib/postgresql/9.1/main/base/1418400= =0A6.1M/var/lib/postgresql/9.1/main/base/2047839=0A316M/var/lib/postgresql/= 9.1/main/base/2297189=0A7.1G/var/lib/postgresql/9.1/main/base=0A0/var/lib/p= ostgresql/9.1/main/pg_tblspc=0A328K/var/lib/postgresql/9.1/main/pg_stat_tmp= =0A=0ABEFORE:=0A$ sudo lsof -p 31356 -a | more=0ACOMMAND =A0 =A0PID =A0 =A0= USER =A0 FD =A0 TYPE =A0 =A0 =A0 =A0 =A0 =A0 DEVICE SIZE/OFF =A0 =A0 =A0NO= DE NAME=0Apostgres 31356 postgres =A0cwd =A0 =A0DIR =A0 =A0 =A0 =A0 =A0 =A0= =A0 =A08,3 =A0 =A0 4096 269834294 /var/lib/postgresql/9.1/main=0Apostgres = 31356 postgres =A0rtd =A0 =A0DIR =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,3 =A0 =A0= 4096 =A0 =A0 =A0 128 /=0Apostgres 31356 postgres =A0txt =A0 =A0REG =A0 =A0= =A0 =A0 =A0 =A0 =A0 =A08,3 =A05430480 =A037149754 /usr/lib/postgresql/9.1/= bin/postgres=0Apostgres 31356 postgres =A0mem =A0 =A0REG =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A08,3 =A0 =A051712 =A0 =A0772341 /lib/libnss_files-2.11.1.so= =0Apostgres 31356 postgres =A0DEL =A0 =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A00,4 =A0 =A0 =A0 =A0 =A0 =A0 819200 /SYSV0052e2c1=0Apostgres 31356 postgr= es =A0mem =A0 =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,3 =A0 =A014344 =A0 = =A0 =A02282 /lib/libgpg-error.so.0.4.0=0Apostgres 31356 postgres =A0mem =A0= =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,3 =A0 491000 =A0 =A0 =A01699 /lib/= libgcrypt.so.11.5.2=0Apostgres 31356 postgres =A0mem =A0 =A0REG =A0 =A0 =A0= =A0 =A0 =A0 =A0 =A08,3 =A0 =A067896 268818565 /usr/lib/libtasn1.so.3.1.7= =0Apostgres 31356 postgres =A0DEL =A0 =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A08,3 =A0 =A0 =A0 =A0 =A0273434018 /usr/lib/libgnutls.so.26.14.12=0Apostgr= es 31356 postgres =A0mem =A0 =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,3 =A0 = 105232=A0268940921 /usr/lib/libsasl2.so.2.0.23=0Apostgres 31356 postgres = =A0DEL =A0 =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,3 =A0 =A0 =A0 =A0 =A0268= 574412 /usr/lib/liblber-2.4.so.2.5.4=0Apostgres 31356 postgres =A0mem =A0 = =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,3 =A0 135745 =A0 =A0772336 /lib/lib= pthread-2.11.1.so=0Apostgres 31356 postgres =A0mem =A0 =A0REG =A0 =A0 =A0 = =A0 =A0 =A0 =A0 =A08,3 =A0 =A093000 =A0 =A0772321 /lib/libresolv-2.11.1.so= =0Apostgres 31356 postgres =A0mem =A0 =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A08,3 =A0 =A010224 =A0 =A0 =A02300 /lib/libkeyutils-1.2.so=0Apostgres 3135= 6 postgres =A0mem =A0 =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,3 =A0 =A03116= 8 268572617 /usr/lib/libkrb5support.so.0.1=0Apostgres 31356 postgres =A0mem= =A0 =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,3 =A0 154048 268807360 /usr/li= b/libk5crypto.so.3.1=0Apostgres 31356 postgres =A0mem =A0 =A0REG =A0 =A0 = =A0 =A0 =A0 =A0 =A0 =A08,3 =A0 =A043296 =A0 =A0614766 /lib/libcrypt-2.11.1.= so=0Apostgres 31356 postgres =A0mem =A0 =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A08,3 =A0 =A092752 =A0 =A0 79191 /lib/libz.so.1.2.3.3=0Apostgres 31356 pos= tgres =A0mem =A0 =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,3 =A01572232 =A0 = =A0772338 /lib/libc-2.11.1.so=0Apostgres 31356 postgres =A0DEL =A0 =A0REG = =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,3 =A0 =A0 =A0 =A0 =A0268574415 /usr/lib/li= bldap_r-2.4.so.2.5.4=0Apostgres 31356 postgres =A0mem =A0 =A0REG =A0 =A0 = =A0 =A0 =A0 =A0 =A0 =A08,3 =A0 534832 =A0 =A0 60426 /lib/libm-2.11.1.so=0Ap= ostgres 31356 postgres =A0mem =A0 =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,3= =A0 =A014696 =A0 =A0772342=A0/lib/libdl-2.11.1.so=0Apostgres 31356 postgre= s =A0mem =A0 =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,3 =A0 213784 268572618= /usr/lib/libgssapi_krb5.so.2.2=0Apostgres 31356 postgres =A0mem =A0 =A0REG= =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,3 =A0 =A014584 =A0 =A0 =A0 495 /lib/libco= m_err.so.2.1=0Apostgres 31356 postgres =A0mem =A0 =A0REG =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A08,3 =A0 803192 268807473 /usr/lib/libkrb5.so.3.3=0Apostgres = 31356 postgres =A0mem =A0 =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,3 =A01626= 400 =A0 =A0 =A0 772 /lib/libcrypto.so.0.9.8=0Apostgres 31356 postgres =A0me= m =A0 =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,3 =A0 333904 =A0 2849994 /lib= /libssl.so.0.9.8=0Apostgres 31356 postgres =A0mem =A0 =A0REG =A0 =A0 =A0 = =A0 =A0 =A0 =A0 =A08,3 =A0 =A051776 =A0 =A0 =A01263 /lib/libpam.so.0.82.2= =0Apostgres 31356 postgres =A0mem =A0 =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A08,3 =A01372344 268818714 /usr/lib/libxml2.so.2.7.6=0Apostgres 31356 post= gres =A0mem =A0 =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,3 =A0 136936 =A0 = =A0 60428 /lib/ld-2.11.1.so=0Apostgres 31356 postgres =A0mem =A0 =A0REG =A0= =A0 =A0 =A0 =A0 =A0 =A0 =A08,3 =A0 =A0 2459 402716943 /usr/lib/locale/en_U= S/LC_TIME=0Apostgres 31356 postgres =A0mem =A0 =A0REG =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A08,3 =A0 =A0 =A0 59 402716942 /usr/lib/locale/en_US/LC_NUMERIC=0A= postgres 31356 postgres =A0mem =A0 =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,= 3 =A0 =A0 =A0291 402716945 /usr/lib/locale/en_US/LC_MONETARY=0Apostgres 313= 56 postgres =A0mem =A0 =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,3 =A0 =A0 = =A0 62 =A0 =A0 =A04366 /usr/lib/locale/en_US/LC_MESSAGES/SYS_LC_MESSAGES=0A= postgres 31356 postgres =A0mem =A0 =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,= 3 =A0 221612 402716941 /usr/lib/locale/en_US/LC_CTYPE=0Apostgres 31356 post= gres =A0mem =A0 =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,3 =A0 =A019459 4027= 16944 /usr/lib/locale/en_US/LC_COLLATE=0Apostgres 31356 postgres =A0 =A00r = =A0 CHR =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A01,3 =A0 =A0 =A00t0 =A0 =A0 =A01344 /= dev/null=0Apostgres 31356 postgres =A0 =A01u =A0 CHR =A0 =A0 =A0 =A0 =A0 = =A0 =A0136,1 =A0 =A0 =A00t0 =A0 =A0 =A0 =A0 4 /dev/pts/1 (deleted)=0Apostgr= es 31356 postgres =A0 =A02u =A0 CHR =A0 =A0 =A0 =A0 =A0 =A0 =A0136,1 =A0 = =A0 =A00t0 =A0 =A0 =A0 =A0 4 /dev/pts/1 (deleted)=0Apostgres 31356 postgres= =A0 =A03u =A0IPv4 =A0 =A0 =A0 =A0 =A0392650125 =A0 =A0 =A00t0 =A0 =A0 =A0 = TCP *:postgresql (LISTEN)=0Apostgres 31356 postgres =A0 =A04u =A0IPv6 =A0 = =A0 =A0 =A0 =A0392650126 =A0 =A0 =A00t0 =A0 =A0 =A0 TCP *:postgresql (LISTE= N)=0Apostgres 31356 postgres =A0 =A05u =A0unix 0xffff88005142e100 =A0 =A0 = =A00t0 392650128 /var/run/postgresql/.s.PGSQL.5432=0Apostgres 31356 postgre= s =A0 =A06u =A0IPv6 =A0 =A0 =A0 =A0 =A0392650136 =A0 =A0 =A00t0 =A0 =A0 =A0= UDP localhost:21771->localhost:21771=A0=0Apostgres 31356 postgres =A0 =A07= u =A0unix 0xffff88005142db00 =A0 =A0 =A00t0 392679151 socket=0A=0AAFTER:=0A= $ sudo lsof -p 4382 -a=0ACOMMAND =A0 PID =A0 =A0 USER =A0 FD =A0 TYPE =A0 = =A0 =A0 =A0 =A0 =A0 DEVICE SIZE/OFF =A0 =A0 =A0NODE NAME=0Apostgres 4382 po= stgres =A0cwd =A0 =A0DIR =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,3 =A0 =A0 4096 26= 9834294 /var/lib/postgresql/9.1/main=0Apostgres 4382 postgres =A0rtd =A0 = =A0DIR =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,3 =A0 =A0 4096 =A0 =A0 =A0 128 /=0A= postgres 4382 postgres =A0txt =A0 =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,3= =A05430480 =A037149754 /usr/lib/postgresql/9.1/bin/postgres=0Apostgres 438= 2 postgres =A0mem =A0 =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,3 =A0 =A05171= 2 =A0 =A0772341 /lib/libnss_files-2.11.1.so=0Apostgres 4382 postgres =A0DEL= =A0 =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A00,4 =A0 =A0 =A0 =A0 =A0 =A0 8847= 36 /SYSV0052e2c1=0Apostgres 4382 postgres =A0mem =A0 =A0REG =A0 =A0 =A0 =A0= =A0 =A0 =A0 =A08,3 =A0 =A014344 =A0 =A0 =A02282 /lib/libgpg-error.so.0.4.0= =0Apostgres 4382 postgres =A0mem =A0 =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0= 8,3 =A0 491000 =A0 =A0 =A01699 /lib/libgcrypt.so.11.5.2=0Apostgres 4382 pos= tgres =A0mem =A0 =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,3 =A0 =A067896 268= 818565 /usr/lib/libtasn1.so.3.1.7=0Apostgres 4382 postgres =A0mem =A0 =A0RE= G =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,3 =A0 663816 268573983 /usr/lib/libgnutl= s.so.26.14.12=0Apostgres 4382 postgres =A0mem =A0 =A0REG =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A08,3 =A0 105232=A0268940921 /usr/lib/libsasl2.so.2.0.23=0Apos= tgres 4382 postgres =A0mem =A0 =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,3 = =A0 =A055568 268573988 /usr/lib/liblber-2.4.so.2.5.4=0Apostgres 4382 postgr= es =A0mem =A0 =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,3 =A0 135745 =A0 =A07= 72336 /lib/libpthread-2.11.1.so=0Apostgres 4382 postgres =A0mem =A0 =A0REG = =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,3 =A0 =A093000 =A0 =A0772321 /lib/libresol= v-2.11.1.so=0Apostgres 4382 postgres =A0mem =A0 =A0REG =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A08,3 =A0 =A010224 =A0 =A0 =A02300 /lib/libkeyutils-1.2.so=0Apostg= res 4382 postgres =A0mem =A0 =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,3 =A0 = =A031168 268572617 /usr/lib/libkrb5support.so.0.1=0Apostgres 4382 postgres = =A0mem =A0 =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,3 =A0 154048 268807360 /= usr/lib/libk5crypto.so.3.1=0Apostgres 4382 postgres =A0mem =A0 =A0REG =A0 = =A0 =A0 =A0 =A0 =A0 =A0 =A08,3 =A0 =A043296 =A0 =A0614766 /lib/libcrypt-2.1= 1.1.so=0Apostgres 4382 postgres =A0mem =A0 =A0REG =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A08,3 =A0 =A092752 =A0 =A0 79191 /lib/libz.so.1.2.3.3=0Apostgres 4382 = postgres =A0mem =A0 =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,3 =A01572232 = =A0 =A0772338 /lib/libc-2.11.1.so=0Apostgres 4382 postgres =A0mem =A0 =A0RE= G =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,3 =A0 302464 268573990 /usr/lib/libldap_= r-2.4.so.2.5.4=0Apostgres 4382 postgres =A0mem =A0 =A0REG =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A08,3 =A0 534832 =A0 =A0 60426 /lib/libm-2.11.1.so=0Apostgres = 4382 postgres =A0mem =A0 =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,3 =A0 =A01= 4696 =A0 =A0772342=A0/lib/libdl-2.11.1.so=0Apostgres 4382 postgres =A0mem = =A0 =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,3 =A0 213784 268572618 /usr/lib= /libgssapi_krb5.so.2.2=0Apostgres 4382 postgres =A0mem =A0 =A0REG =A0 =A0 = =A0 =A0 =A0 =A0 =A0 =A08,3 =A0 =A014584 =A0 =A0 =A0 495 /lib/libcom_err.so.= 2.1=0Apostgres 4382 postgres =A0mem =A0 =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A08,3 =A0 803192 268807473 /usr/lib/libkrb5.so.3.3=0Apostgres 4382 postgre= s =A0mem =A0 =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,3 =A01626400 =A0 =A0 = =A0 772 /lib/libcrypto.so.0.9.8=0Apostgres 4382 postgres =A0mem =A0 =A0REG = =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,3 =A0 333904 =A0 2849994 /lib/libssl.so.0.= 9.8=0Apostgres 4382 postgres =A0mem =A0 =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A08,3 =A0 =A051776 =A0 =A0 =A01263 /lib/libpam.so.0.82.2=0Apostgres 4382 p= ostgres =A0mem =A0 =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,3 =A01372344 268= 818714 /usr/lib/libxml2.so.2.7.6=0Apostgres 4382 postgres =A0mem =A0 =A0REG= =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,3 =A0 136936 =A0 =A0 60428 /lib/ld-2.11.1= .so=0Apostgres 4382 postgres =A0mem =A0 =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A08,3 =A0 =A0 2459 402716943 /usr/lib/locale/en_US/LC_TIME=0Apostgres 4382= postgres =A0mem =A0 =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,3 =A0 =A0 =A0 = 59 402716942 /usr/lib/locale/en_US/LC_NUMERIC=0Apostgres 4382 postgres =A0m= em =A0 =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,3 =A0 =A0 =A0291 402716945 /= usr/lib/locale/en_US/LC_MONETARY=0Apostgres 4382 postgres =A0mem =A0 =A0REG= =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,3 =A0 =A0 =A0 62 =A0 =A0 =A04366 /usr/lib= /locale/en_US/LC_MESSAGES/SYS_LC_MESSAGES=0Apostgres 4382 postgres =A0mem = =A0 =A0REG =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A08,3 =A0 221612 402716941 /usr/lib= /locale/en_US/LC_CTYPE=0Apostgres 4382 postgres =A0mem =A0 =A0REG =A0 =A0 = =A0 =A0 =A0 =A0 =A0 =A08,3 =A0 =A019459 402716944 /usr/lib/locale/en_US/LC_= COLLATE=0Apostgres 4382 postgres =A0 =A00r =A0 CHR =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A01,3 =A0 =A0 =A00t0 =A0 =A0 =A01344 /dev/null=0Apostgres 4382 postgre= s =A0 =A01u =A0 CHR =A0 =A0 =A0 =A0 =A0 =A0 =A0136,2 =A0 =A0 =A00t0 =A0 =A0= =A0 =A0 5 /dev/pts/2=0Apostgres 4382 postgres =A0 =A02u =A0 CHR =A0 =A0 = =A0 =A0 =A0 =A0 =A0136,2 =A0 =A0 =A00t0 =A0 =A0 =A0 =A0 5 /dev/pts/2=0Apost= gres 4382 postgres =A0 =A03u =A0IPv4 =A0 =A0 =A0 =A0 =A0502242690 =A0 =A0 = =A00t0 =A0 =A0 =A0 TCP *:postgresql (LISTEN)=0Apostgres 4382 postgres =A0 = =A04u =A0IPv6 =A0 =A0 =A0 =A0 =A0502242691 =A0 =A0 =A00t0 =A0 =A0 =A0 TCP *= :postgresql (LISTEN)=0Apostgres 4382 postgres =A0 =A05u =A0unix 0xffff88042= b7f8600 =A0 =A0 =A00t0 502242693 /var/run/postgresql/.s.PGSQL.5432=0Apostgr= es 4382 postgres =A0 =A06u =A0IPv6 =A0 =A0 =A0 =A0 =A0502242701 =A0 =A0 =A0= 0t0 =A0 =A0 =A0 UDP localhost:18554->localhost:18554=A0=0Apostgres 4382 pos= tgres =A0 =A07u =A0unix 0xffff88042a250000 =A0 =A0 =A00t0 502242789 socket= =0A