Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sjtFW-005FO3-2f for pgsql-general@arkaria.postgresql.org; Fri, 30 Aug 2024 04:28:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sjtFS-00Dgwq-D2 for pgsql-general@arkaria.postgresql.org; Fri, 30 Aug 2024 04:28:34 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sjtFR-00Dgwh-V1 for pgsql-general@lists.postgresql.org; Fri, 30 Aug 2024 04:28:34 +0000 Received: from mail-yw1-x112a.google.com ([2607:f8b0:4864:20::112a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sjtFO-002Bsl-Mi for pgsql-general@postgresql.org; Fri, 30 Aug 2024 04:28:33 +0000 Received: by mail-yw1-x112a.google.com with SMTP id 00721157ae682-6b8d96aa4c3so11860657b3.1 for ; Thu, 29 Aug 2024 21:28:31 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1724992110; x=1725596910; darn=postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=2wikcH0DTCIebtN0nM4ysGYRWb7JnqWo69IiBp/qEoI=; b=X8JjlE1c5lNNfWGUTLqsDvLGja9fz7nVrXvLpEHbtkYPs1qvXuPRzuhXD2ylplAAJY ZEWxYHVnAMyStrMcWZjUC29CJnkA57qK+cyb8iz31XQWLfpZcpXM3QGbZnoOFygWjgDn 5CfQt4S/Bbit62XVIxtAqY/Cug3xkRIGy0zlb4ZqbxwZuHTwxq2BhBDdHURJGKFSnyqY 1jnb9HvQxrCh2DDC0JLHLtjyDBdq0kLnPTb6TXnfxdMBNP1x8xYP8pAhLzhiBqSmIXGC A/WDBcO6+GFu6oxEe4P8FFQtJ2I5FPNuOQhq2TYotWlMdtVGsrb9T9iU1OG9F+FYg7+w 0kRA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1724992110; x=1725596910; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=2wikcH0DTCIebtN0nM4ysGYRWb7JnqWo69IiBp/qEoI=; b=SOCXNC4vJE/MUUAWSf2RAizwfYquevOi66u3KBfKBUSi0ruevA78pHDvxBz+9e0iXw 8KqPM6cdfwRBdYuGh7oQL/bI4krRpkkSWu+NZ7CIbo0O/7FJgFbdANxHs9bsCVtf3gar GKxSfgMZCR4mAposHJ5Ws3+V8aU2iXqMR2atS35veuuszPiIrEf/ChZZaZBuPbJ3fFng +WhkHon01JBIs1Bs4bzziAaoRvNTw8qtow1OylSD9u8VbRWE96QNAk3QcC7u8g73Qw29 GH4SC7U8p0gwoDhxN3yStAnGpI5a82l8MOjR7UAC5HO2CJdqpfKnrUayJT3mmuTS+Xak ZVNA== X-Gm-Message-State: AOJu0YzLoBII5Oifn3+wQsF44hctQ3InrTEbWADKV6aWA0GJvjnIIG6N XDiGmjNUvWd+CWjT/V2yBNIiLGiw9IN6EiZAJzQv0TaznvDAD/P/1QGq3G3EHEwRjuOyAXQu1r3 3nGanMSb2EKPJuj/UixjrVVGVKqk5eT9R X-Google-Smtp-Source: AGHT+IGx8nIFvVI8oaysCzox10IGoEei7zWVGqWIXMywd9E7Ko/0YNyMDJnnowcYmTZ7R5XdnTjLDGfxgOOxJTTvaCU= X-Received: by 2002:a05:690c:7288:b0:6b0:5b38:5a33 with SMTP id 00721157ae682-6d40e2872d3mr9245357b3.20.1724992109725; Thu, 29 Aug 2024 21:28:29 -0700 (PDT) MIME-Version: 1.0 From: KK CHN Date: Fri, 30 Aug 2024 09:58:38 +0530 Message-ID: Subject: PgBackRest full backup first time : Verification To: pgsql-general Content-Type: multipart/alternative; boundary="000000000000f0d3ed0620df054c" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000f0d3ed0620df054c Content-Type: text/plain; charset="UTF-8" List, pgbackrest backup what all the directories and files PgBackRest will backup to RepoServer when performing backup using PgBackRest. ( Because of a limited infr ( N/W bandwidth 8Mbps between DB Server and RepoServer) . 1. I am not sure the pgbackrest command finished output message in the console is true due to the following facts. i) . My ILL - SSL VPN connection (8Mbps link) reset in between 3 to 4 times during the backup process span of 12 hours I reissued the pgbackrest backup command 3 to 4 time in this span) ii) EPAS installation dir /data/edb/as16/data showing 4.5 G only, iii) /data/edb/as16/tablespace shows 149G iv) /data Dir shows 537 G and v) /data/edb/as16/tablespace 149G for du -h command output. Kindly share your thoughts does the pgbackrest backup command ( for the first time run) performed as expected .. (Which shows in command line as finished and subsequent reissue of the same command finishes in seconds ) I can't restore back to the DB server right now to test it as it is a production server and down time granting is not immediately possible to test it ... Thank you, Krishane [root@db1 data]# pwd /data [root@db1 data]# du -h returns 537 G and [root@db1 data]# cd /data/edb/as16/data/ [root@db1 data]# pwd /data/edb/as16/data [root@db1 data]# du -h Returns 4.5G Query : 1 PgbackRest Initial full backup will copy what ? /data/edb/as16/data dir of size 4.5 G? or /data Dir of 537 G ? // I think this won't ? As my pgbackrest command issued initially finishes with following output for info command # sudo -u postgres pgbackrest --stanza=Repo --log-level-console=info backup //performed this & once it finishes I reissued this command two times again(in suspicion as I left it overnight for the backup to complete) that's why I think 2 incr backups showing here. and [root@dbtest ~]# sudo -u postgres pgbackrest info stanza: Repo status: ok cipher: aes-256-cbc db (current) wal archive min/max (16): 00000001000000830000005F/000000010000008700000019 full backup: 20240829-105625F timestamp start/stop: 2024-08-29 18:53:32+05:30 / 2024-08-29 20:24:13+05:30 wal start/stop: 000000010000008600000063 / 000000010000008600000074 database size: 146.9GB, database backup size: 146.9GB repo1: backup size: 20.6GB ### Where this 146.9 GB from ( please find the file system du -h pasted bottom of this post) incr backup: 20240829-105625F_20240830-084303I timestamp start/stop: 2024-08-30 08:43:03+05:30 / 2024-08-30 08:50:46+05:30 wal start/stop: 00000001000000870000000E / 000000010000008700000010 database size: 148GB, database backup size: 4.7GB repo1: backup size: 170.4MB backup reference list: 20240829-105625F incr backup: 20240829-105625F_20240830-090729I timestamp start/stop: 2024-08-30 09:07:29+05:30 / 2024-08-30 09:12:50+05:30 wal start/stop: 000000010000008700000015 / 000000010000008700000016 database size: 148.1GB, database backup size: 1GB repo1: backup size: 13.2MB backup reference list: 20240829-105625F, 20240829-105625F_20240830-084303I [root@dbtest ~]# For more information about the DB cluster file system Find the paste below [root@db1 data]# pwd /data [root@db1 data]# cd /data/edb/as16/data [root@db1 data]# pwd /data/edb/as16/data [root@db1 data]# du -h 20K ./pg_wal/archive_status 4.1G ./pg_wal 1.5M ./global 0 ./pg_commit_ts 0 ./pg_dynshmem 0 ./pg_notify 0 ./pg_serial 0 ./pg_snapshots 56K ./pg_subtrans 0 ./pg_twophase 3.0M ./pg_multixact/members 1.2M ./pg_multixact/offsets 4.1M ./pg_multixact 15M ./base/1 15M ./base/4 15M ./base/5 15M ./base/15355 15M ./base/42613 28M ./base/43102 0 ./base/pgsql_tmp 40K ./base/44497 100M ./base 0 ./pg_replslot 0 ./pg_tblspc 0 ./pg_stat 0 ./pg_stat_tmp 48M ./pg_xact 0 ./pg_logical/snapshots 0 ./pg_logical/mappings 4.0K ./pg_logical 280M ./log 0 ./dbms_pipe 4.5G . [root@db1 data]# cd pg_tblspc/ [root@db1 pg_tblspc]# du -h 0 . [root@db1 pg_tblspc]# ls -al total 4 drwxr-xr-x. 2 enterprisedb enterprisedb 110 Jun 14 14:17 . drwx------. 21 enterprisedb enterprisedb 4096 Aug 30 00:00 .. lrwxrwxrwx. 1 enterprisedb enterprisedb 38 Jun 14 14:17 16388 -> /data/edb/as16/tablespace/ESS/SER/DAT lrwxrwxrwx. 1 enterprisedb enterprisedb 38 Jun 14 14:17 16389 -> /data/edb/as16/tablespace/ESS/SER/IDX lrwxrwxrwx. 1 enterprisedb enterprisedb 38 Jun 14 14:17 16390 -> /data/edb/as16/tablespace/ESS/GIS/DAT lrwxrwxrwx. 1 enterprisedb enterprisedb 38 Jun 14 14:17 16391 -> /data/edb/as16/tablespace/ESS/GIS/IDX lrwxrwxrwx. 1 enterprisedb enterprisedb 38 Jun 14 14:17 16392 -> /data/edb/as16/tablespace/ESS/RPT/DAT lrwxrwxrwx. 1 enterprisedb enterprisedb 38 Jun 14 14:17 16393 -> /data/edb/as16/tablespace/ESS/RPT/IDX lrwxrwxrwx. 1 enterprisedb enterprisedb 38 Jun 14 14:17 16394 -> /data/edb/as16/tablespace/ESS/TSP/DAT lrwxrwxrwx. 1 enterprisedb enterprisedb 38 Jun 14 14:17 16395 -> /data/edb/as16/tablespace/ESS/TSP/IDX [root@db1 pg_tblspc]# du -h 0 . [root@db1 pg_tblspc]# pwd /data/edb/as16/data/pg_tblspc [root@db1]# cd /data/edb/as16/tablespace [root@db1 tablespace]# pwd /data/edb/as16/tablespace . [root@db1 tablespace]#du -h /data/edb/as16/tablespace/ 22M /data/edb/as16/tablespace/ESS/SER/DAT/PG_16_202307071/44494 121G /data/edb/as16/tablespace/ESS/SER/DAT/PG_16_202307071/44496 0 /data/edb/as16/tablespace/ESS/SER/DAT/PG_16_202307071/pgsql_tmp 121G /data/edb/as16/tablespace/ESS/SER/DAT/PG_16_202307071 121G /data/edb/as16/tablespace/ESS/SER/DAT 0 /data/edb/as16/tablespace/ESS/SER/IDX/PG_16_202307071 0 /data/edb/as16/tablespace/ESS/SER/IDX 121G /data/edb/as16/tablespace/ESS/SER 94M /data/edb/as16/tablespace/ESS/GIS/DAT/PG_16_202307071/44495 40K /data/edb/as16/tablespace/ESS/GIS/DAT/PG_16_202307071/44497 94M /data/edb/as16/tablespace/ESS/GIS/DAT/PG_16_202307071 94M /data/edb/as16/tablespace/ESS/GIS/DAT 0 /data/edb/as16/tablespace/ESS/GIS/IDX/PG_16_202307071 0 /data/edb/as16/tablespace/ESS/GIS/IDX 94M /data/edb/as16/tablespace/ESS/GIS 15M /data/edb/as16/tablespace/ESS/RPT/DAT/PG_16_202307071/44498 15M /data/edb/as16/tablespace/ESS/RPT/DAT/PG_16_202307071 15M /data/edb/as16/tablespace/ESS/RPT/DAT 0 /data/edb/as16/tablespace/ESS/RPT/IDX/PG_16_202307071 0 /data/edb/as16/tablespace/ESS/RPT/IDX 15M /data/edb/as16/tablespace/ESS/RPT 28G /data/edb/as16/tablespace/ESS/TSP/DAT/PG_16_202307071/44497 0 /data/edb/as16/tablespace/ESS/TSP/DAT/PG_16_202307071/pgsql_tmp 28G /data/edb/as16/tablespace/ESS/TSP/DAT/PG_16_202307071 28G /data/edb/as16/tablespace/ESS/TSP/DAT 0 /data/edb/as16/tablespace/ESS/TSP/IDX/PG_16_202307071 0 /data/edb/as16/tablespace/ESS/TSP/IDX 28G /data/edb/as16/tablespace/ESS/TSP 149G /data/edb/as16/tablespace/ESS 149G /data/edb/as16/tablespace/ [root@db1 tablespace]# --000000000000f0d3ed0620df054c Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
List,=C2=A0

pgbackrest=C2=A0 backup=C2= =A0 what all the directories and files=C2=A0 PgBackRest will backup to Repo= Server when performing backup using PgBackRest.=C2=A0 ( Because of a limite= d infr ( N/W bandwidth 8Mbps between DB Server and RepoServer) .
=
1.=C2=A0 =C2=A0I am not sure the pgbackrest command finished= output message in the console is true due to the following facts.
=C2=A0i) .=C2=A0 =C2=A0My ILL - SSL VPN connection (8Mbps link) reset in = between 3 to 4 times during the backup process span of 12 hours I reissued = the pgbackrest backup command 3 to 4 time in this span)
=C2=A0ii)= =C2=A0 EPAS=C2=A0 =C2=A0installation dir=C2=A0 =C2=A0/data/edb/as16/data sh= owing 4.5 G only,=C2=A0
iii) /data/edb/as16/tablespace shows 149G= =C2=A0=C2=A0
iv)=C2=A0 /data=C2=A0 Dir shows=C2=A0 537 G=C2=A0 = =C2=A0 and
v)=C2=A0 =C2=A0 /data/edb/as16/tablespace=C2=A0 =C2=A0= 149G=C2=A0 =C2=A0for=C2=A0 =C2=A0 =C2=A0du=C2=A0 -h command=C2=A0 output.<= /div>


Kindly share your thoughts does the= =C2=A0 =C2=A0pgbackrest backup command ( for the first time run) performed = as expected ..=C2=A0 =C2=A0(Which shows in command line as finished and sub= sequent reissue of the same command finishes in seconds )=C2=A0
<= br>
I can't=C2=A0 restore back to the DB server right now to = test it as it is a production server and down time granting is not immediat= ely possible to test it ...



Thank you,
Krishane



[root@db1 data]# pwd
/data
[root@db1 data]# du -h
returns=C2=A0 =C2=A0537 G

and

=C2=A0
[root@db1 data]# cd /data/edb/as16/d= ata/
[root@db1 data]# pwd
/data/edb/as16/data
[root@db1 data]# du = -h

Returns 4.5G


<= /div>


Query :=C2=A0 1=C2=A0 PgbackRest Initial=C2=A0 full backup=C2= =A0 will copy=C2=A0 what ?=C2=A0 =C2=A0/data/edb/as16/data=C2=A0 dir=C2=A0 = of size 4.5 G?=C2=A0=C2=A0

or=C2=A0 =C2=A0 = =C2=A0/data=C2=A0 Dir of 53= 7 G=C2=A0 ?=C2=A0 // I think this won't ?=C2=A0=C2=A0
=
As my=C2=A0 pgbackrest command=C2=A0 issued initially finishes=C2=A0 with following out= put for info command

=C2=A0#=C2=A0sudo -u p= ostgres pgbackrest --stanza=3DRepo --log-level-console=3Dinfo backup=C2=A0 = //performed this=C2=A0

&=C2=A0 once it finishe= s=C2=A0 I reissued this command two times again(in suspicion=C2=A0as=C2=A0 = I left it overnight for the backup to complete) that's why I think 2 in= cr backups showing here.=C2=A0

and=C2=A0

[root@dbtest ~]# sudo -u postgres pgbackrest info
stanza= : Repo
=C2=A0 =C2=A0 status: ok
=C2=A0 =C2=A0 cipher: aes-256-cbc
=
=C2=A0 =C2=A0 db (current)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 wal archive m= in/max (16): 00000001000000830000005F/000000010000008700000019

=C2= =A0 =C2=A0 =C2=A0 =C2=A0 full backup: 20240829-105625F
=C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 timestamp start/stop: 2024-08-29 18:53:32+05:30 / = 2024-08-29 20:24:13+05:30
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 wal = start/stop: 000000010000008600000063 / 000000010000008600000074
=C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 database size: 146.9GB, database backup = size: 146.9GB
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 repo1: backup si= ze: 20.6GB

=C2=A0 ### Where this 146.9 GB=C2=A0 =C2=A0 from=C2=A0 (=C2=A0 please find the file = system du -h pasted bottom of this post)


=C2=A0 = =C2=A0 =C2=A0 =C2=A0 incr backup: 20240829-105625F_20240830-084303I
=C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 timestamp start/stop: 2024-08-30 08:= 43:03+05:30 / 2024-08-30 08:50:46+05:30
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 wal start/stop: 00000001000000870000000E / 000000010000008700000= 010
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 database size: 148GB, data= base backup size: 4.7GB
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 repo1:= backup size: 170.4MB
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 backup r= eference list: 20240829-105625F

=C2=A0 =C2=A0 =C2=A0 =C2=A0 incr bac= kup: 20240829-105625F_20240830-090729I
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 timestamp start/stop: 2024-08-30 09:07:29+05:30 / 2024-08-30 09:= 12:50+05:30
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 wal start/stop: 00= 0000010000008700000015 / 000000010000008700000016
=C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 database size: 148.1GB, database backup size: 1GB
= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 repo1: backup size: 13.2MB
=C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 backup reference list: 20240829-1056= 25F, 20240829-105625F_20240830-084303I
[root@dbtest ~]#



For more information about the DB cluster fi= le system=C2=A0 Find the=C2=A0 paste below
[root@db1 data]= # pwd
/data

[root@db1 data]# cd /data/edb/as16/da= ta
[root@db1 data]# pwd
/data/edb/as16/data
= [root@db1 data]# du -h
20K =C2=A0 =C2=A0 ./pg_wal/archive_status4.1G =C2=A0 =C2=A0./pg_wal
1.5M =C2=A0 =C2=A0./global
0 =C2=A0 =C2= =A0 =C2=A0 ./pg_commit_ts
0 =C2=A0 =C2=A0 =C2=A0 ./pg_dynshmem
0 =C2= =A0 =C2=A0 =C2=A0 ./pg_notify
0 =C2=A0 =C2=A0 =C2=A0 ./pg_serial
0 = =C2=A0 =C2=A0 =C2=A0 ./pg_snapshots
56K =C2=A0 =C2=A0 ./pg_subtrans
0= =C2=A0 =C2=A0 =C2=A0 ./pg_twophase
3.0M =C2=A0 =C2=A0./pg_multixact/mem= bers
1.2M =C2=A0 =C2=A0./pg_multixact/offsets
4.1M =C2=A0 =C2=A0./pg_= multixact
15M =C2=A0 =C2=A0 ./base/1
15M =C2=A0 =C2=A0 ./base/4
15= M =C2=A0 =C2=A0 ./base/5
15M =C2=A0 =C2=A0 ./base/15355
15M =C2=A0 = =C2=A0 ./base/42613
28M =C2=A0 =C2=A0 ./base/43102
0 =C2=A0 =C2=A0 = =C2=A0 ./base/pgsql_tmp
40K =C2=A0 =C2=A0 ./base/44497
100M =C2=A0 = =C2=A0./base
0 =C2=A0 =C2=A0 =C2=A0 ./pg_replslot
0 =C2=A0 =C2=A0 =C2= =A0 ./pg_tblspc
0 =C2=A0 =C2=A0 =C2=A0 ./pg_stat
0 =C2=A0 =C2=A0 =C2= =A0 ./pg_stat_tmp
48M =C2=A0 =C2=A0 ./pg_xact
0 =C2=A0 =C2=A0 =C2=A0 = ./pg_logical/snapshots
0 =C2=A0 =C2=A0 =C2=A0 ./pg_logical/mappings
4= .0K =C2=A0 =C2=A0./pg_logical
280M =C2=A0 =C2=A0./log
0 =C2=A0 =C2=A0= =C2=A0 ./dbms_pipe
4.5G =C2=A0 =C2=A0.


[ro= ot@db1 data]# cd pg_tblspc/
[root@db1 pg_tblspc]# du -h
0 =C2=A0 =C2= =A0 =C2=A0 .
[root@db1 pg_tblspc]# ls -al
total 4
drwxr-xr-x. =C2= =A02 enterprisedb enterprisedb =C2=A0110 Jun 14 14:17 .
drwx------. 21 e= nterprisedb enterprisedb 4096 Aug 30 00:00 ..
lrwxrwxrwx. =C2=A01 enterp= risedb enterprisedb =C2=A0 38 Jun 14 14:17 16388 -> /data/edb/as16/table= space/ESS/SER/DAT
lrwxrwxrwx. =C2=A01 enterprisedb enterprisedb =C2=A0 3= 8 Jun 14 14:17 16389 -> /data/edb/as16/tablespace/ESS/SER/IDX
lrwxrwx= rwx. =C2=A01 enterprisedb enterprisedb =C2=A0 38 Jun 14 14:17 16390 -> /= data/edb/as16/tablespace/ESS/GIS/DAT
lrwxrwxrwx. =C2=A01 enterprisedb en= terprisedb =C2=A0 38 Jun 14 14:17 16391 -> /data/edb/as16/tablespace/ESS= /GIS/IDX
lrwxrwxrwx. =C2=A01 enterprisedb enterprisedb =C2=A0 38 Jun 14 = 14:17 16392 -> /data/edb/as16/tablespace/ESS/RPT/DAT
lrwxrwxrwx. =C2= =A01 enterprisedb enterprisedb =C2=A0 38 Jun 14 14:17 16393 -> /data/edb= /as16/tablespace/ESS/RPT/IDX
lrwxrwxrwx. =C2=A01 enterprisedb enterprise= db =C2=A0 38 Jun 14 14:17 16394 -> /data/edb/as16/tablespace/ESS/TSP/DAT=
lrwxrwxrwx. =C2=A01 enterprisedb enterprisedb =C2=A0 38 Jun 14 14:17 16= 395 -> /data/edb/as16/tablespace/ESS/TSP/IDX
[root@db1 pg_tblspc]# du= -h
0 =C2=A0 =C2=A0 =C2=A0 .
[root@db1 pg_tblspc]# pwd
/data/edb/a= s16/data/pg_tblspc

[root@db1]# cd /data/edb/as16/tablespa= ce
[root@db1 tablespace]# pwd
/data/edb/as16/tablespace
.
[root@db1 tablespace]#du -h /data/edb/as16/tablespa= ce/
22M =C2=A0 =C2=A0 /data/edb/as16/tablespace/ESS/SER/DAT/PG_16_202307= 071/44494
121G =C2=A0 =C2=A0/data/edb/as16/tablespace/ESS/SER/DAT/PG_16_= 202307071/44496
0 =C2=A0 =C2=A0 =C2=A0 /data/edb/as16/tablespace/ESS/SER= /DAT/PG_16_202307071/pgsql_tmp
121G =C2=A0 =C2=A0/data/edb/as16/tablespa= ce/ESS/SER/DAT/PG_16_202307071
121G =C2=A0 =C2=A0/data/edb/as16/tablespa= ce/ESS/SER/DAT
0 =C2=A0 =C2=A0 =C2=A0 /data/edb/as16/tablespace/ESS/SER/= IDX/PG_16_202307071
0 =C2=A0 =C2=A0 =C2=A0 /data/edb/as16/tablespace/ESS= /SER/IDX
121G =C2=A0 =C2=A0/data/edb/as16/tablespace/ESS/SER
94M =C2= =A0 =C2=A0 /data/edb/as16/tablespace/ESS/GIS/DAT/PG_16_202307071/44495
4= 0K =C2=A0 =C2=A0 /data/edb/as16/tablespace/ESS/GIS/DAT/PG_16_202307071/4449= 7
94M =C2=A0 =C2=A0 /data/edb/as16/tablespace/ESS/GIS/DAT/PG_16_20230707= 1
94M =C2=A0 =C2=A0 /data/edb/as16/tablespace/ESS/GIS/DAT
0 =C2=A0 = =C2=A0 =C2=A0 /data/edb/as16/tablespace/ESS/GIS/IDX/PG_16_202307071
0 = =C2=A0 =C2=A0 =C2=A0 /data/edb/as16/tablespace/ESS/GIS/IDX
94M =C2=A0 = =C2=A0 /data/edb/as16/tablespace/ESS/GIS
15M =C2=A0 =C2=A0 /data/edb/as1= 6/tablespace/ESS/RPT/DAT/PG_16_202307071/44498
15M =C2=A0 =C2=A0 /data/e= db/as16/tablespace/ESS/RPT/DAT/PG_16_202307071
15M =C2=A0 =C2=A0 /data/e= db/as16/tablespace/ESS/RPT/DAT
0 =C2=A0 =C2=A0 =C2=A0 /data/edb/as16/tab= lespace/ESS/RPT/IDX/PG_16_202307071
0 =C2=A0 =C2=A0 =C2=A0 /data/edb/as1= 6/tablespace/ESS/RPT/IDX
15M =C2=A0 =C2=A0 /data/edb/as16/tablespace/ESS= /RPT
28G =C2=A0 =C2=A0 /data/edb/as16/tablespace/ESS/TSP/DAT/PG_16_20230= 7071/44497
0 =C2=A0 =C2=A0 =C2=A0 /data/edb/as16/tablespace/ESS/TSP/DAT/= PG_16_202307071/pgsql_tmp
28G =C2=A0 =C2=A0 /data/edb/as16/tablespace/ES= S/TSP/DAT/PG_16_202307071
28G =C2=A0 =C2=A0 /data/edb/as16/tablespace/ES= S/TSP/DAT
0 =C2=A0 =C2=A0 =C2=A0 /data/edb/as16/tablespace/ESS/TSP/IDX/P= G_16_202307071
0 =C2=A0 =C2=A0 =C2=A0 /data/edb/as16/tablespace/ESS/TSP/= IDX
28G =C2=A0 =C2=A0 /data/edb/as16/tablespace/ESS/TSP
149G =C2=A0 = =C2=A0/data/edb/as16/tablespace/ESS
149G =C2=A0 =C2=A0/data/edb/as16/tab= lespace/
[root@db1 tablespace]#


<= /div> --000000000000f0d3ed0620df054c--